Table: dbo.Transaction_Template_Scheduled_Recurrence
This table stores recurrence frequencies we support for scheduled transactions (e.g., daily or weekly).
Columns
Name | Type | Constraints | Description
transaction_template_scheduled_recurrence_KEY | int (4) | NOT NULL | Primary key for this table.
description | nvarchar (30) | NOT NULL | The description of the recurrence type.

Primary key
Name | Columns | Description
PK_Transaction_Template_Scheduled_Recurrence | transaction_template_scheduled_recurrence_KEY |
Unique constraints
Name | Columns | Description
UK_Transaction_Template_Scheduled_Recurrence$description | description |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Transaction_Template_Schedule_Option__Transaction_Template_Scheduled_Recurrence__transaction_template_scheduled_recurrence_KE | transaction_template_scheduled_recurrence_KEY | Transaction_Template_Schedule_Option |