semi project - 2022-08-02 08:21:07

Tables (7)

BOARD

  • BNUM — NUMBER(9) — Primary key — NOT NULL
  • USERNAME — VARCHAR2(20) — NOT NULL
  • USERPWD — VARCHAR2(10) — NOT NULL
  • USEREMAIL — VARCHAR2(50) — NOT NULL
  • SUBJECT — VARCHAR2(50) — NOT NULL
  • CONTENT — VARCHAR2(4000) — NOT NULL
  • HITCOUNT — NUMBER(9) — NOT NULL
  • IMG — VARCHAR2(70) — NOT NULL
  • CREATED — DATE — NOT NULL

CART

  • CNUM — NUMBER — Primary key — NOT NULL
  • USERID — VARCHAR2(20)
  • PRODUCTNUM — NUMBER(10)
  • QUANTITY — NUMBER(4)

MEMBER

  • USERID — VARCHAR2(20) — Primary key — NOT NULL
  • USERPWD — VARCHAR2(10) — NOT NULL
  • USERNAME — VARCHAR2(20) — NOT NULL
  • USERBIRTH — VARCHAR2(20)
  • POSTCODE — VARCHAR2(30)
  • ROADADDR — VARCHAR(50)
  • DETAILADDR — VARCHAR2(50)
  • USERTEL — VARCHAR2(20)
  • USEREMAIL — VARCHAR2(30)

ORDER

  • Field (ONUM) — NUMBER
  • USERID — VARCHAR2(20)
  • ORDERTOTAL — NUMBER(5)
  • PRICETOTAL — NUMBER(10)
  • USERADDR2 — VARCHAR2(50)
  • ORDERMETHOD — VARCHAR2(20)
  • ORDERDATE — DATE
  • ORDERMEMO — VARCHAR2(60)

PRODUCT

  • PRODUCTNUM — number(10) — Primary key — NOT NULL
  • PRODUCTNAME — varchar2(30)
  • IMG — VARCHAR2(50)
  • CATEGORY — VARCHAR2(20)
  • PRICE — NUMBER(10)

QNA

  • QNUM — NUMBER(10) — Primary key — NOT NULL
  • USERID — VARCHAR2(20) — NOT NULL
  • SUBJECT — VARCHAR2(30)
  • CONTENT — VARCHAR(500)
  • REPLY — VARCHAR2(500)
  • CREATED — DATE

REVIEW

  • RENUM — NUMBER(9) — Primary key — NOT NULL
  • PRODUCTNUM — NUMBER(10)
  • USERID — VARCHAR2(20) — NOT NULL
  • USERNAME — VARCHAR2(20) — NOT NULL
  • USERPWD — VARCHAR2(10) — NOT NULL
  • USEREMAIL — VARCHAR2(50)
  • SUBJECT — VARCHAR2(50) — NOT NULL
  • CONTENT — VARCHAR2(4000) — NOT NULL
  • HITCOUNT — NUMBER(9)
  • IMG — VARCHAR2(70)
  • CREATED — DATE