무역데이터 3조

테이블 (3)

invoice (송장)

  • invocie_id — int — 기본 키 — NOT NULL
  • invoice_number — varchar(20)
  • invoice_date — date

invoice_item (송장상세)

  • item_id — int — 외래 키 → product.product_id — NOT NULL
  • invocie_id — int — 외래 키 → invoice.invocie_id — NOT NULL
  • quantity — int
  • unit_price — int
  • total_amount — int
  • prodcut_id — int

product ((상품))

  • product_id (prodcut_id) — int — 기본 키 — NOT NULL
  • season — varchar(10
  • team — varchar(50)
  • version — varchar(20)
  • name — varchar(100)
  • unit_price — int