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. |
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. |