최종예제 게시판
테이블 (7)
FP_Member
- Key (member_no) — NUMBER — 기본 키 — NOT NULL
- Field (meber_id) — VARCHAR(40)
- Field (member_pw) — VARCHAR(200)
- Field2 (member_nick) — VARCHAR(40)
- Field (member_gender) — VARCHAR(2)
- Field (member_birth) — DATE
- Field (member_phone) — VARCHAR(20)
- Field (member_email) — VARCHAR(100)
- Field (member_joindate) — DATE
Untitled (FP_Board)
- Field (board_no) — NUMBER — 기본 키
- Key (member_no) — NUMBER — 외래 키 → FP_Member.Key — NOT NULL
- Field (board_title) — VARCHAR(400)
- Field (board_content) — VARCHAR(4000)
- Field (board_readcount) — NUMBER
- Field (board_writedate) — DATE
Untitled (FP_Hobby)
- Key (hoddy_no) — NUMBER — 기본 키 — NOT NULL
- Key (member_no) — NUMBER — 외래 키 → FP_Member.Key — NOT NULL
- Key (hobby_category_no) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
Untitled (FP_Hobby_Category)
- Key (hobby_category_no) — NUMBER — 기본 키 — NOT NULL
- Field (hobby_category_name) — VARCHAR2(40)
Untitled (FP_Board_Image)
- Key (image_no) — NUMBER — 기본 키 — NOT NULL
- Field (board_no) — NUMBER — 외래 키 → Untitled.Field
- Field (image_link) — VARCHAR2(100)
- Field (image_original_filename) — VARCHAR2(100)
Untitled (FP_MailAuth)
- Key (mailauth_no) — NUMBER — 기본 키 — NOT NULL
- Key (member_no) — NUMBER — 외래 키 → FP_Member.Key — NOT NULL
- Field (mailauth_key) — VARCHAR(200)
- Field (mailauth_complete) — VARCHAR2(4)
- Field (mailauth_date) — DATE
Untitled (FP_Board_Like)
- Key (like_no) — NUMBER — 기본 키 — NOT NULL
- Key (member_no) — NUMBER — 외래 키 → FP_Member.Key — NOT NULL
- Field (board_no) — NUMBER — 외래 키 → Untitled.Field
- Field (like_date) — DATE