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