AIBE6 team2

Tables (12)

accessibility_info

  • place_id — BIGINT — Foreign key → places.id
  • parking — BOOLEAN
  • elevator — BOOLEAN
  • escalator — BOOLEAN
  • route — BOOLEAN
  • lift — BOOLEAN
  • restroom — BOOLEAN
  • wheelchair — BOOLEAN
  • stroller — BOOLEAN
  • braille_block — BOOLEAN
  • braille_guide — BOOLEAN
  • audio_guide — BOOLEAN
  • sign_guide — BOOLEAN
  • nursing_room — BOOLEAN
  • diaper_changing — BOOLEAN
  • guide_dog — BOOLEAN
  • accessible_room — BOOLEAN
  • notes — TEXT
  • updated_at — TIMESTAMP

categories

  • id — SMALLINT
  • name — VARCHAR(50) — NOT NULL
  • icon — VARCHAR(10)
  • has_accessibility — BOOLEAN

favorites

  • id — BIGSERIAL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • place_id — BIGINT — Foreign key → places.id — NOT NULL
  • created_at — TIMESTAMP
  • UNIQUE(user_id, — place_id)
  • INDEX — idx_favorites_user
  • INDEX — idx_favorites_place

places

  • id — BIGINT
  • category_id — SMALLINT — Foreign key → categories.id — NOT NULL
  • region_code — SMALLINT — Foreign key → regions.code
  • title — VARCHAR(200) — NOT NULL
  • address — TEXT
  • address_detail — VARCHAR(200)
  • zipcode — VARCHAR(10)
  • latitude — DECIMAL(10, 8)
  • longitude — DECIMAL(11, 8)
  • tel — VARCHAR(50)
  • image_url — TEXT
  • image_thumbnail_url — TEXT
  • homepage_url — TEXT
  • overview — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_places_category
  • INDEX — idx_places_region
  • INDEX — idx_places_title
  • INDEX — idx_places_location

regions

  • code — SMALLINT
  • name — VARCHAR(50) — NOT NULL
  • parent_code — SMALLINT

review_helpful

  • id — BIGSERIAL
  • review_id — BIGINT — Foreign key → reviews.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • created_at — TIMESTAMP
  • UNIQUE(review_id, — user_id)
  • INDEX — idx_review_helpful_review
  • INDEX — idx_review_helpful_user

review_images

  • id — BIGSERIAL
  • review_id — BIGINT — Foreign key → reviews.id — NOT NULL
  • image_url — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • INDEX — idx_review_images_review

reviews

  • id — BIGSERIAL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • place_id — BIGINT — Foreign key → places.id — NOT NULL
  • rating — SMALLINT
  • content — TEXT
  • accessibility_rating — SMALLINT
  • helpful_count — INTEGER
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_reviews_user
  • INDEX — idx_reviews_place
  • INDEX — idx_reviews_rating

sync_logs

  • id — BIGSERIAL
  • sync_type — VARCHAR(50) — NOT NULL
  • category_id — SMALLINT — Foreign key → categories.id
  • total_count — INTEGER
  • success_count — INTEGER
  • fail_count — INTEGER
  • error_message — TEXT
  • started_at — TIMESTAMP
  • completed_at — TIMESTAMP
  • INDEX — idx_sync_logs_type
  • INDEX — idx_sync_logs_started

trip_plan_items

  • id — BIGSERIAL
  • trip_plan_id — BIGINT — Foreign key → trip_plans.id — NOT NULL
  • place_id — BIGINT — Foreign key → places.id — NOT NULL
  • day_number — SMALLINT — NOT NULL
  • order_number — SMALLINT — NOT NULL
  • visit_time — TIME
  • duration_minutes — INTEGER
  • memo — TEXT
  • created_at — TIMESTAMP
  • INDEX — idx_trip_plan_items_plan
  • INDEX — idx_trip_plan_items_place
  • INDEX — idx_trip_plan_items_day

trip_plans

  • id — BIGSERIAL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • start_date — DATE
  • end_date — DATE
  • is_public — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_trip_plans_user
  • INDEX — idx_trip_plans_dates

users

  • id — UUID
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100)
  • profile_image_url — TEXT
  • disability_type — VARCHAR(50)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP