kiosk
테이블 (7)
상품발주 (order_item)
- orderItemId (PK) — int — 기본 키 — NOT NULL
- itemId (PK2) — int — 외래 키 → 품목.itemId — NOT NULL
- orderItemId (PK22) — int — 외래 키 → 품목.orderItemId — NOT NULL
- amount (Field)
- state (Field2)
- createdAt (Field3) — timestamp
- updatedAt (Field4) — timestamp
옵션 (option)
- orderItemId (PK) — int — 기본 키 — NOT NULL
- sizePrice (Field) — int
- shotPrice (Field2) — int
- hot (Field3) — boolean
- shot (Field6) — int
- size (Field7) — enum
- createdAt (Field4) — timestamp
- updatedAt (Field5) — timestamp
옵션 주문상세 (option_order)
- id (PK) — int — 기본 키 — NOT NULL
- ItemOrderCusId (FK) — int — 외래 키 → 품목 주문 고객.itemOrderCusId — NOT NULL
- shot (Field) — int
- size (Field2) — varchar
- extraPrice (Field3) — int
주문 고객 (order_customer)
- orderCustomerId (PK) — int — 기본 키 — NOT NULL
- state (Field) — boolean
- createdAt (Field2) — timestemp
- updatedAt (Field3) — timestemp
쿠폰 (Untitled)
- id (PK) — int — 기본 키 — NOT NULL
- Field
품목 (item)
- itemId (PK) — int — 기본 키 — NOT NULL
- orderItemId (PK2) — int — 외래 키 → 옵션.orderItemId — NOT NULL
- name (Field) — varchar
- price (Field2) — bigint
- type (Field3) — enum
- amount (Field4) — bigint
- updatedAt (Field6) — timestemp
- createdAt (Field5) — timestemp
품목 주문 고객 (item_order_customer)
- itemOrderCusId (PK) — int — 기본 키 — NOT NULL
- orderCustomerId (PK2) — int — 외래 키 → 주문 고객.orderCustomerId — NOT NULL
- itemId (PK3) — int — 외래 키 → 품목.itemId — NOT NULL
- orderItemId (PK22) — int — 외래 키 → 품목.orderItemId — NOT NULL
- amount (Field) — int
- price (Field2) — int
- createdAt (Field3) — timestemp
- updatedAt (Field4) — timestemp