asd

Tables (4)

place_facility_snapshots

  • id — BIGINT — Primary key — NOT NULL
  • place_id — BIGINT — Foreign key → places.id — NOT NULL
  • facility_type — VARCHAR(60) — NOT NULL
  • facility_name — VARCHAR(200)
  • address — VARCHAR(500)
  • latitude — DECIMAL(10,7)
  • longitude — DECIMAL(10,7)
  • distance_m — INT
  • walk_distance_m — INT
  • walk_minutes — INT
  • open_time — VARCHAR(300)
  • phone — VARCHAR(100)
  • source_code — VARCHAR(80) — NOT NULL
  • source_id — VARCHAR(200)
  • rank_order — INT — NOT NULL
  • confidence — VARCHAR(20) — NOT NULL
  • extra_json — JSON
  • refreshed_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — idx_facility_snapshots_place_id
  • INDEX — idx_facility_snapshots_type_distance
  • INDEX — idx_facility_snapshots_source

place_recommendation_features

  • place_id — BIGINT — Foreign key → places.id — NOT NULL
  • static_score — INT — NOT NULL
  • has_barrier_free — TINYINT(1) — NOT NULL
  • has_wheelchair_text — TINYINT(1) — NOT NULL
  • has_elevator_text — TINYINT(1) — NOT NULL
  • has_accessible_toilet_text — TINYINT(1) — NOT NULL
  • has_parking_text — TINYINT(1) — NOT NULL
  • nearest_toilet_distance_m — INT
  • nearest_accessible_toilet_distance_m — INT
  • nearest_heat_shelter_distance_m — INT
  • nearest_wheelchair_charger_distance_m — INT
  • nearest_disabled_facility_distance_m — INT
  • disabled_facility_count_500m — INT — NOT NULL
  • nearest_subway_station_distance_m — INT
  • nearest_subway_walk_distance_m — INT
  • nearest_subway_walk_minutes — INT
  • nearest_bus_stop_distance_m — INT
  • nearest_bus_walk_distance_m — INT
  • nearest_bus_walk_minutes — INT
  • public_transport_access_score — INT — NOT NULL
  • osm_bench_count_300m — INT — NOT NULL
  • osm_cafe_count_500m — INT — NOT NULL
  • osm_shelter_count_500m — INT — NOT NULL
  • osm_bus_stop_count_500m — INT — NOT NULL
  • osm_subway_entrance_count_700m — INT — NOT NULL
  • osm_park_count_800m — INT — NOT NULL
  • osm_garden_count_800m — INT — NOT NULL
  • osm_wood_count_800m — INT — NOT NULL
  • related_count — INT — NOT NULL
  • related_tourist_count — INT — NOT NULL
  • related_food_count — INT — NOT NULL
  • related_lodging_count — INT — NOT NULL
  • has_image — TINYINT(1) — NOT NULL
  • score_basis_json — JSON
  • feature_version — VARCHAR(30) — NOT NULL
  • refreshed_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — idx_features_static_score
  • INDEX — idx_features_barrier_free
  • INDEX — idx_features_accessible_toilet_distance
  • INDEX — idx_features_heat_shelter_distance
  • INDEX — idx_features_wheelchair_charger_distance
  • INDEX — idx_features_disabled_facility_distance
  • INDEX — idx_features_public_transport_access
  • INDEX — idx_features_subway_walk
  • INDEX — idx_features_bus_walk
  • INDEX — idx_features_osm_rest
  • INDEX — idx_features_related_count

place_related_spot_summaries

  • place_id — BIGINT — Foreign key → places.id — NOT NULL
  • base_ym — VARCHAR(10)
  • related_count — INT — NOT NULL
  • tourist_spot_count — INT — NOT NULL
  • food_count — INT — NOT NULL
  • lodging_count — INT — NOT NULL
  • top_related_json — JSON
  • mapped_related_json — JSON
  • source_code — VARCHAR(80) — NOT NULL
  • confidence — VARCHAR(20) — NOT NULL
  • refreshed_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — idx_related_summaries_count
  • INDEX — idx_related_summaries_tourist_count

places

  • id — BIGINT — Primary key — NOT NULL
  • tourapi_content_id — VARCHAR(30) — NOT NULL
  • content_type_id — VARCHAR(20)
  • category — VARCHAR(50)
  • name — VARCHAR(200) — NOT NULL
  • address — VARCHAR(500)
  • address_detail — VARCHAR(500)
  • district — VARCHAR(30)
  • latitude — DECIMAL(10,7) — NOT NULL
  • longitude — DECIMAL(10,7) — NOT NULL
  • tel — VARCHAR(100)
  • image_url — VARCHAR(1000)
  • thumbnail_url — VARCHAR(1000)
  • tourapi_created_time — VARCHAR(20)
  • tourapi_modified_time — VARCHAR(20)
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — idx_places_district
  • INDEX — idx_places_category
  • INDEX — idx_places_lat_lng
  • INDEX — idx_places_name