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