board

Tables (8)

board

  • 글번호 (board_no) — number — Primary key — NOT NULL
  • 아이디 (member_id) — varchar2(30) — Foreign key → board_member.아이디 — NOT NULL
  • 글제목 (board_content) — varchar2(3000)
  • 현재시간 (board_write_time) — date
  • 조회수 (board_count) — number
  • Field (board_title) — varchar2(300)

board_comment

  • Key (board_comment_no) — number — Primary key — NOT NULL
  • 아이디 (member_id) — varchar2(30) — Foreign key → board_member.아이디 — NOT NULL
  • 글번호 (board_no) — number — Foreign key → board.글번호 — NOT NULL
  • Field (board_comment_content) — varchar2(1000)
  • Field (board_comment_time) — date

board_comment_hate (Untitled4)

  • 아이디 (member_id) — varchar2(30) — Foreign key → board_member.아이디 — NOT NULL
  • Key (board_comment_no) — number — Foreign key → board_comment.Key — NOT NULL

board_comment_like (Untitled3)

  • 아이디 (member_id) — varchar2(30) — Foreign key → board.아이디 — NOT NULL
  • Key (board_comment_no) — number — Foreign key → board_comment.Key — NOT NULL

board_file (Untitled5)

  • Key (board_file_no) — char(10) — Primary key — NOT NULL
  • 글번호 (board_no) — number — Foreign key → board.글번호 — NOT NULL
  • (board_file_url) — varchar2(500)

board_hate (Untitled2)

  • 아이디 (member_id) — varchar2(30) — Foreign key → board_member.아이디 — NOT NULL
  • 글번호 (board_no) — number — Foreign key → board.글번호 — NOT NULL

board_like (Untitled)

  • 아이디 (member_id) — varchar2(30) — Foreign key → board_member.아이디 — NOT NULL
  • 글번호 (board_no) — number — Foreign key → board.글번호 — NOT NULL

board_member (bpard_member)

  • 아이디 (member_id) — varchar2(30) — Primary key — NOT NULL
  • 비밀번호 (member_passwd) — char(128)
  • 이름 (member_name) — varchar2(30)
  • 닉네임 (member_nick) — varchar2(30)