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_utc | datetime | NOT NULL | |
create_date_utc | 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 |