Table: DatabaseUsers
Primary Key: Username
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| User ID | Long | 4 | ✓ | |
| Username | Text | 255 | ✓ | ✓ |
| User Password | Text | 255 | ||
| LEVEL | Text | 255 | ||
| ForceChange | Boolean | 1 | ||
| Delivery Location ID | Long | 4 | ||
| Department | Text | 255 | ||
| Email Address | Text | 255 | ||
| Last Modified By | Text | 255 | ||
| Date Modified | DateTime | 8 | ||
| SSMA_TimeStamp | Binary | 8 | ✓ | |
| First Name | Text | 50 | ||
| Surname | Text | 50 | ||
| Cell Phone Number | Text | 50 |
Indexes
- DatabaseUsers$Delivery Location ID
- DatabaseUsers$PrimaryKey [PRIMARY KEY] [UNIQUE]