3

Tables (9)

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

user_missions

  • user_id — INT — Primary key — NOT NULL
  • mission_id — INT — Primary key — NOT NULL
  • status — ENUM('in_progress', 'completed')

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