Table: dbo.Transaction_Template_Calendar_Day
This table stores options that denote how a user can specify the day of week on which we create a scheduled transaction (e.g., Monday, or weekday, or weekend day).
Columns
NameTypeConstraintsDescription
transaction_template_calendar_day_KEYint (4)NOT NULLPrimary key for this table.
descriptionnvarchar (30)NOT NULLThe description of the calendar day option type.
Primary key
NameColumnsDescription
PK_Transaction_Template_Calendar_Daytransaction_template_calendar_day_KEY
Unique constraints
NameColumnsDescription
UK_Transaction_Template_Calendar_Day$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Transaction_Template_Schedule_Option__Transaction_Template_Calendar_Day__transaction_template_calendar_day_KEYtransaction_template_calendar_day_KEYTransaction_Template_Schedule_Option

Schema diagram