# | Column Name | Max Size | Data Type |
---|---|---|---|
1 | DELETED_DATE_TIME | DATETIME | |
2 | USER_ID | 10 | VARCHAR |
3 | LAST_NAME | 30 | VARCHAR |
4 | FIRST_NAME | 30 | VARCHAR |
5 | PASSWORD | 30 | VARCHAR |
6 | SECURITY_LEVEL | INT | |
7 | DEPT_CODE | 15 | VARCHAR |
8 | DATE_OF_BIRTH | DATETIME | |
9 | DRAWER_NUMBER | SMALLINT | |
10 | PHONE_NUMBER | 20 | VARCHAR |
11 | PHONE_EXTENSION | 10 | VARCHAR |
12 | FAX_NUMBER | 20 | VARCHAR |
13 | VOIDS_FLAG | BIT | |
14 | INQUIRY_FLAG | BIT | |
15 | STARTING_CASH | MONEY | |
16 | MAX_DRAWER_CASH | MONEY | |
17 | MAX_CASH_BACK | MONEY | |
18 | OLD_USER_ID | 3 | CHAR |
19 | EPWD | 100 | VARCHAR |
20 | PASSWORD_EXPIRES_DATE | DATETIME | |
21 | PWS | 40 | VARCHAR |
Created:09/22/2020 12:20:21