Project

Tables (4)

BOARD (공지사항)

  • NUM — NUMBER — Primary key — NOT NULL
  • TITLE — VARCHAR2(100)
  • CONTENTS — VARCHAR2(4000)
  • WRITER — VARCHAR2(100)

CARTTABLE (장바구니)

  • CARTNUM — NUMBER — Primary key — NOT NULL
  • ID — VARCHAR2(100)
  • ITEMNAME — VARCHAR2(500)
  • PRICE — NUMBER
  • AMOUNT — NUMBER

MemberJoin (로그인)

  • ID — varchar2(100) — Primary key — NOT NULL
  • PW (Pw) — varchar2(100)
  • NAME — VARCHAR2(100)
  • PHONE — VARCHAR2(100)
  • EMAIL — VARCHAR2(100)
  • ADDRESS — VARCHAR2(500)
  • BIRTH — DATE

SHOPQNA (QNA)

  • NUM — NUMBER — Primary key — NOT NULL
  • TITLE — VARCHAR2(100)
  • CONTENTS — VARCHAR2(4000)
  • WRITER — VARCHAR2(100)
  • REGDATE — DATE
  • Field