Table: Project_Template_Entity
Columns
NameTypeConstraintsDescription
project_template_entity_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.
entity_KEYintNOT NULLKey to an Entity record.
row_versiontimestampNOT NULL
Primary key
NameColumnsDescription
PK_Project_Template_Entity$project_template_entity_KEYproject_template_entity_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Project_Template_Entity$project_template_KEY$entity_KEYproject_template_KEY, entity_KEY
Indexes
NameColumnsDescription
IX_Project_Template_Entity$entity_KEYentity_KEYIndex supports foreign key FK_Project_Template_Entity__Entity__entity_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Project_Template_Entity__Entity__entity_KEYentity_KEYEntity
FK_Project_Template_Entity__Project_Template__project_template_KEYproject_template_KEYProject_Template

Schema diagram