Store

테이블 (3)

상품 (product)

  • id (Key) — BIGINT — 기본 키 — NOT NULL
  • name (Field) — CHARACTER VARYING(255)
  • quantity (Field2) — BIGINT
  • price (Field3) — BIGINT

주문 (order)

  • id (key) — BIGINT — 기본 키 — NOT NULL
  • orderer (Field) — CHARACTER VARYING(50)
  • ordererAddress (Field2) — CHARACTER VARYING(255)
  • orderDate (Field3) — TIMESTAMP(6)
  • totalPrice (Field4) — BIGINT
  • version (Field5) — BIGINT

주문 상품 (order_product)

  • id (Key) — BIGINT — 기본 키 — NOT NULL
  • orderId (key2) — BIGINT — 외래 키 → 주문.id — NOT NULL
  • productId (key3) — BIGINT — 외래 키 → 상품.id — NOT NULL
  • productName (Field) — CHARACTER VARYING(255)
  • quantity (Field2) — BIGINT
  • price (Field3) — BIGINT