foodiest
Tables (9)
follows
- id — bigint — Primary key — NOT NULL
- follower_auth_id — uuid — NOT NULL
- following_auth_id — uuid — NOT NULL
- created_at — timestamp
menus
- id — integer — Primary key — NOT NULL
- restaurant_id — integer — Foreign key → restaurants.id — NOT NULL
- name — text — NOT NULL
- price — integer — NOT NULL
notifications
- id — uuid — Primary key — NOT NULL
- user_id — uuid — Foreign key → users.id — NOT NULL
- type — text — NOT NULL
- from_user_id — uuid — Foreign key → users.id
- is_read — boolean — NOT NULL
- created_at — timestamp
reports
- id — uuid — Primary key — NOT NULL
- reporter_id — uuid — Foreign key → users.id — NOT NULL
- report_type — text — NOT NULL
- review_id — text — Foreign key → reviews.id
- restaurant_id — integer — Foreign key → restaurants.id
- reported_user_id — uuid — Foreign key → users.id
- created_at — timestamp
reservations
- id — uuid — Primary key — NOT NULL
- user_id — uuid — Foreign key → users.id — NOT NULL
- restaurant_id — integer — Foreign key → restaurants.id — NOT NULL
- date — date — NOT NULL
- time — text — NOT NULL
- party_size — integer — NOT NULL
- status — text — NOT NULL
- created_at — timestamp
restaurants
- id — integer — Primary key — NOT NULL
- name — text — NOT NULL
- cuisine — text
- price — text
- rating — numeric
- distance — text
- badge — text
- event — text
- tags — ARRAY
- note — text
- quote — text
- image — text
- vibes — ARRAY
- flavors — ARRAY
- dietary — ARRAY
- x — numeric
- y — numeric
- description — text
- hours — jsonb
- phone — text
- website — text
- created_at — timestamp
- sub_images — ARRAY
- address — text
reviews
- id — text — Primary key — NOT NULL
- restaurant_id — integer — Foreign key → restaurants.id — NOT NULL
- review_text — text — NOT NULL
- rating — smallint — NOT NULL
- images — ARRAY
- keywords — jsonb
- created_at — timestamp
- updated_at — timestamp
- user_id — bigint — Foreign key → users.id — NOT NULL
- negative_keywords — ARRAY
saved_restaurants
- id — integer — Primary key — NOT NULL
- restaurant_id — integer — Foreign key → restaurants.id — NOT NULL
- saved_at — timestamp
- user_id — bigint — Foreign key → users.id — NOT NULL
users
- id — bigint — Primary key — NOT NULL
- user_id — text — NOT NULL
- nickname — text — NOT NULL
- email — text — NOT NULL
- phone — text
- profile_image — text
- provider — text — NOT NULL
- social_id — text
- vibes — ARRAY
- flavors — ARRAY
- dietary — ARRAY
- allergies — ARRAY
- created_at — timestamp
- updated_at — timestamp
- password — text
- role — text — NOT NULL
- auth_id — uuid — Foreign key → users.id — NOT NULL
- bio — text
- best_restaurants — ARRAY
- cover_image — text
- best_restaurant_comments — ARRAY