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)