BackOffice
Tables (5)
Menu (메뉴)
- PK (id) — Primary key — NOT NULL
- content (내용)
- stats (상태)
- price (가격)
- FK (store_id) — Foreign key → store.PK — NOT NULL
User (멤버)
- PK (id) — Primary key — NOT NULL
- Field
- Field2
- Field3
cart (장바구니)
- PK (id) — Primary key — NOT NULL
- count (갯수)
- price (가격)
- FK (orderhistor_id) — Foreign key → orderHistory.PK — NOT NULL
- FK (menu_id) — Foreign key → Menu.PK — NOT NULL
orderHistory (주문하기및주문내역)
- PK (id) — Primary key — NOT NULL
- price (가격)
- ordeer_At (주문시간)
- FK (user_id) — Foreign key → User.PK — NOT NULL
- status (주문상태)
store (Untitled)
- PK (id) — Primary key — NOT NULL
- Field
- Field2
- FK (user_id) — Foreign key → User.PK — NOT NULL