LW - 산불 프로젝트 ERD

테이블 (36)

access_route

  • id — uuid — NOT NULL
  • fire_id — uuid
  • name — varchar(255)
  • route_geometry — geography(LineString, 4326) — NOT NULL
  • origin_location — geography(Point, 4326)
  • destination_location — geography(Point, 4326)
  • distance — numeric(10, 2)
  • estimated_time_vehicle — integer
  • vehicle_limit_point — geography(Point, 4326)
  • walk_distance_after_vehicle — numeric(10, 2)
  • risk_level — dashboard.route_risk_level
  • status — dashboard.route_status — NOT NULL
  • route_order — integer
  • road_attributes — jsonb
  • is_active — boolean — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

activity_log

  • id — uuid — NOT NULL
  • user_id — uuid — NOT NULL
  • action — varchar(30) — NOT NULL
  • ip_address — varchar(45)
  • user_agent — varchar(500)
  • metadata — jsonb
  • created_at — timestamp — NOT NULL

alert

  • id — uuid — NOT NULL
  • fire_id — uuid
  • template_id — uuid
  • title — varchar(255) — NOT NULL
  • content — text — NOT NULL
  • alert_type — dashboard.alert_type — NOT NULL
  • priority — dashboard.alert_priority — NOT NULL
  • target_zones — text
  • target_boundary — geography(Polygon, 4326)
  • channels — varchar(20) — NOT NULL
  • scheduled_time — timestamp
  • sent_at — timestamp
  • status — dashboard.alert_status — NOT NULL
  • created_by — uuid — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

alert_template

  • id — uuid — NOT NULL
  • name — varchar(255) — NOT NULL
  • template_type — dashboard.template_type — NOT NULL
  • title_template — varchar(255) — NOT NULL
  • content_template — text — NOT NULL
  • variables — text
  • default_channels — varchar(20)
  • is_active — boolean — NOT NULL
  • created_by — uuid — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

basemap_source

  • id — uuid — NOT NULL
  • name — varchar(255) — NOT NULL
  • source_type — dashboard.basemap_type — NOT NULL
  • url — varchar(1000) — NOT NULL
  • attribution — varchar(500)
  • min_zoom — integer
  • max_zoom — integer
  • is_default — boolean — NOT NULL
  • is_active — boolean — NOT NULL
  • config — jsonb
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

custom_view

  • id — uuid — NOT NULL
  • user_id — uuid — NOT NULL
  • name — varchar(100) — NOT NULL
  • is_default — boolean — NOT NULL
  • settings — jsonb — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

danger_zone

  • id — uuid — NOT NULL
  • fire_id — uuid
  • name — varchar(255)
  • zone_type — dashboard.zone_type — NOT NULL
  • risk_level — dashboard.danger_risk_level — NOT NULL
  • boundary — geography(Polygon, 4326) — NOT NULL
  • description — text
  • evacuation_priority — dashboard.evacuation_priority
  • is_active — boolean — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deactivated_at — timestamp

decision_report

  • id — uuid — NOT NULL
  • fire_id — uuid
  • title — varchar(255) — NOT NULL
  • report_type — dashboard.report_type — NOT NULL
  • content — text
  • summary — text
  • charts_data — jsonb
  • map_snapshot_url — varchar(500)
  • attachments — jsonb
  • status — dashboard.decision_report_status — NOT NULL
  • created_by — uuid — NOT NULL
  • approved_by — uuid
  • approved_at — timestamp
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

drawing_object

  • id — uuid — NOT NULL
  • fire_id — uuid
  • created_by — uuid — NOT NULL
  • object_type — dashboard.drawing_type — NOT NULL
  • geometry — geography — NOT NULL
  • label — varchar(255)
  • description — text
  • color — varchar(20)
  • stroke_width — integer
  • fill_opacity — numeric(3, 2)
  • is_visible — boolean — NOT NULL
  • z_order — integer
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

evacuation_route

  • id — uuid — NOT NULL
  • fire_id — uuid
  • name — varchar(255)
  • route_geometry — geography(LineString, 4326) — NOT NULL
  • origin_location — geography(Point, 4326)
  • destination_shelter_id — uuid
  • distance — numeric(10, 2)
  • estimated_time_walk — integer
  • estimated_time_vehicle — integer
  • difficulty — dashboard.difficulty_level
  • risk_level — dashboard.route_risk_level
  • status — dashboard.route_status — NOT NULL
  • route_order — integer
  • is_active — boolean — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

facility_resource

  • id — uuid — NOT NULL
  • name — varchar(255) — NOT NULL
  • resource_type — dashboard.resource_type — NOT NULL
  • location — geography(Point, 4326)
  • current_fire_id — uuid
  • status — dashboard.resource_status — NOT NULL
  • capacity — numeric(10, 2)
  • current_load — numeric(10, 2)
  • specifications — jsonb
  • assigned_team_id — uuid
  • last_update — timestamp
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

fire

  • id — uuid — NOT NULL
  • name — varchar(255) — NOT NULL
  • location — geography(Point, 4326)
  • address — varchar(500)
  • status — dashboard.fire_status — NOT NULL
  • severity — dashboard.severity_level — NOT NULL
  • fire_type — dashboard.fire_type
  • estimated_area — numeric(12, 2)
  • perimeter — geography(Polygon, 4326)
  • spread_rate — numeric(8, 2)
  • start_time — timestamp — NOT NULL
  • contained_time — timestamp
  • extinguished_time — timestamp
  • suppression_rate — numeric(5, 2)
  • personnel_count — integer
  • resource_count — integer
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

fire_water_facility

  • id — uuid — NOT NULL
  • name — varchar(255) — NOT NULL
  • facility_type — dashboard.water_facility_type — NOT NULL
  • location — geography(Point, 4326) — NOT NULL
  • address — varchar(500)
  • capacity — numeric(10, 2)
  • current_level — numeric(5, 2)
  • status — dashboard.water_facility_status — NOT NULL
  • last_inspection_date — date
  • is_active — boolean — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

geofence

  • id — uuid — NOT NULL
  • fire_id — uuid
  • danger_zone_id — uuid
  • name — varchar(255)
  • boundary — geography(Polygon, 4326) — NOT NULL
  • buffer_distance — numeric(8, 2)
  • alert_type — dashboard.geofence_type — NOT NULL
  • is_active — boolean — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

geofence_alert

  • id — uuid — NOT NULL
  • user_id — uuid — NOT NULL
  • geofence_id — uuid — NOT NULL
  • fire_id — uuid
  • alert_type — accessroute.geofence_alert_type — NOT NULL
  • user_location — geography(Point, 4326) — NOT NULL
  • distance_to_boundary — numeric(10, 2)
  • acknowledged — boolean — NOT NULL
  • acknowledged_at — timestamp
  • created_at — timestamp — NOT NULL

helipad

  • id — uuid — NOT NULL
  • name — varchar(255) — NOT NULL
  • location — geography(Point, 4326) — NOT NULL
  • address — varchar(500)
  • helipad_type — dashboard.helipad_type
  • surface_type — varchar(50)
  • max_weight — numeric(10, 2)
  • status — dashboard.helipad_status — NOT NULL
  • night_operation — boolean
  • contact_info — varchar(255)
  • is_active — boolean — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

map

  • id — uuid — NOT NULL
  • name — varchar(255) — NOT NULL
  • map_type — dashboard.map_type — NOT NULL
  • file_url — varchar(1000)
  • file_size — bigint
  • boundary — geography(Polygon, 4326)
  • crs — varchar(50)
  • description — text
  • is_offline_available — boolean — NOT NULL
  • uploaded_by — uuid
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

map_layer

  • id — uuid — NOT NULL
  • name — varchar(255) — NOT NULL
  • layer_key — varchar(100) — NOT NULL
  • layer_type — dashboard.layer_type — NOT NULL
  • description — varchar(500)
  • default_visible — boolean — NOT NULL
  • default_opacity — numeric(3, 2)
  • z_order — integer
  • style_config — jsonb
  • required_role_groups — uuid
  • is_active — boolean — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

movement_path

  • id — uuid — NOT NULL
  • user_id — uuid — NOT NULL
  • fire_id — uuid
  • path_geometry — geography(LineString, 4326)
  • start_time — timestamp — NOT NULL
  • end_time — timestamp
  • total_distance — numeric(10, 2)
  • is_shared — boolean — NOT NULL
  • shared_with_team_id — uuid
  • created_at — timestamp — NOT NULL

notice

  • id — uuid — NOT NULL
  • title — varchar(255) — NOT NULL
  • content — text — NOT NULL
  • category — dashboard.notice_category — NOT NULL
  • is_pinned — boolean — NOT NULL
  • is_published — boolean — NOT NULL
  • published_at — timestamp
  • expires_at — timestamp
  • view_count — integer — NOT NULL
  • created_by — uuid — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

operation_order

  • id — uuid — NOT NULL
  • group_id — uuid
  • fire_id — uuid
  • title — varchar(255) — NOT NULL
  • content — text — NOT NULL
  • priority — dashboard.order_priority — NOT NULL
  • target_region — varchar(255) — NOT NULL
  • target_boundary — geography(Polygon, 4326)
  • issued_by — uuid — NOT NULL
  • issued_at — timestamp — NOT NULL
  • expires_at — timestamp
  • status — dashboard.order_status — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

operation_order_group

  • id — uuid — NOT NULL
  • fire_id — uuid
  • name — varchar(255) — NOT NULL
  • description — text
  • created_by — uuid — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

operation_order_receipt

  • id — uuid — NOT NULL
  • order_id — uuid — NOT NULL
  • user_id — uuid — NOT NULL
  • received_at — timestamp — NOT NULL
  • acknowledged_at — timestamp

password_reset_token

  • id — uuid — NOT NULL
  • user_id — uuid — NOT NULL
  • token — varchar(255) — NOT NULL
  • expires_at — timestamp — NOT NULL
  • used — boolean — NOT NULL
  • created_at — timestamp — NOT NULL

personnel_location

  • id — uuid — NOT NULL
  • user_id — uuid — NOT NULL
  • fire_id — uuid
  • location — geography(Point, 4326) — NOT NULL
  • altitude — numeric(8, 2)
  • accuracy — numeric(6, 2)
  • heading — numeric(5, 2)
  • speed — numeric(6, 2)
  • status — accessroute.personnel_status — NOT NULL
  • battery_level — integer
  • recorded_at — timestamp — NOT NULL

point

  • id — uuid — NOT NULL
  • user_id — uuid — NOT NULL
  • fire_id — uuid
  • name — varchar(255)
  • location — geography(Point, 4326) — NOT NULL
  • point_type — accessroute.point_type
  • description — text
  • is_shared — boolean — NOT NULL
  • shared_with_team_id — uuid
  • attachments — jsonb
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

road

  • id — uuid — NOT NULL
  • name — varchar(255)
  • road_type — dashboard.road_type — NOT NULL
  • geometry — geography(LineString, 4326) — NOT NULL
  • width — numeric(5, 2)
  • surface_type — varchar(30)
  • status — dashboard.road_status — NOT NULL
  • vehicle_accessible — boolean
  • max_vehicle_weight — numeric(8, 2)
  • speed_limit — integer
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

role_group

  • id — uuid — NOT NULL
  • name — varchar(50) — NOT NULL
  • description — varchar(255)
  • permissions — jsonb
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

scenario

  • id — uuid — NOT NULL
  • name — varchar(255) — NOT NULL
  • description — text
  • scenario_type — dashboard.scenario_type — NOT NULL
  • fire_id — uuid
  • roi_boundary — geography(Polygon, 4326)
  • ignition_point — geography(Point, 4326)
  • parameters — jsonb — NOT NULL
  • simulation_results — jsonb
  • predicted_spread — geography(MultiPolygon, 4326)
  • status — dashboard.scenario_status — NOT NULL
  • created_by — uuid — NOT NULL
  • started_at — timestamp
  • completed_at — timestamp
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

session

  • id — uuid — NOT NULL
  • user_id — uuid — NOT NULL
  • refresh_token — varchar(500) — NOT NULL
  • device_info — varchar(255)
  • ip_address — varchar(45)
  • user_agent — varchar(500)
  • expires_at — timestamp — NOT NULL
  • is_valid — boolean — NOT NULL
  • created_at — timestamp — NOT NULL
  • last_active_at — timestamp — NOT NULL

situation_report

  • id — uuid — NOT NULL
  • user_id — uuid — NOT NULL
  • fire_id — uuid
  • location — varchar(500)
  • coordinates — geography(Point, 4326)
  • fire_intensity — dashboard.severity_level
  • wind_condition — varchar(255)
  • hazards — text
  • required_resources — text
  • additional_notes — text
  • attachments — jsonb
  • status — accessroute.report_status — NOT NULL
  • priority — accessroute.report_priority — NOT NULL
  • acknowledged_at — timestamp
  • acknowledged_by — uuid
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

sos_alert

  • id — uuid — NOT NULL
  • user_id — uuid — NOT NULL
  • fire_id — uuid
  • location — geography(Point, 4326) — NOT NULL
  • address — varchar(500)
  • status — accessroute.sos_status — NOT NULL
  • description — text
  • responded_by — uuid
  • responded_at — timestamp
  • resolved_at — timestamp
  • resolution_notes — text
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

team

  • id — uuid — NOT NULL
  • name — varchar(100) — NOT NULL
  • description — varchar(255)
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • region — varchar(100) — 담당

user

  • id — uuid — NOT NULL
  • username — varchar(50) — NOT NULL
  • email — varchar(255) — NOT NULL
  • name — varchar(100) — NOT NULL
  • password_hash — varchar(255)
  • phone — varchar(20)
  • department — varchar(100)
  • position — varchar(50)
  • profile_image — varchar(500)
  • role_group_id — uuid
  • status — dashboard.user_status — NOT NULL
  • team_id — uuid
  • failed_login_attempts — integer — NOT NULL
  • locked_until — timestamp
  • last_login_at — timestamp
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • withdrawn_at — timestamp
  • region — varchar(100) — 관할

verification_code

  • id — uuid — NOT NULL
  • target — varchar(255) — NOT NULL
  • code — varchar(10) — NOT NULL
  • type — dashboard.verification_type — NOT NULL
  • expires_at — timestamp — NOT NULL
  • verified — boolean — NOT NULL
  • created_at — timestamp — NOT NULL

weather_data

  • id — uuid — NOT NULL
  • location — geography(Point, 4326) — NOT NULL
  • observation_time — timestamp — NOT NULL
  • temperature — numeric(5, 2)
  • humidity — numeric(5, 2)
  • wind_speed — numeric(6, 2)
  • wind_direction — integer
  • wind_direction_text — varchar(10)
  • pressure — numeric(7, 2)
  • precipitation — numeric(6, 2)
  • precipitation_probability — numeric(5, 2)
  • visibility — numeric(8, 2)
  • uv_index — integer
  • source — varchar(50)
  • created_at — timestamp — NOT NULL