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