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