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