Table: dbo.Import_Template_Column_Type
Lists the types of column data available for importing.
Columns
NameTypeConstraintsDescription
import_template_column_type_KEYint (4)NOT NULLPrimary key.
import_template_type_KEYint (4)NOT NULLKey to the parent table.
descriptionnvarchar (100)NOT NULLUnique user-friendly name of the column data type.
sequence_numberint (4)NOT NULLOrder that the column options are to be displayed to the user.
Primary key
NameColumnsDescription
PK_Import_Template_Column_Typeimport_template_column_type_KEY
Unique constraints
NameColumnsDescription
UK_Import_Template_Column_Type$descriptiondescription
UK_Import_Template_Column_Type$import_template_type_KEY$sequence_numberimport_template_type_KEY, sequence_number
Foreign keys
NameColumnsReferenced tableDescription
FK_Import_Template_Column_Type__Import_Template_Type__import_template_type_KEYimport_template_type_KEYImport_Template_Type (import_template_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Import_Template_Column__Import_Template_Column_Type__import_template_column_type_KEYimport_template_column_type_KEYImport_Template_Column

Schema diagram