Table: Project_Template_Definition
Columns
NameTypeConstraintsDescription
project_template_definition_KEYintNOT NULLDatabase assigned primary key for this table.
update__staff_KEYintNOT NULL
update_datedatetimeNOT NULL
create_datedatetimeNOT NULL
project_template_definition_idnvarchar (11)NOT NULLUser defined ID (unique). A Project Template created from this Project Template Definition will this as its ID.
descriptionnvarchar (30)NOT NULLUser defined description.
long_descriptionnvarchar (-1)NOT NULLLong description to use on invoices.
recurrence_rulenvarchar (-1)NOT NULLText of the iCalendar recurrence rules and exteneded properties that make up the due date recurrence.
due_date_based_on_fiscal_year_endbitNOT NULLWhen the value is 1 the due date is adjusted for the Client's fiscal year end.
due_date_must_occur_on_weekdaysbitNOT NULLWhen the value is 1 the due date is adjusted so that it does not fall on a weekend.
row_versiontimestampNOT NULL
project_template_definition_id_sortablevarchar (48)NOT NULLA representation of the project_template_definition_id column that sorts in natural order, meaning that digits are sorted as numbers while non-digits are sorted alphabetically. A trigger keeps this field synchronized with the content of project_template_definition_id.
Primary key
NameColumnsDescription
PK_Project_Template_Definition$project_template_definition_KEYproject_template_definition_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Project_Template_Definition__project_template_definition_idproject_template_definition_idEach id must be unique.
UK_Project_Template_Definition__project_template_definition_id_sortableproject_template_definition_id_sortableAn index by the sortable ID is desired, and the algorithm ends up producing unique values.
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Project_Template_Definition_Extension__Project_Template_Definition__project_template_definition_KEYproject_template_definition_KEYProject_Template_Definition_Extension
FK_Project_Template_Definition_Imported__Project_Template_Definition__project_template_definition_KEYproject_template_definition_KEYProject_Template_Definition_Imported

Schema diagram