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