압김최 2

테이블 (6)

category

  • cID — VARCHAR2(30) — 기본 키 — NOT NULL
  • cname — VARCHAR2(30)

category2

  • c2ID — VARCHAR2(30) — 기본 키 — NOT NULL
  • c2name — VARCHAR2(30)
  • cID — VARCHAR2(30) — NOT NULL
  • cID (cID2) — VARCHAR2(30) — 외래 키 → category.cID — NOT NULL

category3

  • c3ID — VARCHAR2(30) — 기본 키 — NOT NULL
  • c3name — VARCHAR2(30)
  • c2ID — VARCHAR2(30) — NOT NULL
  • c2ID (c2ID2) — VARCHAR2(30) — 외래 키 → category2.c2ID — NOT NULL

detailed

  • c3ID — VARCHAR2(30) — 외래 키 → category3.c3ID — NOT NULL
  • dcname1 — VARCHAR2(20)
  • dcname2 — VARCHAR2(20)
  • dcname3 — VARCHAR2(20)
  • dcname4 — VARCHAR2(20)

product

  • pID — VARCHAR2(30) — 기본 키 — NOT NULL
  • pname — VARCHAR2(30)
  • pprice — INT
  • description — VARCHAR2(50)
  • pcompany — VARCHAR2(30)
  • recommendation — INT
  • review — INT
  • dcdata1 — VARCHAR2(30)
  • dcdata2 — VARCHAR2(30)
  • dcdata3 — INT
  • dcdata4 — INT
  • c3ID — VARCHAR2(30) — 외래 키 → category3.c3ID — NOT NULL

판매처 (Untitled)

  • pID — VARCHAR2(30) — 외래 키 → product.pID — NOT NULL
  • Field