rokkhi_day

Tables (9)

checkpoint

  • checkpoint_id — CHAR — Primary key — NOT NULL
  • route_id — CHAR — Foreign key → route.route_id — NOT NULL
  • latitude — FLOAT
  • longitude — FLOAT
  • radius — FLOAT
  • frequency — INT

device

  • device_id — CHAR — Primary key — NOT NULL
  • battery — INT

guard

  • employee_id — CHAR — Primary key — NOT NULL
  • guard_name — CHAR
  • phone_number — CHAR
  • address — CHAR
  • guard_photo — IMAGE
  • status — BOOL
  • month_work_cnt — INT
  • cur_work_cnt — INT
  • type — CHAR

patrol_work

  • route_id — CHAR — Foreign key → route.route_id — NOT NULL
  • checkpoint_cnt — LIST

route

  • route_id — CHAR — Primary key — NOT NULL
  • route_title — CHAR
  • checkpoint — LIST

station

  • station_id — CHAR — Primary key — NOT NULL
  • station_title — CHAR
  • radius — FLOAT

station_work

  • station_id — CHAR — Foreign key → station.station_id — NOT NULL
  • response_list — LIST

time_slot

  • slot_title — CHAR — Primary key — NOT NULL
  • frequency — INT
  • start_time — DATE
  • end_time — DATE

work

  • work_id — CHAR — Primary key — NOT NULL
  • device_id — CHAR — Foreign key → device.device_id — NOT NULL
  • employee_id — CHAR — Foreign key → guard.employee_id — NOT NULL
  • time_slot — CHAR — Foreign key → time_slot.slot_title — NOT NULL
  • work_start_time — DATE
  • work_end_time — DATE — NOT NULL