dfe
Tables (5)
checkpoint (Untitled)
- checkpoint_id — INT — Primary key — NOT NULL
- approval_status — BOOL
- gps_x — FLOAT
- gps_y — FLOAT
device
- device_id — INT — Primary key — NOT NULL
employee
- employee_id — INT — Primary key — NOT NULL
- name — CHAR
- gender — CHAR
- birth_date — DATE
time_gps
- time_gps_id — CHAR — Primary key — NOT NULL
- checkpoint_id — INT — Foreign key → checkpoint.checkpoint_id — NOT NULL
- time — DATE/TIME
- gps_x — FLOAT
- gps_y — FLOAT
- checkpoint_flag — BOOL
work
- work_id — INT — Primary key — NOT NULL
- device_id — INT — Foreign key → device.device_id — NOT NULL
- employee_id — INT — Foreign key → employee.employee_id — NOT NULL
- time_gps_id — CHAR — Foreign key → time_gps.time_gps_id — NOT NULL
- checkpoint_id — INT — Foreign key → time_gps.checkpoint_id — NOT NULL
- work_start_time — DATE
- work_end_time — DATE — NOT NULL
- approval_status — BOOL