busaneumgil
Tables (24)
admin_area_assignments
- assignment_id — bigint — Primary key — NOT NULL
- gu — varchar(50) — NOT NULL
- dong — varchar(50) — NOT NULL
- assignee_user_id — uuid — Foreign key → users.user_id
- status — varchar(30) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- assignment_type — varchar(30) — NOT NULL
admin_areas
- area_id — bigint — Primary key — NOT NULL
- gu — varchar(50) — NOT NULL
- dong — varchar(50) — NOT NULL
- geom — text — NOT NULL
admin_audit_logs
- log_id — bigint — Primary key — NOT NULL
- actor_user_id — uuid — NOT NULL
- action — varchar(80) — NOT NULL
- target_type — varchar(80) — NOT NULL
- target_id — varchar(100)
- gu — varchar(50)
- dong — varchar(50)
- summary — varchar(500) — NOT NULL
- before_json — jsonb
- after_json — jsonb
- created_at — timestamp — NOT NULL
admin_road_network_edit_jobs
- job_id — bigint — Primary key — NOT NULL
- status — varchar(30) — NOT NULL
- request_json — jsonb — NOT NULL
- total_edits — integer — NOT NULL
- processed_edits — integer — NOT NULL
- result_json — jsonb
- error_message — text
- created_at — timestamptz — NOT NULL
- started_at — timestamptz
- finished_at — timestamptz
bookmarks
- bookmark_id — integer — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- place_id — bigint — Foreign key → places.place_id
- user_id — uuid — Foreign key → users.user_id — NOT NULL
- address — varchar(255)
- bookmark_target_id — varchar(32)
- name — varchar(255)
- point — text
- provider — varchar(30)
- provider_category — varchar(255)
- provider_place_id — varchar(100)
bus_stops
- bus_stop_id — bigint — Primary key — NOT NULL
- bstop_id — varchar(30) — NOT NULL
- stop_name — varchar(100) — NOT NULL
- ars_no — varchar(20)
- stop_type — varchar(30)
- point — text — NOT NULL
- active — boolean — NOT NULL
- synced_at — timestamp — NOT NULL
favorite_routes
- fav_route_id — bigint — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- end_label — varchar(255) — NOT NULL
- end_point — text — NOT NULL
- route_name — varchar(511) — NOT NULL
- route_option — varchar(30) — NOT NULL
- route_snapshot_json — jsonb — NOT NULL
- start_label — varchar(255) — NOT NULL
- start_point — text — NOT NULL
- transport_mode — varchar(30) — NOT NULL
- user_id — uuid — Foreign key → users.user_id — NOT NULL
hazard_report_images
- report_img_id — bigint — Primary key — NOT NULL
- display_order — smallint — NOT NULL
- image_url — text — NOT NULL
- report_id — bigint — Foreign key → hazard_reports.report_id — NOT NULL
hazard_reports
- report_id — bigint — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- description — text
- report_point — text — NOT NULL
- report_type — varchar(30) — NOT NULL
- status — varchar(30) — NOT NULL
- user_id — uuid — Foreign key → users.user_id — NOT NULL
- address — varchar(255)
- idempotency_expires_at — timestamp
- idempotency_key — varchar(255)
- idempotency_request_hash — varchar(64)
odsay_load_lane
- odsay_load_lane_id — bigint — Primary key — NOT NULL
- lane_geometries — jsonb — NOT NULL
- map_obj — varchar(255) — NOT NULL
place_accessibility_features
- id — integer — Primary key — NOT NULL
- feature_type — varchar(50) — NOT NULL
- is_available — boolean — NOT NULL
- place_id — bigint — Foreign key → places.place_id — NOT NULL
places
- place_id — bigint — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- address — varchar(255)
- category — varchar(50) — NOT NULL
- name — varchar(255) — NOT NULL
- point — text — NOT NULL
- provider_place_id — varchar(100)
road_nodes
- vertex_id — bigint — Primary key — NOT NULL
- source_node_key — varchar(100) — NOT NULL
- point — text — NOT NULL
road_segments
- edge_id — bigint — Primary key — NOT NULL
- from_node_id — bigint — NOT NULL
- to_node_id — bigint — NOT NULL
- geom — text — NOT NULL
- length_meter — numeric(10,2) — NOT NULL
- audio_signal_state — varchar(30) — NOT NULL
- avg_slope_percent — numeric(6,2)
- braille_block_state — varchar(30) — NOT NULL
- segment_type — varchar(30) — NOT NULL
- signal_state — varchar(30) — NOT NULL
- slope_state — varchar(30) — NOT NULL
- stairs_state — varchar(30) — NOT NULL
- surface_state — varchar(30) — NOT NULL
- walk_access — varchar(30) — NOT NULL
- width_meter — numeric(6,2)
- width_state — varchar(30) — NOT NULL
route_ratings
- rating_id — bigint — Primary key — NOT NULL
- user_id — uuid — Foreign key → users.user_id — NOT NULL
- session_id — uuid — Foreign key → route_sessions.session_id — NOT NULL
- route_id — varchar(120) — NOT NULL
- score — smallint — NOT NULL
- route_context_json — jsonb — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
route_sessions
- session_id — uuid — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- end_point — text — NOT NULL
- route_id — varchar(120) — NOT NULL
- route_snapshot_json — jsonb — NOT NULL
- start_point — text — NOT NULL
- status — varchar(30) — NOT NULL
- user_id — uuid — Foreign key → users.user_id — NOT NULL
- active_route_key — varchar(120)
routing_segment_overrides
- edge_id — bigint — Foreign key → road_segments.edge_id — NOT NULL
- walk_access — varchar(30) — NOT NULL
segment_features
- feature_id — bigint — Primary key — NOT NULL
- edge_id — bigint — Foreign key → road_segments.edge_id — NOT NULL
- feature_type — varchar(50) — NOT NULL
- geom — text — NOT NULL
- state — varchar(50)
- value_number — numeric(10,2)
source_features
- source_feature_id — bigint — Primary key — NOT NULL
- feature_type — varchar(50) — NOT NULL
- geom — text — NOT NULL
- state — varchar(50)
- value_number — numeric(10,2)
- source_file — varchar(255) — NOT NULL
subway_station_accessibility_features
- id — bigint — Primary key — NOT NULL
- subway_station_id — bigint — Foreign key → subway_stations.subway_station_id — NOT NULL
- feature_type — varchar(50) — NOT NULL
- is_available — boolean — NOT NULL
subway_station_elevators
- subway_station_elevator_id — bigint — Primary key — NOT NULL
- line_name — varchar(50) — NOT NULL
- odsay_station_id — varchar(30) — NOT NULL
- point — text — NOT NULL
- station_name — varchar(100) — NOT NULL
subway_stations
- subway_station_id — bigint — Primary key — NOT NULL
- odsay_station_id — varchar(30) — NOT NULL
- station_name — varchar(100) — NOT NULL
- line_name — varchar(50) — NOT NULL
- point — text
subway_timetables
- subway_timetable_id — bigint — Primary key — NOT NULL
- odsay_station_id — varchar(30) — NOT NULL
- service_day_type — varchar(30) — NOT NULL
- way_code — integer — NOT NULL
- departure_time_text — varchar(10) — NOT NULL
- departure_second_of_day — integer — NOT NULL
- end_station_name — varchar(100) — NOT NULL
users
- user_id — uuid — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- selected_mobility_subtype — varchar(30)
- selected_primary_user_type — varchar(30) — NOT NULL
- social_provider — varchar(30) — NOT NULL
- social_provider_user_id — varchar(100) — NOT NULL
- role — varchar(30) — NOT NULL