Table: Tracking_Description
Columns
NameTypeConstraintsDescription
tracking_description_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
create_date_utcdatetimeNOT NULL
sortintNOT NULLUser defined sort for this table.
descriptionnvarchar (250)NOT NULLUser defined description (unique).
row_versiontimestampNOT NULL
Primary key
NameColumnsDescription
PK_Tracking_Description$tracking_description_KEYtracking_description_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Tracking_Description$descriptiondescriptionEach description must be unique.
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Project_Template__Tracking_Description__tracking_description_KEYtracking_description_KEYProject_Template
FK_Task_Template__Tracking_Description__tracking_description_KEYtracking_description_KEYTask_Template
FK_Schedule_Item__Tracking_Description__tracking_description_KEYtracking_description_KEYSchedule_Item

Schema diagram