Table: Tracking_Description
Columns
NameTypeConstraintsDescription
tracking_description_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEYintNOT NULL
update_datedatetimeNOT NULL
create_datedatetimeNOT NULL
sortintNOT NULLUser defined sort for this table.
descriptionnvarchar (30)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