Table: History_Of_Task | |||
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 | |
task_KEY | int | NOT NULL | |
update__staff_KEY | int | NOT NULL | |
project_KEY | int | NOT NULL | |
completion_order | int | NOT NULL | |
budgeted_amount | decimal (9, 2) | NOT NULL | |
actual_start_date | smalldatetime | ||
actual_complete_date | smalldatetime | ||
target | nvarchar (1000) | NOT NULL | |
completion_event | nvarchar (50) | NOT NULL | |
row_version | binary (8) | NOT NULL | |
solution_type_name | nvarchar (50) | NOT NULL | |
completion_event_recorded_date_utc | datetime | NOT NULL | |
task_number | int | NOT NULL | |
project_template_KEY | int | NOT NULL | |
schedule_item_KEY | int | NOT NULL | |
budgeted_amount_is_calculated | bit | NOT NULL | |
task_template_KEY | int |
Primary key | |||
Name | Columns | Description | |
PK_History_Of_Task$task_KEY$revise__changeset_KEY$create__changeset_KEY$update__changeset_KEY$history_action_KEY | task_KEY, revise__changeset_KEY, create__changeset_KEY, update__changeset_KEY, history_action_KEY | CLUSTERED |