Table: Project_Template_Extension | |||
Columns | |||
Name | Type | Constraints | Description |
project_template_extension_KEY | int | NOT NULL | AUTO-INCREMENT: Database assigned primary key for this table. |
update__staff_KEY | int | NOT NULL | |
update_date_utc | datetime | NOT NULL | |
create_date_utc | datetime | NOT NULL | |
project_template_KEY | int | NOT NULL | Key to a Project Template record. |
extension_number | int | NOT NULL | Number of this extension (unique per project_template_KEY). |
extension_month | int | NOT NULL | Months to extend the project. |
extension_day | int | NOT NULL | Days to extend the project. |
row_version | timestamp | NOT NULL |
Primary key | |||
Name | Columns | Description | |
PK_Project_Template_Extension$project_template_extension_KEY | project_template_extension_KEY | CLUSTERED | |
Unique constraints | |||
Name | Columns | Description | |
UK_Project_Template_Extension$project_template_KEY$extension_number | project_template_KEY, extension_number |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Project_Template_Extension__Project_Template__project_template_KEY | project_template_KEY | Project_Template |