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