Table: dbo.Transaction_Template_Creation_Day
This table stores options that denote how a user specifies the day on which we should create a scheduled transaction (e.g., create on the Nth day of the month, where N is an integer).
Columns
NameTypeConstraintsDescription
transaction_template_creation_day_KEYint (4)NOT NULLPrimary key for this table.
descriptionnvarchar (120)NOT NULLThe description of the creation day option type.
Primary key
NameColumnsDescription
PK_Transaction_Template_Creation_Daytransaction_template_creation_day_KEY
Unique constraints
NameColumnsDescription
UK_Transaction_Template_Creation_Day$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Transaction_Template_Schedule_Option__Transaction_Template_Creation_Day__transaction_template_creation_day_KEYtransaction_template_creation_day_KEYTransaction_Template_Schedule_Option

Schema diagram