게시판

테이블 (9)

board

  • board_no — Number — 기본 키 — NOT NULL
  • member_id — varchar2(50) — 외래 키 → board_member.member_id — NOT NULL
  • grade_no — Number(2) — 외래 키 → board_member.grade_no — NOT NULL
  • board_title — varchar2(150) — NOT NULL
  • board_write_date — date — NOT NULL
  • board_content — varchar2(5000) — NOT NULL
  • board_count — Number

board_comment

  • commentNo — Number — 기본 키 — NOT NULL
  • board_no — Number — 외래 키 → board.board_no — NOT NULL
  • member_id — varchar2(50) — 외래 키 → board_member.member_id — NOT NULL
  • comment_write_date — date
  • comment_content — varchar2(5000)

board_file

  • fileNo — Number — 기본 키 — NOT NULL
  • board_no — Number — 외래 키 → board.board_no — NOT NULL
  • file_path — varchar2(300)

board_hate

  • board_no — number — 기본 키 — NOT NULL
  • member_id — varchar2(50) — 기본 키 — NOT NULL

board_like

  • board_no — number — 기본 키 — NOT NULL
  • member_id — varchar2(50) — 기본 키 — NOT NULL

board_member

  • member_id — varchar2(50) — 기본 키 — NOT NULL
  • grade_no — Number(2) — 외래 키 → board_member_grade.grade_no — NOT NULL
  • member_passwd — varchar2(50) — NOT NULL
  • member_name — varchar2(50) — NOT NULL
  • member_nick — varchar2(50) — NOT NULL

board_member_grade

  • grade_no — Number(2) — 기본 키 — NOT NULL
  • grade_name — varchar2(30) — NOT NULL

comment_hate

  • comment_no — number — 기본 키 — NOT NULL
  • member_id — varchar2(50) — 기본 키 — NOT NULL

comment_like

  • comment_no — number — 기본 키 — NOT NULL
  • member_id — varchar2(50) — 기본 키 — NOT NULL