Table: Project_Extension | |||
Columns | |||
Name | Type | Constraints | Description |
project_extension_KEY | int | NOT NULL | AUTO-INCREMENT: Database assigned primary key for this table. |
update__staff_KEY | int | NOT NULL | |
project_KEY | int | NOT NULL | Key to a Project record. |
extension_number | int | NOT NULL | Number of this extension (unique per project_KEY). Extension 0 is the original due date. |
due_date | smalldatetime | NOT NULL | Current due date of this extension. |
row_version | timestamp | NOT NULL | |
original_due_date | smalldatetime | NOT NULL | The original due date of the project extension; readonly once the record is created. |
create__changeset_KEY | int | NOT NULL | |
update__changeset_KEY | int | NOT NULL |
Primary key | |||
Name | Columns | Description | |
PK_Project_Extension$project_extension_KEY | project_extension_KEY | CLUSTERED | |
Unique constraints | |||
Name | Columns | Description | |
UK_Project_Extension$project_KEY$extension_number | project_KEY, extension_number |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Project_Extension__Project__project_KEY | project_KEY | Project | on delete cascade; |