RAG
Tables (7)
Untitled (User)
- Key (UserID) — int — Primary key — NOT NULL
- Field (Name) — varchar(255) — NOT NULL
- Field2 (Email) — varchar(255) — NOT NULL
- Field3 (Password) — varchar(255) — NOT NULL
- Field4 (Age) — int
- Field5 (Gender) — varchar(255)
- Field6 (MealMembersCount) — int
- Field7 (Allergies) — text
- Field8 (EatingHabits) — text
- Field9 (RegistrationDate) — varchar(255) — NOT NULL
Untitled (Address)
- Key (AddressID) — int — Primary key — NOT NULL
- Key (UserID) — int — Foreign key → Untitled.Key — NOT NULL
- Field (Address) — text — NOT NULL
- Field (Alias) — varchar(255)
- Field (LastUsedDate) — varchar(255)
Untitled (Restaurant)
- Key (RestaurantID) — int — Primary key — NOT NULL
- Field (Name) — varchar(255) — NOT NULL
- Field (Description) — text
- Field (PhoneNumber) — varchar(20)
- Field (Address) — text — NOT NULL
- Field (BusinessHours) — varchar(255)
- Field (DeliveryTime) — int
- Field (DeliveryFee) — decimal(10, 2)
- Field (Reviews) — text
- Field (Category) — varchar(255)
Untitled (Food)
- Key (FoodID) — int — Primary key — NOT NULL
- Key (RestaurantID) — int — Foreign key → Untitled.Key — NOT NULL
- Field (Name) — varchar(255) — NOT NULL
- Field (Description) — text
- Field (Price) — decimal(10, 2) — NOT NULL
- Field (StockQuantity) — int — NOT NULL
- Field (Ingredients) — text — NOT NULL
- Field (Category) — varchar(255)
- Field (Allergies) — text
- Field (CookingTime) — int
Untitled (Review)
- Key (ReviewID) — int — Primary key — NOT NULL
- Key (UserID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (RestaurantID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (OrderRecordID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (AddressID2) — int — Foreign key → Untitled.Key — NOT NULL
- Key (UserID2) — int — Foreign key → Untitled.Key — NOT NULL
- Field (Content) — text
- Field (Rating) — int
- Field (CreatedAt) — varchar(255) — NOT NULL
Untitled (OrderRecord)
- Key (OrderRecordID) — int — Primary key — NOT NULL
- Key (DeliveryAddressID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (UserID) — int — Foreign key → Untitled.Key — NOT NULL
- Field (Foods) — text
- Field (OrderTime) — varchar(255) — NOT NULL
- Field (RestaurantCategory) — varchar(255)
- Field (FoodCategory) — varchar(255)
- Field (OrderDate) — varchar(255)
- Field (Event) — text
- Field (Weather) — text
- Field (DeliveryPlaceType) — varchar(255)
Untitled (GeneratedResult)
- Key (ResultID) — int — Primary key — NOT NULL
- Key (OrderRecordID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (GeneratedAddressID) — int — Foreign key → Untitled.Key — NOT NULL
- Field (GeneratedText) — text
- Field (GeneratedAt) — varchar(255) — NOT NULL
- Field (RestaurantCategory) — varchar(255)
- Field (FoodCategory) — varchar(255)
- Field (OrderDate) — varchar(255)
- Field (Event) — text
- Field (Weather) — text
- Field (GeneratedPlaceType) — varchar(255)
- Field (RecommendationReason) — text
- Field (MenuCategory) — varchar(255)
- Field (MenuTags) — text