Table: Schedule_Item_Budget_Remaining_Entry | |||
This table stores the user adjustments to the remaining hours value for Projects/Tasks | |||
Columns | |||
Name | Type | Constraints | Description |
create__changeset_KEY | int | NOT NULL | |
update__changeset_KEY | int | NOT NULL | |
schedule_item_budget_remaining_entry_KEY | int | NOT NULL | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table. |
update__staff_KEY | int | NOT NULL | Key of Staff who last modified this row. |
entry_date | smalldatetime | NOT NULL | The date that this row was entered. |
schedule_item_KEY | int | NOT NULL | Schedule item key to which this entry belongs. |
hours | decimal (9, 2) | NOT NULL | The number of hours this entry is adjusting the remaining hours value. |
comments | nvarchar (-1) | NOT NULL | User entered comments. |
Primary key | |||
Name | Columns | Description | |
PK_Schedule_Item_Budget_Remaining_Entry$schedule_item_budget_remaining_entry_KEY | schedule_item_budget_remaining_entry_KEY | CLUSTERED | |
Indexes | |||
Name | Columns | Description | |
IX_Schedule_Item_Budget_Remaining_Entry$schedule_item_KEY | schedule_item_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Schedule_Item_Budget_Remaining_Entry__Schedule_Item__schedule_item_KEY | schedule_item_KEY | Schedule_Item |