Table: Project_Extension
Columns
NameTypeConstraintsDescription
project_extension_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEYintNOT NULL
project_KEYintNOT NULLKey to a Project record.
extension_numberintNOT NULLNumber of this extension (unique per project_KEY). Extension 0 is the original due date.
due_datesmalldatetimeNOT NULLCurrent due date of this extension.
row_versiontimestampNOT NULL
original_due_datesmalldatetimeNOT NULLThe original due date of the project extension; readonly once the record is created.
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
Primary key
NameColumnsDescription
PK_Project_Extension$project_extension_KEYproject_extension_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Project_Extension$project_KEY$extension_numberproject_KEY, extension_number
Foreign keys
NameColumnsReferenced tableDescription
FK_Project_Extension__Project__project_KEYproject_KEYProjecton delete cascade;

Schema diagram