AIBE6 team2

Tables (4)

bookmarks

  • id — UUID
  • user_id — UUID — Foreign key → profiles.id
  • place_id — UUID — Foreign key → places.id
  • created_at — TIMESTAMP
  • UNIQUE(user_id, — place_id)

places

  • id — UUID
  • name — TEXT — NOT NULL
  • category — TEXT — NOT NULL
  • description — TEXT
  • price_range — TEXT
  • city — TEXT — NOT NULL
  • district — TEXT — NOT NULL
  • address_detail — TEXT — NOT NULL
  • landmark — TEXT
  • has_elevator — BOOLEAN
  • has_ramp — BOOLEAN
  • has_toilet — BOOLEAN
  • created_at — TIMESTAMP

profiles

  • id — UUID
  • nickname — TEXT
  • avatar_url — TEXT
  • user_type — TEXT
  • updated_at — TIMESTAMP

reviews

  • id — UUID
  • place_id — UUID — Foreign key → places.id
  • user_id — UUID — Foreign key → profiles.id
  • content — TEXT — NOT NULL
  • image_urls — TEXT
  • overall_rating — INTEGER
  • entry_rating — INTEGER
  • space_rating — INTEGER
  • toilet_rating — INTEGER
  • created_at — TIMESTAMP