weekly

Tables (5)

Customer (Untitled4)

  • CustomerId — Long — Primary key — NOT NULL
  • name — String
  • phoneNumber — String
  • address — String

Menu

  • menuId — Long — Primary key — NOT NULL
  • name — String
  • category — String
  • price — double
  • description — String

Order

  • orderId — Long — Primary key — NOT NULL
  • status — String
  • totalPrice — double
  • CustomerId — Long — Foreign key → Customer.CustomerId — NOT NULL
  • StoreId — Long — Foreign key → Store.StoreId — NOT NULL

OrderItem (Untitled)

  • orderId — Long — Foreign key → Order.orderId — NOT NULL
  • menuId — Long — Foreign key → Menu.menuId — NOT NULL

Store

  • StoreId — Long — Primary key — NOT NULL
  • name — String
  • adress — String
  • number — String