Footprints Data Model

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

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Time Tracking Id The automatically generated primary key of the time_tracking table. LONG Yes
Time Tracking Description A descriptive name of the Time Tracking. This descriptive name may be localized. VARCHAR(512) No
Time Tracking Type Id A Foreign Key to the Time Tracking Type table. INTEGER Yes
Item Definition Id A Foreign Key to the Definition table. LONG Yes
Item Id A Foreign Key to the Item table. LONG Yes
Application User Id A Foreign Key to the Application User table. LONG Yes
Start Date Time The value of a Time Tracking, stored as a date. DATE Yes
End Date Time The value of a Time Tracking, stored as a date. DATE No
Duration Minutes The value of a Time Tracking stored as Long. LONG No
Rate Per Hour The value of a Time Tracking stored as real. DECIMAL(,) No
Rate Description A descriptive name of the Time Tracking. This descriptive name may be localized. VARCHAR(512) No
item_id   CHAR(18) No