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