attendance | varchar | NOT NULL, must be one of (present , absent , on-leave ) |
remark | varchar(255) | Optional |
image | varchar(500) | Optional |
metaData | varchar | Optional |
syncTime | varchar | Optional |
session | varchar | Optional |
contextId | uuid | NOT NULL |
context | varchar(255) | NOT NULL |
createdAt | timestamptz | Defaults to current timestamp |
updatedAt | timestamptz | Defaults to current timestamp |
attendanceId | uuid | NOT NULL, Primary Key, defaults to gen_random_uuid() |
tenantId | uuid | NOT NULL |
userId | uuid | NOT NULL |
attendanceDate | date | NOT NULL, defaults to current date |
latitude | float8 | Optional |
longitude | float8 | Optional |
createdBy | uuid | Optional |
updatedBy | uuid | Optional |
scope | public.attendance_scope | Optional |