UserImportMasterList
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| RowIndex | int | |||
| LastName | nvarchar(50) | yes | ||
| FirstName | nvarchar(50) | yes | ||
| nvarchar(100) | yes | |||
| Username | nvarchar(50) | yes | ||
| Password | nvarchar(255) | yes | ||
| BackofficeID | nvarchar(40) | yes | ||
| BackofficeSystemID | int | Default = 0 | ||
| Status | tinyint | yes | Default = 0 | |
| StatusTxt | ntext | yes | ||
| baseUserName | nvarchar(50) | yes | ||
| ClientUsersID | int | yes |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| UserImportID | int | UserImport.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| UIML_UserImportID_Status_ClientUsersID | UserImportID, Status, ClientUsersID | |||
| UserImportMasterList_1 | UserImportID, Status | |||
| UserImportMasterList_2 | UserImportID, Status, ID, BackofficeID, BackofficeSystemID | |||
| UserImportMasterList_3 | UserImportID, Status, Username, ID | |||
| PK_UserImportMasterList | ID | yes | yes |