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