semi project
Tables (7)
BOARD
- BNUM — NUMBER(9) — Primary key — NOT NULL
- USERNAME — VARCHAR2(20) — NOT NULL
- USERPWD — VARCHAR2(30) — 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(30) — NOT NULL
- USERNAME — VARCHAR2(20) — NOT NULL
- BirthY — VARCHAR2(20)
- BirthM — VARCHAR2(20)
- BirthD — VARCHAR2(20)
- GENDER — VARCHAR2(10) — NOT NULL
- 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(30) — NOT NULL
- USEREMAIL — VARCHAR2(50)
- SUBJECT — VARCHAR2(50) — NOT NULL
- CONTENT — VARCHAR2(4000) — NOT NULL
- HITCOUNT — NUMBER(9)
- IMG — VARCHAR2(70)
- CREATED — DATE