무역데이터 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