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 | datetime | NOT NULL | The date that the next project generation to be performed (in UTC). |
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 |