2

Tables (11)

categories

  • category_id — int
  • name — varchar(50) — NOT NULL

missions

  • mission_id — int
  • name — varchar(100) — NOT NULL
  • description — text
  • region — varchar(50) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • inactive_date — datetime
  • restaurant_id — int — NOT NULL

preferences

  • user_id — int — Primary key — NOT NULL
  • category_id — int — Primary key — NOT NULL
  • priority — int
  • created_at — timestamp
  • updated_at — timestamp

regions

  • region_id — int
  • name — varchar(100) — NOT NULL

restaurant_categories

  • restaurant_id — int — Primary key — NOT NULL
  • category_id — int — Primary key — NOT NULL

restaurants

  • restaurant_id — int
  • name — varchar(100) — NOT NULL
  • description — text
  • created_at — timestamp
  • updated_at — timestamp
  • inactive_date — datetime
  • region_id — int — NOT NULL

reviews

  • review_id — int
  • user_id — int
  • restaurant_id — int
  • rating — decimal(3, 2) — NOT NULL
  • comment — text — ext nul
  • created_at — timestamp
  • updated_at — timestamp

terms

  • term_id — int
  • title — varchar(255) — NOT NULL
  • body — text — NOT NULL
  • optional — tinyint(1) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

user_missions

  • user_id — int — Primary key — NOT NULL
  • mission_id — int — Primary key — NOT NULL
  • status — enum

user_terms

  • user_id — int — Primary key — NOT NULL
  • term_id — int — Primary key — NOT NULL
  • agreed_at — timestamp

users

  • user_id — int
  • username — varchar(50) — NOT NULL
  • email — varchar(100) — NOT NULL
  • password_hash — varchar(255) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • inactive_date — datetime