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