rokkhi_history

Tables (13)

camera

  • IP — IP — Primary key — NOT NULL
  • ID — CHAR
  • password — CHAR

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
  • time_slot — CHAR — Foreign key → time_slot.slot_title — NOT NULL
  • guard_name — CHAR
  • phone_number — CHAR
  • address — CHAR
  • status — BOOL
  • type — CHAR — Patrolling/Stationary
  • performance — INT
  • month_work_cnt — INT
  • cur_work_cnt — INT

patrol_time_gps

  • patrol_time_gps_id — CHAR — Primary key — NOT NULL
  • time — DATE/TIME
  • latitude — FLOAT
  • longitude — FLOAT
  • checkpoint_flag — BOOL
  • checkpoint_response — BOOL

patroll_work

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

patrolling_guard

  • route — CHAR — Foreign key → route.route_id — NOT NULL
  • last_checkpoint — CHAR — Foreign key → checkpoint.checkpoint_id

route

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

station

  • station_id — CHAR — Primary key — NOT NULL
  • IP — IP — Foreign key → camera.IP — NOT NULL
  • station_title — CHAR
  • radius — FLOAT

stationary_guard

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

stationary_work

    time_slot

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

    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
    • slot_title — CHAR — Foreign key → guard.time_slot — NOT NULL
    • work_start_time — DATE
    • work_end_time — DATE — NOT NULL