게시판만들기
테이블 (9)
FILE (Untitled4)
- FILE_NO (Key) — NUMBER — 기본 키 — NOT NULL
- board_no (Key2) — NUMBER — 외래 키 → board.board_no — NOT NULL
- FILE_URL (Field) — VARCHAR2(1000)
board (Untitled)
- 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 (Untitled3)
- comment_no (Key) — NUMBER — 기본 키 — NOT NULL
- ID (Key2) — VARCHAR2(100) — 외래 키 → board_member.member_id — NOT NULL
- board_no (Key3) — NUMBER — 외래 키 → board.board_no — NOT NULL
- comment_write_date (Field) — DATE
- comment_content (Field2) — VARCHAR2(2000)
board_hate (CopyOfUntitled62)
- member_id (Key2) — VARCHAR2(50) — 기본 키 — NOT NULL
- board_no (Key4) — NUMBER — 기본 키 — NOT NULL
board_like (Untitled6)
- member_id (Key2) — VARCHAR2(50) — 기본 키 — NOT NULL
- board_no (Key4) — NUMBER — 기본 키 — NOT NULL
board_member (Untitled2)
- member_id (Key) — VARCHAR2(50) — 기본 키 — NOT NULL
- GRADE_NO (Key2) — NUMBER — 외래 키 → board_member_grade.GRADE_NO — NOT NULL
- member_passwd (Field) — VARCHAR2(50) — NOT NULL
- member_name (Field2) — VARCHAR2(50)
- member_nick (Field3) — VARCHAR2(50)
board_member_grade (Untitled5)
- GRADE_NO (Key) — NUMBER — 기본 키 — NOT NULL
- GRADE_NAME (Field) — VARCHAR2(50)
comment_hate (CopyOfCopyOfUntitled63)
- member_id (Key2) — VARCHAR2(50) — 기본 키 — NOT NULL
- comment_no (Key4) — NUMBER — 기본 키 — NOT NULL
comment_like (CopyOfUntitled63)
- member_id (Key2) — VARCHAR2(50) — 기본 키 — NOT NULL
- comment_no (Key4) — NUMBER — 기본 키 — NOT NULL