coffee-order
Tables (4)
Address (addresses)
- address_id — Long — Primary key — NOT NULL
- address (Field) — String
- zipcode (Field2) — String
Menu (Menus)
- menu_id — Long — Primary key — NOT NULL
- name — String
- price — Long
Order (orders)
- order_id — Long — Primary key — NOT NULL
- address_id — Long — Foreign key → Address.address_id — NOT NULL
- email — String
- created_at — LocalDateTime
- order_status — String
OrderItem (order_itmes)
- order_item_id — Long — Primary key — NOT NULL
- order_id — Long — Foreign key → Order.order_id — NOT NULL
- menu_id — Long — Foreign key → Menu.menu_id — NOT NULL
- qunatity — Long