도서대여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