Primary Key Field Type
 ID int

Field Field Type Null Notes Description
 OwnerID int  
 Name nvarchar(50)  
 Description nvarchar(150)  
 Deleted bit Default = 0
 DateAdded datetime   Default = getutcdate()
 FileContents image
 FileName nvarchar(256)
 FileSize int
 Status tinyint Default = 0
 StatusTxt ntext
 RecordCount int
 RecordsProcessed int
 ImportStart datetime
 ImportEnd datetime
 FieldMap ntext
 DeferProcess bit Default = 0
 ProcessOn datetime
 NeedToProcessList bit
 EmailTemplate int
 FileFieldNames ntext
 UserNameOption nvarchar(256)
 CurrentStep tinyint
 EmailID int
 EmailStatus ntext
 EmailListID int
 ClientSitesID int

Foreign Key Field Type Null Notes Description
 SiteClientsID int   ClientSites.ID

Index Name Field(s) Unique Primary Clustered
 IX_UserImport SiteClientsID, Name    
 PK_UserImport ID  

Referenced by Field
 UserImportMasterList UserImportID

Entity-Relationship diagram of this table