nonage 쇼핑몰
테이블 (8)
ADDRESS
- ZIP_NUM — VARCHAR2(7) — NOT NULL
- SIDO — VARCHAR2(30)
- GUGUN — VARCHAR2(30)
- DONG — VARCHAR2(100)
- ZIP_CODE — VARCHAR2(30) — NOT NULL
- BUNJI — VARCHAR2(30)
CART
- CSEQ — NUMBER(10,0)
- QUANTITY — NUMBER(5,0)
- RESULT — CHAR(1)
- INDATE — DATE
- PSEQ2 — NUMBER(5,0) — 외래 키 → PRODUCT.PSEQ
- ID2 — VARCHAR2(20) — 외래 키 → MEMBER.ID
MEMBER
- ID — VARCHAR2(20)
- PWD — VARCHAR2(20)
- NAME — VARCHAR2(40)
- EMAIL — VARCHAR2(40)
- ZIP_NUM — VARCHAR2(7)
- ADDRESS — VARCHAR2(100)
- PHONE — VARCHAR2(20)
- USEYN — CHAR(1)
- INDATE — DATE
ORDERS
- OSEQ — NUMBER(10,0)
- INDATE — DATE
- ID — VARCHAR2(20) — 외래 키 → MEMBER.ID
ORDER_DETAIL
- ODSEQ — NUMBER(10,0)
- QUANTITY — NUMBER(5,0)
- RESULT — CHAR(1)
- OSEQ2 — NUMBER(10,0) — 외래 키 → ORDERS.OSEQ
- PSEQ2 — NUMBER(5,0) — 외래 키 → PRODUCT.PSEQ
PRODUCT
- PSEQ — NUMBER(5,0)
- NAME — VARCHAR2(100)
- KIND — CHAR(1)
- PRICE1 — NUMBER(7,0)
- PRICE2 — NUMBER(7,0)
- PRICE3 — NUMBER(7,0)
- CONTENT — VARCHAR2(1000)
- IMAGE — VARCHAR2(50)
- USEYN — CHAR(1)
- BESTYN — CHAR(1)
- INDATE — DATE
QNA
- QSEQ — NUMBER(5,0)
- SUBJECT — VARCHAR2(300)
- CONTENT — VARCHAR2(1000)
- REPLY — VARCHAR2(1000)
- ID — VARCHAR2(20)
- REP — CHAR(1)
- INDATE — DATE
WORKER
- ID — VARCHAR2(20)
- PWD — VARCHAR2(20)
- NAME — VARCHAR2(40)
- PHONE — VARCHAR2(20)