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