Table: dbo.Import_Template
Parent record for user-defined Import Templates.
Columns
NameTypeConstraintsDescription
import_template_KEYint (4)NOT NULLPrimary key.
import_template_type_KEYint (4)NOT NULLLink to the template type; defines the type of data that can be imported.
descriptionnvarchar (100)NOT NULLUser-defined description for this template.
client_KEYint (4)NOT NULLClient that this template can be used with.
staff_KEYint (4)NOT NULLStaff that can use this template.
Primary key
NameColumnsDescription
PK_Import_Templateimport_template_KEY
Unique constraints
NameColumnsDescription
UK_Import_Template$description$client_KEYdescription, client_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Import_Template__Client__client_KEYclient_KEYClient (client_KEY)
FK_Import_Template__Import_Template_Type__import_template_type_KEYimport_template_type_KEYImport_Template_Type (import_template_type_KEY)
FK_Import_Template__Staff__staff_KEYstaff_KEYStaff (staff_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Import_Template_Column__Import_Template__import_template_KEYimport_template_KEYImport_Template_Column

Schema diagram