TAB_TIME_TRACKING_RANGE Class

Time tracking typed time range (N per day, minute precision).

Show:

ID_TIME_TRACKING_DAY

Int(11)

Parent day line.


Default: 0

ID_TIME_TRACKING_RANGE

Int(11)

Unique identifier.

TIME_TRACKING_RANGE_END

Datetime

Range end, date and time (minute precision). Stored as a full datetime (rather than a time) so a range can cross midnight.

TIME_TRACKING_RANGE_START

Datetime

Range start, date and time (minute precision). Stored as a full datetime (rather than a time) so a range can cross midnight.

TIME_TRACKING_RANGE_TYPE

Tinyint

Range type. Stored as tinyint, mapped in code to BoondManager\Lib\Enum\TimeTracking\RangeType :

  • 0 : worktime (worked time)
  • 1 : breaktime (break time, deducted from worked time)
  • 2 : mealtime (meal break) tinyint (rather than a SQL enum) allows adding new types without a schema migration.


Default: 0