도서대여project
테이블 (13)
ANSWER_TBL (Untitled14)
- ANSWER_ID (answer_id) — VARCHAR(100) — 기본 키 — NOT NULL
- QUESTION_ID (question_id) — VARCHAR(100) — 외래 키 → QUESTION_TBL.QUESTION_ID — NOT NULL
- USER_ID (user_id) — VARCHAR(100) — 외래 키 → USER_TBL.USER_ID — NOT NULL
- ANSWER_CONTENT (answer_content) — VARCHAR(200)
- ANSWER_TIME (answer_time) — TIMESTAMP
APPROVE_TBL (Untitled3)
- APPROVE_ID (approve_id) — VARCHAR(100) — 기본 키 — NOT NULL
- USER_ID (user_id) — VARCHAR(100) — 외래 키 → USER_TBL.USER_ID — NOT NULL
- REQBOOK_ID (reqbook_id) — VARCHAR(100) — 외래 키 → REQBOOK_TBL.REQBOOK_ID — NOT NULL
- APPROVE_CONTENT (approve_content) — VARCHAR(200)
- APPROVE_TIME (approve_time) — TIMESTAMP
- APPROVE_STATE (approve_state) — VARCHAR(10)
BOARD_TBL (Untitled7)
- BOARD_ID (board_id) — INT — 기본 키 — NOT NULL
- USER_ID (user_id) — VARCHAR(100) — 외래 키 → USER_TBL.USER_ID — NOT NULL
- BOARD_TITLE (board_title) — VARCHAR(255)
- BOARD_CONTENT (board_content) — VARCHAR(255)
- BOARD_TIME (board_time) — TIMESTAMP
- BOARD_OPEN (board_open) — INT
- BOARD_LIKE (board_like) — INT
BOOK_REVIEW_TBL (Untitled11)
- BOOK_REVIEW_ID (book_review_id) — VARCHAR(100) — 기본 키 — NOT NULL
- EBOOK_ID (ebook_id) — VARCHAR(100) — 외래 키 → EBOOK_TBL.EBOOK_ID — NOT NULL
- USER_ID (user_id) — VARCHAR(100) — 외래 키 → USER_TBL.USER_ID — NOT NULL
- BOOK_REVIEW_CONTENT (book_review_content) — VARCAHR(200)
- BOOK_REVIEW_GOOD (book_review_good) — INT(3)
- BOOK_REVIEW_TIME (book_review_time) — TIMESTAMP
COMMENT_TBL (Untitled12)
- COMMENT_ID (comment_id) — VARCHAR(100) — 기본 키 — NOT NULL
- BOARD_ID (board_id) — INT — 외래 키 → BOARD_TBL.BOARD_ID — NOT NULL
- USER_ID (user_id) — VARCHAR(100) — 외래 키 → USER_TBL.USER_ID — NOT NULL
- COMMENT_CONTENT (comment_content) — VARCHAR(255)
- COMMENT_TIME (comment_time) — TIMESTAMP
EBOOK_TBL (Untitled5)
- EBOOK_ID (ebook_id) — VARCHAR(100) — 기본 키 — NOT NULL
- EBOOK_NAME (ebook_name) — VARCHAR(100)
- EBOOK_AUTHOR (ebook_author) — VARCHAR(100)
- EBOOK_GOOD (ebook_good) — INT(5)
- EBOOK_CATEGORY (ebook_category) — VARCHAR(100)
- EBOOK_CONTENT (ebook_content) — LONGTEXT
- EBOOK_IMAGE (ebook_image) — VARCHAR(500)
- EBOOK_PUBLISH (ebook_publish) — VARCHAR(100)
EBOOK_WISHLIST (Untitled6)
- WISH_ID (wish_id) — INT — 기본 키 — NOT NULL
- USER_ID (user_id) — VARCHAR(100) — 외래 키 → USER_TBL.USER_ID — NOT NULL
- EBOOK_ID (ebook_id) — VARCHAR(100) — 외래 키 → EBOOK_TBL.EBOOK_ID — NOT NULL
FAQ_TBL (Untitled15)
- FAQ_ID (faq_id) — INT — 기본 키 — NOT NULL
- FAQ_CATEGORY (faq_category) — VARCHAR(50)
- FAQ_QUESTION (faq_question) — VARCHAR(100)
- FAQ_ANSWER (faq_answer) — VARCHAR(500)
NOTIFY_TBL (Untitled8)
- NOTIFY_ID (notify_id) — VARCHAR(100) — 기본 키 — NOT NULL
- USER_ID (user_id) — VARCHAR(100) — 외래 키 → USER_TBL.USER_ID — NOT NULL
- NOTIFY_TITLE (notify_title) — VARCHAR(100)
- NOTIFY_CONTENT (notify_content) — VARCHAR(200)
- NOTIFY_TIME (notify_time) — TIMESTAMP
QUESTION_TBL (Untitled13)
- QUESTION_ID (question_id) — VARCHAR(100) — 기본 키 — NOT NULL
- USER_ID (user_id) — VARCHAR(100) — 외래 키 → USER_TBL.USER_ID — NOT NULL
- QUESTION_TITLE (question_title) — VARCHAR(100)
- QUESTION_CONTENT (question_content) — VARCHAR(200)
- QUESTION_REQ_EMAIL (question_req_email) — VARCHAR(100)
- QUESTION_TIME (question_time) — TIMESTAMP
- QUESTION_LOCK (question_lock) — VARCHAR(10)
RENTAL_TBL (Untitled2)
- RENTAL_ID (rental_id) — VARCHAR(100) — 기본 키 — NOT NULL
- EBOOK_ID (ebook_id) — VARCHAR(100) — 외래 키 → EBOOK_TBL.EBOOK_ID — NOT NULL
- USER_ID (user_id) — VARCHAR(100) — 외래 키 → USER_TBL.USER_ID — NOT NULL
- RETURN_STATUS (return_status) — VARCHAR(20)
- LOAN_TIME (loan_time) — TIMESTAMP
- RETURN_TIME (return_time) — TIMESTAMP
- EXTEND_COUNT (extend_count) — INT
- RETURN_COUNT (return_count) — INT
REQBOOK_TBL (Untitled4)
- REQBOOK_ID (reqbook_id) — VARCHAR(100) — 기본 키 — NOT NULL
- USER_ID (user_id) — VARCHAR(100) — 외래 키 → USER_TBL.USER_ID — NOT NULL
- REQBOOK_TITLE (reqbook_title) — VARCHAR(100)
- REQBOOK_CONTENT (reqbook_content) — VARCHAR(200)
- REQBOOK_TIME (reqbook_time) — TIMESTAMP
USER_TBL (Untitled)
- USER_ID (user_id) — VARCHAR(100) — 기본 키 — NOT NULL
- USER_PW (user_pw) — VARCHAR(255)
- USER_NICKNAME (user_nickname) — VARCHAR(100)
- USER_EMAIL (user_email) — VARCHAR(100)
- USER_IMAGE (user_image) — LONGTEXT