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