test
Tables (7)
BOOK
- 글 번호 (BO_NO) — NUMBER — Primary key — NOT NULL
- BO_TITLE — VARCHAR2(255) — NOT NULL
- BO_WRITER — NUMBER — NOT NULL
- BO_PHONE — VARCHAR2(20) — NOT NULL
- BO_CONTENTS — CLOB — NOT NULL
- BO_PWD — VARCHAR2(100) — NOT NULL
- BO_STATUS — CHAR(1) — NOT NULL
- BO_DEL — CHAR(1) — NOT NULL
CATEGORY
- 카테고리NO (CATE_NO) — NUMBER — Primary key — NOT NULL
- CATEGORY_NAME — VARCHAR2(10) — NOT NULL
FAQ
- 글 번호 (FAQ_NO) — NUMBER — Primary key — NOT NULL
- FAQ_QU — VARCHAR2(255) — NOT NULL
- FAQ_RE — VARCHAR2(500) — NOT NULL
- FAQ_DEL — CHAR(1) — NOT NULL
NEWS
- 글번호 (NE_NO) — NUMBER — Primary key — NOT NULL
- NE_TITLE — VARCHAR2(255) — NOT NULL
- NE_WRITER — NUMBER — NOT NULL
- NE_REG — DATE
- NE_CONTENTS — CLOB — NOT NULL
- NE_DEL — CHAR(1) — NOT NULL
QT_USER
- 회원번호 (USER_NO) — NUMBER — Primary key — NOT NULL
- USER_NAME — VARCHAR2(100) — NOT NULL
- USER_PWD — VARCHAR2(100) — NOT NULL
- USER_PHONE — VARCHAR2(20) — NOT NULL
- IS_ADMIN — CHAR(1) — NOT NULL
QUESTION
- 글 번호 (QU_NO) — NUMBER — Primary key — NOT NULL
- QU_TITLE — VARCHAR2(255) — NOT NULL
- QU_WRITER — NUMBER — NOT NULL
- QU_PHONE — VARCHAR2(20) — NOT NULL
- QU_CONTENTS — CLOB — NOT NULL
- QU_PWD — VARCHAR2(100) — NOT NULL
- QU_STATUS — CHAR(1) — NOT NULL
- QU_DEL — CHAR(1) — NOT NULL
REVIEW
- 글 번호 (RE_NO) — NUMBER — Primary key — NOT NULL
- RE_TITLE — VARCHAR2(255) — NOT NULL
- RE_WRITER — NUMBER — NOT NULL
- RE_REG — DATE
- RE_CONTENTS — CLOB — NOT NULL
- RE_DEL — CHAR(1) — NOT NULL