FIRE-demo_ver2

Tables (14)

Sticker

  • sticker_id — INT — NOT NULL
  • floor_plan_id — INT — Foreign key → floor_plan.floor_plan_id — NOT NULL
  • sticker_category — ENUM( 'FIRE','RESCUEE','DOOR','WALL', 'OIL','CITY_GAS','LPG','HYDROGEN','OTHER_HAZMAT' )
  • 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
  • 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 — ENUM('PERSON')
  • 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 — ENUM('ACTIVE','ENDED')
  • 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
  • floor_no — INT — NOT NULL
  • floor_label — VARCHAR(100)
  • pixels_per_meter — FLOAT
  • image_height — INT
  • image_width — INT
  • 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
  • latest_guideline — JSON
  • guideline_generated_at — TIMESTAMP
  • status — ENUM('IN_PROGRESS','COMPLETED') — 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 — ENUM('COMMANDER','CREW') — 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 — ENUM('GAS_STATION','LPG','SCHOOL','HOSPITAL','FACTORY','OTHER') — 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 — ENUM('INSTRUCTION','REPORT','STATUS','OTHER') — 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 — ENUM('PENDING','RESCUED') — 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 — ENUM('NORMAL','DANGEROUS')
  • polygon_json — JSON
  • center_x — FLOAT
  • center_y — FLOAT
  • created_at — TIMESTAMP — NOT NULL

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