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