4647_demo

Tables (15)

Sticker

  • sticker_id — INT — NOT NULL
  • floor_plan_id — INT — Foreign key → floor_plan.floor_plan_id — NOT NULL
  • sticker_category — VARCHAR(20)
  • sticker_x — FLOAT
  • sticker_y — FLOAT

building

  • building_id — INT — NOT NULL
  • incident_id — INT — Foreign key → incident.incident_id — NOT NULL
  • building_name — VARCHAR(200)
  • address — VARCHAR(500)
  • floor_count — INT
  • underground_count — INT
  • structure_type — VARCHAR(100)
  • business_type — VARCHAR(100)
  • completion_year — INT
  • total_area — FLOAT
  • primary_use_per_floor — JSON
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

drone_capture

  • drone_capture_id — INT — NOT NULL
  • incident_id — INT — Foreign key → incident.incident_id — NOT NULL
  • track_id — INT
  • class — VARCHAR(20)
  • conf — FLOAT
  • bbox — JSON
  • image_url — VARCHAR(500)
  • detected_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

drone_stream

  • drone_stream_id — INT — NOT NULL
  • incident_id — INT — Foreign key → incident.incident_id — NOT NULL
  • rtsp_url — VARCHAR(500)
  • status — VARCHAR(20)
  • started_at — TIMESTAMP
  • ended_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

firefighter

  • firefighter_id — INT — NOT NULL
  • firefighter_name — VARCHAR(100)
  • team — VARCHAR(100)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

firefighter_location_log

  • location_log_id — INT — NOT NULL
  • incident_firefighter_id — INT — Foreign key → incident_firefighter.incident_firefighter_id — NOT NULL
  • x_coord — FLOAT — NOT NULL
  • y_coord — FLOAT — NOT NULL
  • heading_rad — FLOAT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

floor_plan

  • floor_plan_id — INT — NOT NULL
  • building_id — INT — Foreign key → building.building_id — NOT NULL
  • pixels_per_meter — FLOAT
  • image_height — INT
  • image_width — INT
  • floor_no — INT — NOT NULL
  • floor_label — VARCHAR(50)
  • image_url — TEXT
  • created_at — TIMESTAMP — NOT NULL

incident

  • incident_id — INT — NOT NULL
  • address — VARCHAR(500) — NOT NULL
  • lat — DOUBLE
  • lng — DOUBLE
  • initial_situation — TEXT
  • fire_status — JSON
  • hazards — JSON
  • responding_units — JSON
  • status — VARCHAR(20) — NOT NULL
  • occured_at — TIMESTAMP — NOT NULL
  • ended_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

incident_firefighter

  • incident_firefighter_id — INT — NOT NULL
  • incident_id — INT — Foreign key → incident.incident_id — NOT NULL
  • firefighter_id — INT — Foreign key → firefighter.firefighter_id — NOT NULL
  • watch_id — INT — Foreign key → watch.watch_id — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • connection_state — BOOLEAN
  • fcm_token — TEXT
  • origin_x — INT
  • origin_y — INT
  • origin_floor_plan — INT
  • origin_heading_rad — FLOAT
  • is_unplaced — BOOLEAN
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

nearby_facility

  • facility_id — INT — NOT NULL
  • building_id — INT — Foreign key → building.building_id — NOT NULL
  • facility_type — VARCHAR(20) — NOT NULL
  • facility_name — VARCHAR(200)
  • latitude — DOUBLE
  • longitude — DOUBLE
  • distance_m — INT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

radio_log

  • radio_log_id — INT — NOT NULL
  • incident_id — INT — Foreign key → incident.incident_id — NOT NULL
  • incident_firefighter_id — INT — Foreign key → incident_firefighter.incident_firefighter_id — NOT NULL
  • radio_content — TEXT
  • category — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

rescuee

  • rescuee_id — INT — NOT NULL
  • incident_id — INT — Foreign key → incident.incident_id — NOT NULL
  • rescuee_name — VARCHAR(100)
  • age — INT
  • rescue_status — VARCHAR(20) — NOT NULL
  • location — VARCHAR(200)
  • detected_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

room

  • room_id — INT — NOT NULL
  • floor_plan_id — INT — Foreign key → floor_plan.floor_plan_id — NOT NULL
  • room_label — VARCHAR(100)
  • room_status — VARCHAR(20)
  • polygon_json — JSON
  • center_x — FLOAT
  • center_y — FLOAT
  • created_at — TIMESTAMP — NOT NULL

vital_log

  • vital_log_id — INT — NOT NULL
  • incident_firefighter_id — INT — Foreign key → incident_firefighter.incident_firefighter_id — NOT NULL
  • heart_rate — INT
  • respiration_rate — INT
  • body_temperature — FLOAT
  • oxygen_remaining_l — FLOAT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

watch

  • watch_id — INT — NOT NULL
  • device_serial — VARCHAR(100) — NOT NULL
  • fcm_token — TEXT
  • last_synced_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL