Table: Project_Template_Definition_Extension
Columns
Name | Type | Constraints | Description
project_template_definition_extension_KEY | int | NOT NULL | 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_definition_KEY | int | NOT NULL | Key to a Project Template Definition record.
extension_number | int | NOT NULL | Number of this extension (unique per project_template_definition_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_Definition_Extension$project_template_definition_extension_KEY | project_template_definition_extension_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Project_Template_Definition_Extension__project_template_definition_extension_KEY__extension_number | project_template_definition_extension_KEY, extension_number | Each extension_number must be unique for a given project_template_definition_KEY.
Indexes
Name | Columns | Description
IX_Project_Template_Definition_Extension$project_template_definition_KEY | project_template_definition_KEY | Index supports foreign key FK_Project_Template_Definition_Extension__Project_Template_Definition__project_template_definition_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_Project_Template_Definition_Extension__Project_Template_Definition__project_template_definition_KEY | project_template_definition_KEY | Project_Template_Definition |