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