Table: History_Of_Task
Columns
NameTypeConstraintsDescription
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
revise__changeset_KEYintNOT NULL
history_action_KEYtinyint (3)NOT NULL
task_KEYintNOT NULL
update__staff_KEYintNOT NULL
project_KEYintNOT NULL
completion_orderintNOT NULL
budgeted_amountdecimal (9, 2)NOT NULL
actual_start_datesmalldatetime
actual_complete_datesmalldatetime
targetnvarchar (1000)NOT NULL
completion_eventnvarchar (50)NOT NULL
row_versionbinary (8)NOT NULL
solution_type_namenvarchar (50)NOT NULL
completion_event_recorded_date_utcdatetimeNOT NULL
task_numberintNOT NULL
project_template_KEYintNOT NULL
schedule_item_KEYintNOT NULL
budgeted_amount_is_calculatedbitNOT NULL
task_template_KEYint
Primary key
NameColumnsDescription
PK_History_Of_Task$task_KEY$revise__changeset_KEY$create__changeset_KEY$update__changeset_KEY$history_action_KEYtask_KEY, revise__changeset_KEY, create__changeset_KEY, update__changeset_KEY, history_action_KEYCLUSTERED

Schema diagram