최종예제
테이블 (5)
Untitled (FP_Member)
- Key (member_no) — NUMBER — 기본 키 — NOT NULL
- Field (member_id) — VARCHAR2(20)
- Field (member_pw) — VARCHAR2(100)
- Field (member_nick) — VARCHAR2(20)
- Field (member_gender) — VARCHAR2(1)
- Field (member_birth) — DATE
- Field (member_phone) — VARCHAR2(30)
- Field (member_email) — VARCHAR2(100)
- Field (member_joindate) — DATE
Untitled (FP_Board)
- Key (board_no) — NUMBER — 기본 키 — NOT NULL
- Key (member_no) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
- Field (board_title) — VARCHAR2(200)
- Field2 (board_content) — VARCHAR2(4000)
- Field (board_readcount) — NUMBER
- Field4 (board_writedate) — DATE
Untitled (FP_Hobby_Category)
- Key (hobby_category_no) — NUMBER — 기본 키 — NOT NULL
- Field (hobby_category_name) — VARCHAR2(100)
- Field2
- Field3
Untitled (FP_Comment)
- Key (comment_no) — NUMBER — 기본 키 — NOT NULL
- Key (board_no) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
- Key (member_no) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
- Field3 (commnet_content) — VARCHAR2(1000)
- Field4 (comment_writedate) — DATE
Untitled (djfa)
- Key — 기본 키 — NOT NULL
- Key2 — 기본 키 — NOT NULL