# Time Tracking Entities {#time-tracking-entities}


Entities for time logs, time slots, timesheets, screenshots, and activity monitoring.


## TimeLog {#timelog}


Individual time entries recorded by employees.

| Column        | Type    | Description                                                       |
| ------------- | ------- | ----------------------------------------------------------------- |
| `id`          | UUID    | Primary key                                                       |
| `startedAt`   | Date    | Start timestamp                                                   |
| `stoppedAt`   | Date?   | Stop timestamp                                                    |
| `logType`     | enum    | `TRACKED`, `MANUAL`, `IDLE`, `RESUMED`                            |
| `source`      | enum    | `WEB_TIMER`, `DESKTOP`, `MOBILE`, `BROWSER`, `HUBSTAFF`, `UPWORK` |
| `duration`    | number  | Duration in seconds                                               |
| `isBillable`  | boolean | Billable flag                                                     |
| `description` | string? | Time log description                                              |
| `reason`      | string? | Manual edit reason                                                |
| `isRunning`   | boolean | Currently running                                                 |
| `editedAt`    | Date?   | Last manual edit timestamp                                        |
| `employeeId`  | UUID    | FK to employee                                                    |
| `projectId`   | UUID?   | FK to project                                                     |
| `taskId`      | UUID?   | FK to task                                                        |
| `timesheetId` | UUID?   | FK to timesheet                                                   |

**Relations:**

| Relation    | Type       | Target              |
| ----------- | ---------- | ------------------- |
| `employee`  | ManyToOne  | Employee            |
| `project`   | ManyToOne  | OrganizationProject |
| `task`      | ManyToOne  | Task                |
| `timesheet` | ManyToOne  | Timesheet           |
| `timeSlots` | ManyToMany | TimeSlot            |


## TimeSlot {#timeslot}


10-minute activity slots that aggregate activity data.

| Column       | Type   | Description                |
| ------------ | ------ | -------------------------- |
| `startedAt`  | Date   | Slot start time            |
| `duration`   | number | Duration in seconds (≤600) |
| `keyboard`   | number | Keyboard activity %        |
| `mouse`      | number | Mouse activity %           |
| `overall`    | number | Combined activity %        |
| `employeeId` | UUID   | FK to employee             |

**Relations:**

| Relation      | Type       | Target         |
| ------------- | ---------- | -------------- |
| `timeLogs`    | ManyToMany | TimeLog        |
| `screenshots` | OneToMany  | Screenshot     |
| `activities`  | OneToMany  | Activity       |
| `minutes`     | OneToMany  | TimeSlotMinute |


## TimeSlotMinute {#timeslotminute}


Per-minute activity breakdown within a time slot.

| Column       | Type   | Description       |
| ------------ | ------ | ----------------- |
| `keyboard`   | number | Keyboard activity |
| `mouse`      | number | Mouse activity    |
| `datetime`   | Date   | Minute timestamp  |
| `timeSlotId` | UUID   | FK to time slot   |


## Timesheet {#timesheet}


Weekly timesheet aggregations.

| Column         | Type    | Description                                           |
| -------------- | ------- | ----------------------------------------------------- |
| `duration`     | number  | Total duration (sec)                                  |
| `keyboard`     | number  | Keyboard activity %                                   |
| `mouse`        | number  | Mouse activity %                                      |
| `overall`      | number  | Overall activity %                                    |
| `startedAt`    | Date    | Week start                                            |
| `stoppedAt`    | Date    | Week end                                              |
| `status`       | enum    | `DRAFT`, `PENDING`, `IN_REVIEW`, `DENIED`, `APPROVED` |
| `approvedAt`   | Date?   | Approval timestamp                                    |
| `approvedById` | UUID?   | Supervisor who approved                               |
| `employeeId`   | UUID    | FK to employee                                        |
| `isBilled`     | boolean | Whether billed                                        |


## Screenshot {#screenshot}


Activity screenshots captured during time tracking.

| Column            | Type     | Description                 |
| ----------------- | -------- | --------------------------- |
| `file`            | string   | File path/URL               |
| `thumb`           | string?  | Thumbnail path/URL          |
| `recordedAt`      | Date     | Capture timestamp           |
| `deletedAt`       | Date?    | Soft delete timestamp       |
| `timeSlotId`      | UUID     | FK to time slot             |
| `storageProvider` | enum?    | Storage provider used       |
| `isWorkRelated`   | boolean? | Work-related classification |


## Activity {#activity}


Application and URL activity tracking.

| Column       | Type   | Description         |
| ------------ | ------ | ------------------- |
| `title`      | string | Window/app title    |
| `type`       | enum   | `APP`, `URL`        |
| `date`       | Date   | Activity date       |
| `time`       | Date   | Activity time       |
| `duration`   | number | Duration in seconds |
| `timeSlotId` | UUID   | FK to time slot     |
| `employeeId` | UUID   | FK to employee      |
| `projectId`  | UUID?  | FK to project       |
| `taskId`     | UUID?  | FK to task          |


## Related Pages {#related-pages}


- [Time Tracking Endpoints](https://sourcey-gauzy.pages.dev/api/time-tracking-endpoints/index.md) — API reference
- [Time Tracking Feature](https://sourcey-gauzy.pages.dev/features/time-tracking/index.md) — feature overview
- [Activity Tracking](https://sourcey-gauzy.pages.dev/features/activity-tracking/index.md) — screenshots and activities