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