asd
Tables (5)
Corner
- corner_id — INT — Primary key — NOT NULL
- corner_name — VARCHAR(50) — NOT NULL
Menu
- menu_id — INT — Primary key — NOT NULL
- menu_name — VARCHAR(50) — NOT NULL
- corner_id — INT — Foreign key → Corner.corner_id — NOT NULL
OrderDetail
- order_id — INT — Primary key — NOT NULL
- corner_id — INT — Foreign key → Corner.corner_id — NOT NULL
- menu_id — INT — Foreign key → Menu.menu_id — NOT NULL
- order_page_id — INT — Foreign key → OrderPage.order_page_id — NOT NULL
- payment_id — INT — Foreign key → Payment.payment_id — NOT NULL
OrderPage
- order_page_id — INT — Primary key — NOT NULL
- order_page_name — VARCHAR(50) — NOT NULL
- price — DECIMAL(10, 2)
- quantity — INT
- totalPrice — DECIMAL(10, 2
Payment
- payment_id — INT — Primary key — NOT NULL
- payment_name — VARCHAR(50) — NOT NULL