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