Table: Project_Template_Definition
Columns
NameTypeConstraintsDescription
project_template_definition_KEYintNOT NULLDatabase assigned primary key for this table.
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
create_date_utcdatetimeNOT 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 (250)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.
recurrence_generation_method_KEYintNOT NULL
generation_monthintNOT NULL
generation_dayintNOT NULL
target_start_monthintNOT NULL
target_start_dayintNOT NULL
start__target_date_method_KEYintNOT NULL
target_complete_monthintNOT NULL
target_complete_dayintNOT NULL
complete__target_date_method_KEYintNOT NULL
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.
Foreign keys
NameColumnsReferenced tableDescription
FK_Project_Template_Definition__Recurrence_Generation_Method__recurrence_generation_method_KEYrecurrence_generation_method_KEYRecurrence_Generation_Method
FK_Project_Template_Definition__Target_Date_Method__complete__target_date_method_KEYcomplete__target_date_method_KEYTarget_Date_Method
FK_Project_Template_Definition__Target_Date_Method__start__target_date_method_KEYstart__target_date_method_KEYTarget_Date_Method
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