BBIYONG ERD

Tables (11)

admin

  • id — INTEGER — Primary key — NOT NULL
  • email — TEXT — NOT NULL
  • password_hash — TEXT — NOT NULL
  • name — TEXT — NOT NULL
  • role — TEXT — NOT NULL
  • created_at — TEXT — NOT NULL
  • last_login_at — TEXT

admin_robot

  • admin_id — INTEGER — Foreign key → admin.id — NOT NULL
  • robot_id — INTEGER — Foreign key → robot.id — NOT NULL
  • assigned_at — TEXT — NOT NULL

alert

  • id — INTEGER — Primary key — NOT NULL
  • event_id — INTEGER — Foreign key → event.id — NOT NULL
  • level — TEXT — NOT NULL
  • message — TEXT — NOT NULL
  • channels — TEXT — NOT NULL
  • is_acknowledged — INTEGER — NOT NULL
  • acknowledged_by — INTEGER — Foreign key → admin.id
  • acknowledged_at — TEXT
  • created_at — TEXT — NOT NULL

cctv_device

  • id — INTEGER — Primary key — NOT NULL
  • name — TEXT — NOT NULL
  • zone_name — TEXT — NOT NULL
  • stream_url — TEXT
  • cell_c — INTEGER
  • cell_r — INTEGER
  • is_active — INTEGER — NOT NULL
  • installed_at — TEXT

dispatch

  • id — INTEGER — Primary key — NOT NULL
  • event_id — INTEGER — Foreign key → event.id — NOT NULL
  • robot_id — INTEGER — Foreign key → robot.id — NOT NULL
  • trigger_type — TEXT — NOT NULL
  • ordered_by — INTEGER — Foreign key → admin.id
  • status — TEXT — NOT NULL
  • verify_result — TEXT
  • ordered_at — TEXT — NOT NULL
  • arrived_at — TEXT
  • completed_at — TEXT
  • cancel_reason — TEXT

equipment

  • id — INTEGER — Primary key — NOT NULL
  • name — TEXT — NOT NULL
  • type — TEXT — NOT NULL
  • location — TEXT
  • cell_c — INTEGER — NOT NULL
  • cell_r — INTEGER — NOT NULL
  • base_temp — REAL
  • threshold_temp — REAL — NOT NULL
  • is_active — INTEGER — NOT NULL

event

  • id — INTEGER — Primary key — NOT NULL
  • event_uid — TEXT — NOT NULL
  • type — TEXT — NOT NULL
  • source — TEXT — NOT NULL
  • status — TEXT — NOT NULL
  • robot_id — INTEGER — Foreign key → robot.id
  • cctv_id — INTEGER — Foreign key → cctv_device.id
  • equipment_id — INTEGER — Foreign key → equipment.id
  • cell_c — INTEGER
  • cell_r — INTEGER
  • confidence — REAL
  • measured_temp — REAL
  • snapshot_path — TEXT
  • detail — TEXT
  • occurred_at — TEXT — NOT NULL
  • created_at — TEXT — NOT NULL

robot

  • id — INTEGER — Primary key — NOT NULL
  • name — TEXT — NOT NULL
  • model — TEXT
  • serial_no — TEXT
  • current_mode — TEXT — NOT NULL
  • battery — INTEGER
  • is_active — INTEGER — NOT NULL
  • registered_at — TEXT — NOT NULL

robot_status_log

  • id — INTEGER — Primary key — NOT NULL
  • robot_id — INTEGER — Foreign key → robot.id — NOT NULL
  • mode — TEXT — NOT NULL
  • battery — INTEGER
  • speed — REAL
  • pos_x — REAL
  • pos_y — REAL
  • comm_latency_ms — INTEGER
  • inference_fps — REAL
  • recorded_at — TEXT — NOT NULL

sensor_reading

  • id — INTEGER — Primary key — NOT NULL
  • robot_id — INTEGER — Foreign key → robot.id — NOT NULL
  • equipment_id — INTEGER — Foreign key → equipment.id
  • sensor_type — TEXT — NOT NULL
  • temperature — REAL
  • humidity — REAL
  • surface_temp — REAL
  • is_over_threshold — INTEGER — NOT NULL
  • measured_at — TEXT — NOT NULL

slam_map

  • id — INTEGER — Primary key — NOT NULL
  • name — TEXT — NOT NULL
  • version — TEXT — NOT NULL
  • file_path — TEXT — NOT NULL
  • cols — INTEGER — NOT NULL
  • rows — INTEGER — NOT NULL
  • cell_size_m — REAL
  • is_active — INTEGER — NOT NULL
  • created_at — TEXT — NOT NULL