Table: Schedule_Item_Generation_Date
This table holds the next generation date for a given schedule item series.
Columns
NameTypeConstraintsDescription
schedule_item_series_KEYintNOT NULLKey of the schedule item series.
next_generation_datedatetimeNOT NULLThe date that the next project generation to be performed (in UTC).
Primary key
NameColumnsDescription
PK_Schedule_Item_Generation_Date$schedule_item_series_KEYschedule_item_series_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Schedule_Item_Generation_Date$next_generation_datenext_generation_date
Foreign keys
NameColumnsReferenced tableDescription
FK_Schedule_Item_Generation_Date__Schedule_Item_Series__schedule_item_series_KEYschedule_item_series_KEYSchedule_Item_Series

Schema diagram