Table: Timer
Columns
NameTypeConstraintsDescription
timer_KEYintNOT NULLAssigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table.
update__staff_KEYintNOT NULL
sheet_entry_KEYintNOT NULLThe key to the Sheet Entry row this timer is for.
timer_start_utcdatetimeNOT NULLThe date and time this timer was started in UTC.
elapsed_secondsintNOT NULLThe number of seconds this timer ran before it was stopped, or 0 if it is still running.
user_namenvarchar (50)NOT NULLThe name of the user that started the timer.
integration_application_namenvarchar (30)NOT NULLIdentifies the application integration application name that is using the timer (if any)
rounding_method_KEYintNOT NULLThe Rounding Method that was in place when the Timer was started.
rounding_incrementdecimal (4, 2)NOT NULLThe Rounding Increment that was in place when the Timer was started.
accumulate_time_before_roundingbitNOT NULLThe Accumulte Time setting that was in place when the Timer was started.
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
Primary key
NameColumnsDescription
PK_Timer$timer_KEYtimer_KEY
Indexes
NameColumnsDescription
IX_Timer$elapsed_seconds$sheet_entry_KEY$timer_KEYelapsed_seconds, sheet_entry_KEY, timer_KEYAn 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_utcelapsed_seconds, sheet_entry_KEY, timer_start_utc
IX_Timer$rounding_method_KEYrounding_method_KEYIndex supports foreign key FK_Timer__Rounding_Method__rounding_method_KEY
IX_Timer$sheet_entry_KEYsheet_entry_KEYCLUSTERED
Foreign keys
NameColumnsReferenced tableDescription
FK_Timer__Sheet_Entry__sheet_entry_KEYsheet_entry_KEYSheet_Entryon delete cascade;

Schema diagram