Table: History_Of_Project
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 |
project_KEY | int | NOT NULL |
update__staff_KEY | int | NOT NULL |
update_date | datetime | NOT NULL |
create_date | datetime | NOT NULL |
schedule_item_KEY | int | NOT NULL |
project_number | int | NOT NULL |
long_description | nvarchar (-1) | NOT NULL |
responsible__staff_KEY | int |  |
department_KEY | int |  |
target | nvarchar (1000) | NOT NULL |
completion_event | nvarchar (50) | NOT NULL |
budgeted_based_on_tasks | bit | NOT NULL |
budgeted_amount | decimal (9, 2) | NOT NULL |
percent_complete | decimal (3, 2) | NOT NULL |
received_date | smalldatetime |  |
actual_start_date | smalldatetime |  |
actual_complete_date | smalldatetime |  |
row_version | binary (8) | NOT NULL |
project_template_KEY | int | NOT NULL |
original_due_date | smalldatetime | NOT NULL |
extension_number | int | NOT NULL |
solution_type_name | nvarchar (50) | NOT NULL |
completion_event_recorded_date | datetime | NOT NULL |
budgeted_amount_is_calculated | bit | NOT NULL |
percent_complete_is_overridden | bit | NOT NULL |
extension_event | nvarchar (50) | NOT NULL |
project_template_id | nvarchar (11) | NOT NULL |
project_template_id_sortable | varchar (48) | NOT NULL |
gofileroom_workflow_KEY | int |  |

Primary key
Name | Columns | Description
PK_History_Of_Project$project_KEY$revise__changeset_KEY$create__changeset_KEY$update__changeset_KEY$history_action_KEY | project_KEY, revise__changeset_KEY, create__changeset_KEY, update__changeset_KEY, history_action_KEY | CLUSTERED