Footprints Data Model

Table
Name time_tracking
Comment
A table of time tracking entries used to accumulate a log of time spent on
ticket editing and viewing.

Column
Name Datatype Comment Is PK Is FK
time_tracking_id bigint The automatically generated primary key of the time_tracking table. Yes No
time_tracking_descr varchar(512)
A descriptive name of the Time Tracking.  This descriptive name may be
localized.
No No
time_tracking_type_id int A Foreign Key to the Time Tracking Type table. No Yes
item_id BIGINT The foreign key to the item in the item table referenced by item defn id. No No
app_user_id bigint A Foreign Key to the Application User table. No Yes
start_date_time datetime Start date time. No No
end_date_time datetime End date time. No No
durn_mins bigint Duration in minutes. No No
rate_per_hour numeric(38,20) Hourly Rate. No No
rate_descr varchar(512) Rate description No No
item_defn_id bigint
A Foreign Key to the Definition table.  Identifies the specific Item that this
is a time tracking record for.
No Yes