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