UserImport
Primary Key
| Primary Key |
Field Type |
| ID |
int |
Fields
| Field |
Field Type |
Null |
Notes |
Description |
| OwnerID |
int |
|
|
|
| Name |
nvarchar(50) |
|
|
|
| Description |
nvarchar(150) |
|
|
|
| Deleted |
bit |
yes |
Default = 0 |
|
| DateAdded |
datetime |
|
Default = getutcdate() |
|
| FileContents |
image |
yes |
|
|
| FileName |
nvarchar(256) |
yes |
|
|
| FileSize |
int |
yes |
|
|
| Status |
tinyint |
yes |
Default = 0 |
|
| StatusTxt |
ntext |
yes |
|
|
| RecordCount |
int |
yes |
|
|
| RecordsProcessed |
int |
yes |
|
|
| ImportStart |
datetime |
yes |
|
|
| ImportEnd |
datetime |
yes |
|
|
| FieldMap |
ntext |
yes |
|
|
| DeferProcess |
bit |
yes |
Default = 0 |
|
| ProcessOn |
datetime |
yes |
|
|
| NeedToProcessList |
bit |
yes |
|
|
| EmailTemplate |
int |
yes |
|
|
| FileFieldNames |
ntext |
yes |
|
|
| UserNameOption |
nvarchar(256) |
yes |
|
|
| CurrentStep |
tinyint |
yes |
|
|
| EmailID |
int |
yes |
|
|
| EmailStatus |
ntext |
yes |
|
|
| EmailListID |
int |
yes |
|
|
| ClientSitesID |
int |
yes |
|
|
Foreign Keys
| Foreign Key |
Field Type |
Null |
Notes |
Description |
| SiteClientsID |
int |
|
ClientSites.ID
|
|
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| IX_UserImport |
SiteClientsID, Name |
yes |
|
|
| PK_UserImport |
ID |
yes |
yes |
|
Referenced by