Table: Timer | |||
Columns | |||
Name | Type | Constraints | Description |
timer_KEY | int | NOT NULL | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table. |
update__staff_KEY | int | NOT NULL | |
sheet_entry_KEY | int | NOT NULL | The key to the Sheet Entry row this timer is for. |
timer_start_utc | datetime | NOT NULL | The date and time this timer was started in UTC. |
elapsed_seconds | int | NOT NULL | The number of seconds this timer ran before it was stopped, or 0 if it is still running. |
user_name | nvarchar (50) | NOT NULL | The name of the user that started the timer. |
integration_application_name | nvarchar (30) | NOT NULL | Identifies the application integration application name that is using the timer (if any) |
rounding_method_KEY | int | NOT NULL | The Rounding Method that was in place when the Timer was started. |
rounding_increment | decimal (4, 2) | NOT NULL | The Rounding Increment that was in place when the Timer was started. |
accumulate_time_before_rounding | bit | NOT NULL | The Accumulte Time setting that was in place when the Timer was started. |
create__changeset_KEY | int | NOT NULL | |
update__changeset_KEY | int | NOT NULL |
Primary key | |||
Name | Columns | Description | |
PK_Timer$timer_KEY | timer_KEY | ||
Indexes | |||
Name | Columns | Description | |
IX_Timer$elapsed_seconds$sheet_entry_KEY$timer_KEY | elapsed_seconds, sheet_entry_KEY, timer_KEY | An index by elapsed_seconds, sheet_entry_KEY and timer_KEY. Used by dp_Sheet_Entry_get_by_staff_KEY_with_open_timers. | |
IX_Timer$elapsed_seconds$sheet_entry_KEY$timer_start_utc | elapsed_seconds, sheet_entry_KEY, timer_start_utc | ||
IX_Timer$rounding_method_KEY | rounding_method_KEY | Index supports foreign key FK_Timer__Rounding_Method__rounding_method_KEY | |
IX_Timer$sheet_entry_KEY | sheet_entry_KEY | CLUSTERED |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Timer__Sheet_Entry__sheet_entry_KEY | sheet_entry_KEY | Sheet_Entry | on delete cascade; |