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