Table: History_Of_Schedule_Item_Assignment | |||
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_item_assignment_KEY | int | NOT NULL | |
update__staff_KEY | int | NOT NULL | |
staff_KEY | int | NOT NULL | |
schedule_item_KEY | int | NOT NULL | |
budgeted_hours | decimal (9, 2) | NOT NULL | |
schedule_item_assignment_rank | int | NOT NULL | |
is_primary_assignment | bit | NOT NULL |
Primary key | |||
Name | Columns | Description | |
PK_History_Of_Schedule_Item_Assignment$schedule_item_assignment_KEY$revise__changeset_KEY$create__changeset_KEY$update__changese | schedule_item_assignment_KEY, revise__changeset_KEY, create__changeset_KEY, update__changeset_KEY, history_action_KEY | CLUSTERED |