Table: dbo.Scheduled_Transaction_Interval
This table stores the time intervals defined by the frequency of the associated template. The intervals are a means to organize scheduled transactions (both those created from the template, and those scheduled but not yet created), and efficiently alter a schedule when a user changes scheduling options after we begin to generate transactions from the template.
Columns
Name | Type | Constraints | Description
scheduled_transaction_interval_KEY | int (4) | NOT NULL | The primary key for this table.
transaction_template_KEY | int (4) | NOT NULL | The key of the scheduled template.
start_date | smalldatetime (4) | NOT NULL | The first day of the interval.
end_date | smalldatetime (4) | NOT NULL | The last day of the interval.

Primary key
Name | Columns | Description
PK_Scheduled_Transaction_Interval | scheduled_transaction_interval_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Scheduled_Transaction_Interval__Transaction_Template__transaction_template_KEY | transaction_template_KEY | Transaction_Template (transaction_template_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Scheduled_Transaction_Instance__Scheduled_Transaction_Interval__scheduled_transaction_interval_KEY | scheduled_transaction_interval_KEY | Scheduled_Transaction_Instance |