ㅁㄴㅇ
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)