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