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