압김최 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