ㅁㄴㅇ

Tables (10)

BOOK

  • BOOK_NO — NUMBER — Primary key — NOT NULL
  • BOOK_NAME — VARCHAR2(20)
  • BOOK_CONTENT — VARCHR2(200)
  • CATEGORY_NO — NUMBER — NOT NULL
  • CATEGORY_NO (CATEGORY_NO2) — NUMBER — Foreign key → BOOK_CATEGORY.CATEGORY_NO — NOT NULL

BOOK_CATEGORY

  • CATEGORY_NO — NUMBER — Primary key — NOT NULL
  • CATEGORY_NAME — VARCHAR2(20)

CATEGORY

  • CATEGORY_NO — NUMBER — Primary key — NOT NULL
  • CATEGORY_NAME — VARCHAR2(20)

LECTURE

  • LECTURE_NO — NUMBER — Primary key — NOT NULL
  • USER_NO — NUMBER — Foreign key → USER.사용자번호 — NOT NULL
  • LECTURE_NAME — VARCHAR2(20) — NOT NULL
  • LECTURE_CONTENT — VARCHAR2(200) — NOT NULL
  • CATEGORY_NO — NUMBER — NOT NULL
  • LEVEL_NO — NUMBER — NOT NULL
  • BOOK_NO — NUMBER — NOT NULL
  • CATEGORY_NO (CATEGORY_NO2) — NUMBER — Foreign key → CATEGORY.CATEGORY_NO — NOT NULL
  • LEVEL_NO (LEVEL_NO2) — NUMBER — Foreign key → LEVEL.LEVEL_NO — NOT NULL
  • BOOK_NO (BOOK_NO2) — NUMBER — Foreign key → BOOK.BOOK_NO — NOT NULL

LEVEL

  • LEVEL_NO — NUMBER — Primary key — NOT NULL
  • LEVEL_NAME — VARCHAR2(20)
  • LEVEL_DIVI — NUMBER

MYHOME

  • USER_NO — NUMBER — Foreign key → USER.사용자번호 — NOT NULL
  • LECTURE_NO — NUMBER — Foreign key → LECTURE.LECTURE_NO — NOT NULL
  • LECTURE_START — VARCHAR2(20)
  • LECTURE_FINISH — VARCHAR2(20)

REPLY

  • REPLY_CONTENT — VARCHAR2(50)
  • REPLY_DATE — DATE
  • REVIEW_NO — NUMBER — NOT NULL
  • USER_NO — NUMBER — NOT NULL
  • REVIEW_NO (REVIEW_NO2) — NUMBER — Foreign key → REVIEW.REVIEW_NO — NOT NULL
  • USER_NO (USER_NO2) — NUMBER — Foreign key → USER.사용자번호 — NOT NULL

REVIEW

  • REVIEW_NO — NUMBER — Primary key — NOT NULL
  • CONTENT — VARCHAR2(200) — NOT NULL
  • RATED — VARCHAR2(200) — NOT NULL
  • REVIEW_DATE — DATE
  • USER_NO — NUMBER — NOT NULL
  • LECTURE_NO — NUMBER — NOT NULL
  • USER_NO (USER_NO2) — NUMBER — Foreign key → MYHOME.USER_NO — NOT NULL
  • LECTURE_NO (LECTURE_NO2) — NUMBER — Foreign key → MYHOME.LECTURE_NO — NOT NULL

USER

  • 사용자번호 (USER_NO) — NUMBER — Primary key — NOT NULL
  • 사용자아이디 (USER_ID) — VARCHAR2(30) — NOT NULL
  • 사용자비밀번호 (USER_PASS) — VARCHAR2(20)
  • 사용자주소 (USER_ADDRESS) — VARCHAR2(50)
  • 핸드폰번호 (USER_HP) — NUMBER
  • 생년월일 (USER_BIR) — DATE
  • USER_NAME — VARCHAR2(30)
  • JOIN_DATE — DATE — NOT NULL
  • DIVI_NO — NUMBER — NOT NULL
  • DIVI_NO (DIVI_NO2) — NUMBER — Foreign key → USER_DIVI.사용자구분번호 — NOT NULL

USER_DIVI

  • 사용자구분번호 (DIVI_NO) — NUMBER — Primary key — NOT NULL
  • 사용자구분명 (DIVI_NAME) — VARCHAR2(20)