Table: Project_Template_Definition_Extension
Columns
NameTypeConstraintsDescription
project_template_definition_extension_KEYintNOT NULLDatabase assigned primary key for this table.
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
create_date_utcdatetimeNOT NULL
project_template_definition_KEYintNOT NULLKey to a Project Template Definition record.
extension_numberintNOT NULLNumber of this extension (unique per project_template_definition_KEY).
extension_monthintNOT NULLMonths to extend the project.
extension_dayintNOT NULLDays to extend the project.
row_versiontimestampNOT NULL
Primary key
NameColumnsDescription
PK_Project_Template_Definition_Extension$project_template_definition_extension_KEYproject_template_definition_extension_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Project_Template_Definition_Extension$project_template_definition_extension_KEY$extension_numberproject_template_definition_extension_KEY, extension_numberEach extension_number must be unique for a given project_template_definition_KEY.
Indexes
NameColumnsDescription
IX_Project_Template_Definition_Extension$project_template_definition_KEYproject_template_definition_KEYIndex supports foreign key FK_Project_Template_Definition_Extension__Project_Template_Definition__project_template_definition_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Project_Template_Definition_Extension__Project_Template_Definition__project_template_definition_KEYproject_template_definition_KEYProject_Template_Definition

Schema diagram