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