zeroplay

Tables (18)

ai_bookmarks

  • id — integer — Primary key — NOT NULL
  • user_session_id — character — NOT NULL
  • route_id — character — NOT NULL
  • title — character — NOT NULL
  • route_data — jsonb — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • total_budget — integer
  • duration_hours — integer
  • places_count — integer
  • region_codes — ARRAY

benefit_bookmarks

  • id — integer — Primary key — NOT NULL
  • user_id — character
  • benefit_id — integer
  • created_at — timestamp

benefit_categories

  • id — character — Primary key — NOT NULL
  • name — character — NOT NULL
  • icon — character
  • color — character
  • sort_order — integer

benefit_regions

  • benefit_id — integer — Primary key — NOT NULL
  • region_id — character — Primary key — NOT NULL

benefit_regions_lookup

  • id — character — Primary key — NOT NULL
  • name — character — NOT NULL
  • sort_order — integer

benefit_tag_relations

  • benefit_id — integer — Primary key — NOT NULL
  • tag_id — integer — Primary key — NOT NULL

benefit_tags

  • id — integer — Primary key — NOT NULL
  • name — character — NOT NULL
  • color — character

benefits

  • id — integer — Primary key — NOT NULL
  • title — character — NOT NULL
  • provider — character — NOT NULL
  • category_id — character
  • amount — character
  • amount_type — character
  • target_summary — character
  • period_text — character
  • is_ongoing — boolean
  • deadline_status — character
  • application_url — character
  • info_url — character
  • description — text
  • conditions_summary — text
  • how_to_apply — text
  • important_notes — text
  • status — character
  • priority — character
  • view_count — integer
  • created_at — timestamp
  • updated_at — timestamp
  • region — text
  • detailed_content — text
  • eligibility_details — text
  • application_process — text
  • website_url — text
  • phone_number — text
  • application_difficulty — text

cities

  • id — integer — Primary key — NOT NULL
  • city_code — text — NOT NULL
  • city_name — text — NOT NULL
  • region_id — integer
  • latitude — numeric
  • longitude — numeric
  • created_at — timestamp

destination_reviews

  • id — bigint — Primary key — NOT NULL
  • destination_id — bigint
  • session_id — text
  • rating — integer
  • review_text — text
  • visit_date — date
  • companion_type — text
  • created_at — timestamp

local_deals

  • id — uuid — Primary key — NOT NULL
  • spot_id — uuid — NOT NULL
  • title — character — NOT NULL
  • description — text
  • deal_type — character — NOT NULL
  • deal_value — character — NOT NULL
  • original_price — integer
  • start_date — timestamp — NOT NULL
  • end_date — timestamp — NOT NULL
  • max_usage — integer
  • current_usage — integer
  • terms_and_conditions — text
  • is_active — boolean
  • created_at — timestamp
  • updated_at — timestamp

local_spots

  • id — uuid — Primary key — NOT NULL
  • name — character — NOT NULL
  • category — character — NOT NULL
  • description — text
  • address — text — NOT NULL
  • latitude — numeric — NOT NULL
  • longitude — numeric — NOT NULL
  • operating_hours — jsonb
  • price_range — text
  • images — ARRAY
  • reservation_link — text
  • rating — numeric
  • review_count — integer
  • is_active — boolean
  • created_at — timestamp
  • updated_at — timestamp

map_bookmarks

  • id — uuid — Primary key — NOT NULL
  • user_id — uuid — NOT NULL
  • spot_id — uuid
  • deal_id — uuid
  • bookmark_type — character
  • created_at — timestamp

regions

  • id — integer — Primary key — NOT NULL
  • region_code — text — NOT NULL
  • region_name — text — NOT NULL
  • created_at — timestamp
  • name — character
  • sort_order — integer

travel_destinations

  • id — bigint — Primary key — NOT NULL
  • name — text — NOT NULL
  • region — text — NOT NULL
  • category — text — NOT NULL
  • description — text
  • address — text
  • latitude — numeric
  • longitude — numeric
  • price_range — text
  • duration_hours — integer
  • companion_type — ARRAY
  • tags — ARRAY
  • rating — numeric
  • image_url — text
  • score — numeric
  • avg_stay_minutes — integer
  • entry_fee — integer
  • place_type — text
  • created_at — timestamp
  • embedding — USER-DEFINED
  • city_id — integer

travel_routes

  • id — bigint — Primary key — NOT NULL
  • title — text — NOT NULL
  • region — text — NOT NULL
  • total_duration — text
  • total_budget — integer
  • companion_type — text
  • theme — ARRAY
  • difficulty — text
  • destinations — jsonb
  • created_at — timestamp
  • embedding — USER-DEFINED

user_recommendations

  • id — bigint — Primary key — NOT NULL
  • session_id — text
  • filter_conditions — jsonb
  • chat_history — jsonb
  • recommended_route — jsonb
  • user_rating — integer
  • created_at — timestamp

user_sessions

  • id — bigint — Primary key — NOT NULL
  • session_id — text — NOT NULL
  • user_preferences — jsonb
  • created_at — timestamp
  • last_active — timestamp