Table: Project_Template_Extension
Columns
NameTypeConstraintsDescription
project_template_extension_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
create_date_utcdatetimeNOT NULL
project_template_KEYintNOT NULLKey to a Project Template record.
extension_numberintNOT NULLNumber of this extension (unique per project_template_KEY).
extension_monthintNOT NULLMonths to extend the project.
extension_dayintNOT NULLDays to extend the project.
row_versiontimestampNOT NULL
Primary key
NameColumnsDescription
PK_Project_Template_Extension$project_template_extension_KEYproject_template_extension_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Project_Template_Extension$project_template_KEY$extension_numberproject_template_KEY, extension_number
Foreign keys
NameColumnsReferenced tableDescription
FK_Project_Template_Extension__Project_Template__project_template_KEYproject_template_KEYProject_Template

Schema diagram