1

Tables (5)

category

  • cID — VARCHAR2(30) — Primary key — NOT NULL
  • cname — VARCHAR2(30)

category2

  • c2ID — VARCHAR2(30) — Primary key — NOT NULL
  • c2name — VARCHAR2(30)
  • cID — VARCHAR2(30) — NOT NULL

category3

  • c3ID — VARCHAR2(30) — Primary key — NOT NULL
  • c3name — VARCHAR2(30)
  • c2ID — VARCHAR2(30) — NOT NULL

detailed

  • c3ID — VARCHAR2(30) — Foreign key → category3.c3ID — NOT NULL
  • dcname1 — VARCHAR2(20)
  • dcname2 — VARCHAR2(20)
  • dcname3 — VARCHAR2(20)
  • dcname4 — VARCHAR2(20)

product

  • pID — VARCHAR2(30) — Primary key — 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) — NOT NULL