2024게시판
테이블 (9)
board (Untitled4)
- board_no (Key) — number — 기본 키 — NOT NULL
- member_id (Key2) — varchar2(50) — 외래 키 → board_member.member_id — NOT NULL
- board_title (Field) — varchar2(150)
- board_write_date (Field2) — date
- board_content (Field3) — varchar2(5000)
- board_count (Field4) — number
board_comment (Untitled6)
- comment_no (Key) — number — 기본 키 — NOT NULL
- member_id (Key2) — varchar2(50) — 외래 키 → board_member.member_id — NOT NULL
- board_no (Key3) — number — 외래 키 → board.board_no — NOT NULL
- comment_write_date (Field) — date
- comment_content (Field2) — varchar2(5000)
board_file (Untitled5)
- file_no (Key) — number — 기본 키 — NOT NULL
- board_no (Key2) — number — 외래 키 → board.board_no — NOT NULL
- file_path (Field) — varchar2(300)
board_hate (Untitled2)
- board_no (Key) — number — 기본 키 — NOT NULL
- member_id (Key2) — varchar2(50) — 기본 키 — NOT NULL
board_like (Untitled)
- board_no (Key) — number — 기본 키 — NOT NULL
- member_id (Key2) — varchar2(50) — 기본 키 — NOT NULL
board_member (Untitled3)
- member_id (Key2) — varchar2(50) — 기본 키 — NOT NULL
- grade_no (Key) — number(2) — 외래 키 → board_member_grade.grade_no — NOT NULL
- member_passwd (Field4) — varchar2(50) — NOT NULL
- member_name (Field2) — varchar2(50)
- member_nick (Field3) — varchar2(50)
board_member_grade (Untitled7)
- grade_no (Key) — number(2) — 기본 키 — NOT NULL
- grade_name (Field) — varchar2(30)
comment_hate (Untitled9)
- comment_no (Key) — number — 기본 키 — NOT NULL
- member_id (Key2) — varchar2(50) — 기본 키 — NOT NULL
comment_like (Untitled8)
- comment_no (Key) — number — 기본 키 — NOT NULL
- member_id (Key2) — varchar2(50) — 기본 키 — NOT NULL