Table: History_Of_Schedule_Entry | |||
Columns | |||
Name | Type | Constraints | Description |
create__changeset_KEY | int | NOT NULL | |
update__changeset_KEY | int | NOT NULL | |
revise__changeset_KEY | int | NOT NULL | |
history_action_KEY | tinyint (3) | NOT NULL | |
schedule_entry_KEY | int | NOT NULL | |
schedule_item_KEY | int | NOT NULL | |
staff_KEY | int | NOT NULL | |
schedule_entry_start_utc | datetime | NOT NULL | |
schedule_entry_duration | int | NOT NULL | |
schedule_entry_scheduled | int | NOT NULL | |
schedule_entry_start__time_zone_KEY | smallint (5) | NOT NULL | |
schedule_entry_end__time_zone_KEY | smallint (5) | NOT NULL | |
schedule_entry_end_utc | datetime | NOT NULL | |
calendar_category_KEY | int |
Primary key | |||
Name | Columns | Description | |
PK_History_Of_Schedule_Entry$schedule_entry_KEY$create__changeset_KEY$revise__changeset_KEY | schedule_entry_KEY, create__changeset_KEY, revise__changeset_KEY | CLUSTERED |