Table: History_Of_Project
Columns
NameTypeConstraintsDescription
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
revise__changeset_KEYintNOT NULL
history_action_KEYtinyint (3)NOT NULL
project_KEYintNOT NULL
update__staff_KEYintNOT NULL
schedule_item_KEYintNOT NULL
project_numberintNOT NULL
long_descriptionnvarchar (-1)NOT NULL
responsible__staff_KEYint
department_KEYint
targetnvarchar (1000)NOT NULL
completion_eventnvarchar (50)NOT NULL
budgeted_based_on_tasksbitNOT NULL
budgeted_amountdecimal (9, 2)NOT NULL
percent_completedecimal (3, 2)NOT NULL
received_datesmalldatetime
actual_start_datesmalldatetime
actual_complete_datesmalldatetime
row_versionbinary (8)NOT NULL
project_template_KEYintNOT NULL
original_due_datesmalldatetimeNOT NULL
extension_numberintNOT NULL
solution_type_namenvarchar (50)NOT NULL
completion_event_recorded_date_utcdatetimeNOT NULL
budgeted_amount_is_calculatedbitNOT NULL
percent_complete_is_overriddenbitNOT NULL
extension_eventnvarchar (50)NOT NULL
project_template_idnvarchar (11)NOT NULL
project_template_id_sortablevarchar (48)NOT NULL
gofileroom_workflow_KEYint
Primary key
NameColumnsDescription
PK_History_Of_Project$project_KEY$revise__changeset_KEY$create__changeset_KEY$update__changeset_KEY$history_action_KEYproject_KEY, revise__changeset_KEY, create__changeset_KEY, update__changeset_KEY, history_action_KEYCLUSTERED

Schema diagram