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 |