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