AI - EAT

Tables (5)

Allergy

  • Allergy_ID (Key) — varChar — Primary key — NOT NULL
  • ID (Key2) — Integer — Foreign key → User.ID — NOT NULL
  • Ingredient (Field2) — varChar
  • Severity (Field3) — Integer

Preference

  • Preference_ID (Key) — Integer — Primary key — NOT NULL
  • ID (Key2) — Integer — Foreign key → User.ID — NOT NULL
  • Spicy_Level (Field2) — Integer
  • Atmosphere_Like (Field3) — varChar

Restaurant

  • Restaurant_ID (Key) — Integer — Primary key — NOT NULL
  • Name (Field) — varChar
  • Location (Field2) — varChar
  • Category (Field3) — varChar

Review

  • Review_ID (Key) — Integer — Primary key — NOT NULL
  • ID (Key2) — Integer — Foreign key → User.ID — NOT NULL
  • Restaurant_ID (Key3) — Integer — Foreign key → Restaurant.Restaurant_ID — NOT NULL
  • Comment (Field3) — varChar

User

  • ID (Key) — Integer — Primary key — NOT NULL
  • Field — varChar
  • Email (Field2) — varChar — NOT NULL
  • Allergy_Info (Field3) — Boolean
  • Field4 — varChar