test2

Tables (25)

Book_information_board

  • bib_no — int — Primary key — NOT NULL
  • bib_user_no — int — Foreign key → board.board_no — NOT NULL
  • bib_bok_no — int — Foreign key → book.book_no — NOT NULL

Market_board_buy

  • mbb_no — int — Primary key — NOT NULL
  • mbb_user_no — int — Foreign key → user.user_no — NOT NULL
  • mbb_board_no — int — Foreign key → board.board_no — NOT NULL
  • mbb_book_no — int — Foreign key → book.book_no — NOT NULL
  • mbb_buy_stat — int — NOT NULL

Market_buy_comment

  • mbc_no — int — Primary key — NOT NULL
  • mbc_user_no — int — Foreign key → user.user_no — NOT NULL
  • mbc_comment_no — int — Foreign key → comment.comment_no — NOT NULL
  • mbc_board_no — int — Foreign key → review_request_board.rrb_no — NOT NULL

board

  • board_no — int — Primary key — NOT NULL
  • board_title — varchar2(100) — NOT NULL
  • board_content — varchar2(1000) — NOT NULL
  • board_date — varchar2(14) — NOT NULL
  • board_cmt — int
  • board_rec — int

board_file

  • rb_no — int — Primary key — NOT NULL
  • board_no — int — Foreign key → file.board_no — NOT NULL
  • board_no2 — int — Foreign key → board.board_no — NOT NULL

book

  • book_no — int — Primary key — NOT NULL
  • book_title — varchar2(50) — NOT NULL
  • book_subtitle — varchar2(200)
  • book_author — varchar2(50)
  • book_translator — varchar2(50)
  • book_publisher — varchar2(30)
  • book_date — varchar2(8)
  • book_isbn — varchar2(12)
  • book_genre — int — NOT NULL
  • book_page — int

book_file

  • bf_no — int — Primary key — NOT NULL
  • bf_file_no — int — Foreign key → file.board_no — NOT NULL
  • bf_book_no — int — Foreign key → book.book_no — NOT NULL

comment

  • comment_no — int — Primary key — NOT NULL
  • comment_content — varchar2(50) — NOT NULL
  • comment_date — varchar2(14) — NOT NULL

file

  • board_no — int — Primary key — NOT NULL
  • file_origin_nam — varchar2(500) — NOT NULL
  • file_storedname — varchar2(500) — NOT NULL
  • file_size — varchar2(500)

free_board

  • fb_no — int — Primary key — NOT NULL
  • fb_user_no — int — Foreign key → user.user_no — NOT NULL
  • fb_board_no — int — Foreign key → board.board_no — NOT NULL

free_community

  • fc_review_comment_no — int — Primary key — NOT NULL
  • fc_user_no — int — Foreign key → user.user_no — NOT NULL
  • fc_comment_no — int — Foreign key → comment.comment_no — NOT NULL
  • fc_no — int — Foreign key → free_board.fb_no — NOT NULL

market_sell_board

  • msb_no — int — Primary key — NOT NULL
  • msb_user_no — int — Foreign key → user.user_no — NOT NULL
  • msb_board_no — int — Foreign key → board.board_no — NOT NULL
  • msb_book_no — int — Foreign key → book.book_no — NOT NULL
  • mbs_sell_stat — int — NOT NULL

market_sell_comment

  • msc_no — int — Primary key — NOT NULL
  • msc_user_no — int — Foreign key → user.user_no — NOT NULL
  • msc_comment_no — int — Foreign key → comment.comment_no — NOT NULL
  • msc_board_no — int — Foreign key → review_request_board.rrb_no — NOT NULL

message

  • message_no — int — Primary key — NOT NULL
  • message_title — varchar2(50) — NOT NULL
  • message_content — varchar2(200) — NOT NULL
  • message_date — varchar2(255) — NOT NULL

notice_board

  • nb_no — int — Primary key — NOT NULL
  • nb_board_no — int — Foreign key → board.board_no — NOT NULL
  • nb_user_no — int — Foreign key → user.user_no — NOT NULL

oneonone_question

  • ooq_no — int — Primary key — NOT NULL
  • ooq_user_no — int — Foreign key → user.user_no — NOT NULL
  • ooq_board_no — int — Foreign key → board.board_no — NOT NULL
  • ooq_book_no — int — Foreign key → book.book_no — NOT NULL

ononone_reply

  • oor_no — int — Primary key — NOT NULL
  • oor_user_no — int — Foreign key → user.user_no — NOT NULL
  • oor_board_no — int — Foreign key → board.board_no — NOT NULL
  • oor_book_no — int — Foreign key → book.book_no — NOT NULL
  • oor_ooq_no — int — Foreign key → oneonone_question.ooq_no — NOT NULL

question_board

  • qb_no — int — Primary key — NOT NULL
  • qb_user_no — int — Foreign key → user.user_no — NOT NULL
  • qb_type — int — NOT NULL
  • qb_title — varchar(100) — NOT NULL
  • qb_content — varchar2(1000) — NOT NULL
  • qb_reply — varchar2(1000) — NOT NULL

review_board

  • rb_no — int — Primary key — NOT NULL
  • rb_user_no — int — Foreign key → user.user_no — NOT NULL
  • rb_board_no — int — Foreign key → board.board_no — NOT NULL
  • rb_book_no — int — Foreign key → book.book_no — NOT NULL

review_comment

  • rc_no — int — Primary key — NOT NULL
  • rc_user_no — int — Foreign key → user.user_no — NOT NULL
  • rc_comment_no — int — Foreign key → comment.comment_no — NOT NULL
  • rc_board_no — int — Foreign key → review_board.rb_no — NOT NULL

review_request_board

  • rrb_no — int — Primary key — NOT NULL
  • rrb_user_no — int — Foreign key → user.user_no — NOT NULL
  • rrb_comment_no — int — Foreign key → board.board_no — NOT NULL
  • rrb_book_no — int — Foreign key → book.book_no — NOT NULL

review_request_comment

  • rrc_no — int — Primary key — NOT NULL
  • rrc_user_no — int — Foreign key → user.user_no — NOT NULL
  • rrc_comment_no — int — Foreign key → comment.comment_no — NOT NULL
  • rrc_board_no — int — Foreign key → review_request_board.rrb_no — NOT NULL

user

  • user_no — int — Primary key — NOT NULL
  • user_id — Varchar(15) — NOT NULL
  • user_pw — varchar2(12) — NOT NULL
  • user_name — varchar2(15) — NOT NULL
  • user_nick — varchar2(15) — NOT NULL
  • user_phone — varchar2(11) — NOT NULL
  • user_gender — int — NOT NULL
  • user_grade — Int
  • user_mail — varchar2(50)

user_message_receiver

  • umr_no — int — Primary key — NOT NULL
  • umr_message_no — int — Foreign key → message.message_no — NOT NULL
  • umr_receiver — int — Foreign key → user.user_no — NOT NULL
  • umr_sender — varchar2(15) — NOT NULL

user_message_sender

  • ums_no — int — Primary key — NOT NULL
  • ums_message_no — int — Foreign key → message.message_no — NOT NULL
  • ums_sender — int — Foreign key → user.user_no — NOT NULL
  • ums_receiver — varchar2(15) — NOT NULL