preTest
테이블 (3)
상품 (PRODUCT)
- PNO — NUMBER — 기본 키 — NOT NULL
- PPRICE — NUMBER
- PNAME — VARCHAR2(50)
- PKINDS — VARCHAR2(50)
- PMADE — VARCHAR2(50)
- PDETAILP (PDETAIL) — VARCHAR2(300)
- PAMOUNT — NUMBER
점포 (BRANCH)
- BNO — NUMBER — 기본 키 — NOT NULL — 점포 번호
- BNAME — VARCHAR2(50)
- BPLACE — VARCHAR2(300)
- BBENEFIT — NUMBER
- BMEMCOUNT — NUMBER
점포별상품 (BRANCH_PRODUCT)
- BPNO — NUMBER — 기본 키 — NOT NULL
- BNO — NUMBER — 외래 키 → 점포.BNO — NOT NULL — 점포 번호
- PNO — NUMBER — 외래 키 → 상품.PNO — NOT NULL
- BPPRICE — NUMBER
- BPNAME — VARCHAR2(50)
- BPKINDS — VARCHAR2(50)
- BPMADE — VARCHAR2(50)
- BPDETAIL — VARCHAR2(300)
- BPAMOUNT — NUMBER
- BPDATE — DATE