게시판ERD

테이블 (8)

board

  • board_no — number — 기본 키 — NOT NULL
  • member_id — varchar2(30) — 외래 키 → member.member_id — NOT NULL
  • board_title — varchar2(300)
  • board_content — varchar2(3000)
  • board_write_time (post_viewcount) — date
  • board_count — number

board_comment

  • board_comment_no — number — 기본 키 — NOT NULL
  • board_no — number — 외래 키 → board.board_no — NOT NULL
  • member_id — varchar2(30) — 외래 키 → member.member_id — NOT NULL
  • board_comment_content — varchar2(1000)
  • board_comment_time — date

board_hate

  • member_id — varchar2(30) — 외래 키 → member.member_id — NOT NULL
  • board_no — number — 외래 키 → board.board_no — NOT NULL

board_like

  • member_id — varchar2(30) — 외래 키 → member.member_id — NOT NULL
  • board_no — number — 외래 키 → board.board_no — NOT NULL

borad_file (board_file)

    comment_hate

    • member_id — varchar2(30) — 외래 키 → member.member_id — NOT NULL
    • board_comment_no — number — 외래 키 → board_comment.board_comment_no — NOT NULL

    comment_like

    • member_id — varchar2(30) — 외래 키 → member.member_id — NOT NULL
    • board_comment_no — number — 외래 키 → board_comment.board_comment_no — NOT NULL
    • board_no — number — 외래 키 → board_comment.board_no — NOT NULL

    member

    • member_id — varchar2(30) — 기본 키 — NOT NULL
    • member_passwd — char(128)
    • member_name — varchar2(30)
    • member_nick — varchar2(30)