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 |
update_date | datetime | NOT NULL |
create_date | datetime | 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;