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