Table: Schedule_Item_Generation_Date
This table holds the next generation date for a given schedule item series.
Columns
Name | Type | Constraints | Description
schedule_item_series_KEY | int | NOT NULL | Key of the schedule item series.
next_generation_date | smalldatetime | NOT NULL | The date that the next project generation to be performed.

Primary key
Name | Columns | Description
PK_Schedule_Item_Generation_Date$schedule_item_series_KEY | schedule_item_series_KEY | CLUSTERED
Indexes
Name | Columns | Description
IX_Schedule_Item_Generation_Date$next_generation_date | next_generation_date |

Foreign keys
Name | Columns | Referenced table | Description
FK_Schedule_Item_Generation_Date__Schedule_Item_Series__schedule_item_series_KEY | schedule_item_series_KEY | Schedule_Item_Series |