d
Tables (5)
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 — DATE/TIME
- gps — COORDINATE
work_copy
- work_start_time — DATE
- work_end_time — DATE — NOT NULL
- approval_status — BOOL
work_detail
- 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
- work_start_time — DATE
- work_end_time — DATE — NOT NULL
- approval_status — BOOL
- time_and_gps — LIST — NOT NULL