dream

Tables (4)

BOARDS

  • BNO — NUMBER — Primary key — NOT NULL
  • TITLE — VARCHAR2 — NOT NULL
  • CONTENT — VARCHAR2 — NOT NULL
  • REG_DATE — DATE
  • VIEW_CNT — NUMBER
  • REPLY_CNT — NUMBER
  • USERID (USERID2) — VARCHAR2 — Foreign key → USERS.USERID — NOT NULL

CARTS

  • CID — NUMBER — Primary key — NOT NULL
  • CCOUNT — NUMBER — NOT NULL
  • USERID — VARCHAR2 — Foreign key → USERS.USERID — NOT NULL
  • PID (PID2) — NUMBER — Foreign key → PRODUCTS.PID — NOT NULL

PRODUCTS

  • PID — NUMBER — Primary key — NOT NULL
  • PNAME — VARCHAR2 — NOT NULL
  • PPRICE — NUMBER — NOT NULL
  • PIMAGE1 — VARCHAR2 — NOT NULL
  • PIMAGE2 — VARCHAR2
  • PIMAGE3 — VARCHAR2
  • PRDATE — DATE — NOT NULL
  • PDETAIL — VARCHAR2 — NOT NULL

USERS

  • USERID — VARCHAR2 — Primary key — NOT NULL
  • PWD — VARCHAR2 — NOT NULL
  • EMAIL — VARCHAR2 — NOT NULL