Table: History_Of_Schedule_Item_Assignment
Columns
NameTypeConstraintsDescription
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
revise__changeset_KEYintNOT NULL
history_action_KEYtinyint (3)NOT NULL
schedule_item_assignment_KEYintNOT NULL
update__staff_KEYintNOT NULL
staff_KEYintNOT NULL
schedule_item_KEYintNOT NULL
budgeted_hoursdecimal (9, 2)NOT NULL
schedule_item_assignment_rankintNOT NULL
is_primary_assignmentbitNOT NULL
Primary key
NameColumnsDescription
PK_History_Of_Schedule_Item_Assignment$schedule_item_assignment_KEY$revise__changeset_KEY$create__changeset_KEY$update__changeseschedule_item_assignment_KEY, revise__changeset_KEY, create__changeset_KEY, update__changeset_KEY, history_action_KEYCLUSTERED

Schema diagram