Table: dbo.Transaction_Template_Scheduled_Recurrence
This table stores recurrence frequencies we support for scheduled transactions (e.g., daily or weekly).
Columns
NameTypeConstraintsDescription
transaction_template_scheduled_recurrence_KEYint (4)NOT NULLPrimary key for this table.
descriptionnvarchar (30)NOT NULLThe description of the recurrence type.
Primary key
NameColumnsDescription
PK_Transaction_Template_Scheduled_Recurrencetransaction_template_scheduled_recurrence_KEY
Unique constraints
NameColumnsDescription
UK_Transaction_Template_Scheduled_Recurrence$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Transaction_Template_Schedule_Option__Transaction_Template_Scheduled_Recurrence__transaction_template_scheduled_recurrence_KEtransaction_template_scheduled_recurrence_KEYTransaction_Template_Schedule_Option

Schema diagram