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
NameTypeConstraintsDescription
scheduled_transaction_interval_KEYint (4)NOT NULLThe primary key for this table.
transaction_template_KEYint (4)NOT NULLThe key of the scheduled template.
start_datesmalldatetime (4)NOT NULLThe first day of the interval.
end_datesmalldatetime (4)NOT NULLThe last day of the interval.
Primary key
NameColumnsDescription
PK_Scheduled_Transaction_Intervalscheduled_transaction_interval_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Scheduled_Transaction_Interval__Transaction_Template__transaction_template_KEYtransaction_template_KEYTransaction_Template (transaction_template_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Scheduled_Transaction_Instance__Scheduled_Transaction_Interval__scheduled_transaction_interval_KEYscheduled_transaction_interval_KEYScheduled_Transaction_Instance

Schema diagram