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