Schema
This section describes the database structure and the relationships between collections. The schema consists of master data collections and transactional or operational collections used by the application.
Database
Collection Name: attendances
| Field | Type | Description |
|---|---|---|
_id | ObjectID | Unique identifier for the attendance record. |
date | String | Date when the checkin was created. |
created_by_id | ObjectID | Identifier of the user who created the group. |
check_in_at | String | Date and time when the user checked in. |
check_in_lat | Number | Latitude coordinate of the user's check-in location. |
check_in_long | Number | Longitude coordinate of the user's check-in location. |
check_in_photo | String | URL or path of the photo captured during check-in. |
check_in_notes | String | Additional notes provided by the user during check-in. |
check_out_at | String | Date and time when the user checked out. |
check_out_lat | Number | Latitude coordinate of the user's check-out location. |
check_out_long | Number | Longitude coordinate of the user's check-out location. |
check_out_photo | String | URL or path of the photo captured during check-out. |
check_out_notes | String | Additional notes provided by the user during check-out. |
breaks | Array (Object) | List of break periods recorded during the attendance session. Each object contains break start and end details. |
breaks.break_start_at | String | Date and time when the user started a break. |
breaks.break_start_lat | Number | Latitude coordinate of the user's location when the break started. |
breaks.break_start_long | Number | Longitude coordinate of the user's location when the break started. |
breaks.break_start_photo | String | URL or path of the photo captured when the break started. |
breaks.break_start_notes | String | Additional notes provided by the user when starting the break. |
breaks.break_end_at | String | Date and time when the user ended a break. |
breaks.break_end_lat | Number | Latitude coordinate of the user's location when the break ended. |
breaks.break_end_long | Number | Longitude coordinate of the user's location when the break ended. |
breaks.break_end_photo | String | URL or path of the photo captured when the break ended. |
breaks.break_end_notes | String | Additional notes provided by the user when ending the break. |