4647_demo

Tables (16)

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

Untitled

    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
    • latest_guideline — JSON
    • guideline_generated_at — TIMESTAMP
    • 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