게시판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
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)