Table: dbo.Transaction_Template_Calendar_Day_Occurrence
This table stores options that denote how a user can specify the occurrence of a day of week on which we create a scheduled transaction (e.g., the first, or the third, or the last).
Columns
NameTypeConstraintsDescription
transaction_template_calendar_day_occurrence_KEYint (4)NOT NULLPrimary key for this table.
descriptionnvarchar (20)NOT NULLThe description of the calendar day occurrence type.
Primary key
NameColumnsDescription
PK_Transaction_Template_Calendar_Day_Occurrencetransaction_template_calendar_day_occurrence_KEY
Unique constraints
NameColumnsDescription
UK_Transaction_Template_Calendar_Day_Occurrence$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Transaction_Template_Schedule_Option__Transaction_Template_Calendar_Day_Occurrence__transaction_template_calendar_day_occurretransaction_template_calendar_day_occurrence_KEYTransaction_Template_Schedule_Option

Schema diagram