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