Footprints Data Model

Table
Name time_tracking_type
Comment The type of time tracking entry. Values include AUTOMATIC, MANUAL_DURATION, MANUAL_RANGE.

Column
Name Datatype Comment Is PK Is FK
time_tracking_type_id int The automatically generated primary key of the time_tracking_type table. Yes No
time_tracking_type_name varchar(255) The name of the Time Tracking Type. No No
time_tracking_type_descr varchar(512) A descriptive name of the Time Tracking Type. This descriptive name may be localized. No No