fea
Tables (6)
checkpoint
- checkpoint_id — CHAR — Primary key — NOT NULL
- group_checkpoint_id — CHAR — Foreign key → group_checkpoint.group_checkpoint_id — NOT NULL
- latitude — FLOAT
- longitude — FLOAT
device
- device_id — CHAR — Primary key — NOT NULL
employee
- employee_id — CHAR — Primary key — NOT NULL
- name — CHAR
- gender — CHAR
- birth_date — DATE
group_checkpoint
- group_checkpoint_id — CHAR — Primary key — NOT NULL
- group_name — CHAR
- checkpoint — LIST
time_gps
- time_gps_id — CHAR — Primary key — NOT NULL
- checkpoint_id — CHAR — Foreign key → checkpoint.checkpoint_id — NOT NULL
- group_checkpoint_id — CHAR — Foreign key → checkpoint.group_checkpoint_id — NOT NULL
- time — DATE/TIME
- latitude — FLOAT
- longitude — FLOAT
- checkpoint_flag — BOOL
- checkpoint_approval — BOOL
work
- work_id — CHAR — Primary key — NOT NULL
- device_id — CHAR — Foreign key → device.device_id — NOT NULL
- employee_id — CHAR — Foreign key → employee.employee_id — NOT NULL
- work_start_time — DATE
- work_end_time — DATE — NOT NULL
- approval_status — BOOL
- time_gps — LIST — NOT NULL