최종예제
테이블 (9)
FP_Board
- board_no — NUMBER — 기본 키 — NOT NULL
- member_no — NUMBER — 외래 키 → Untitled.member_no — NOT NULL
- board_title — VARCHAR2(200)
- board_content — VARCHAR2(4000)
- board_readcount — NUMBER
- board_writedate — DATE
Untitled (FP_Member)
- member_no — NUMBER — 기본 키 — NOT NULL
- member_id — VARCHAR2(20)
- member_pw — VARCHAR2(100)
- member_nick — VARCHAR2(20)
- member_gender — VARCHAR2(1)
- member_birth — DATE
- member_phone — VARCHAR2(30)
- Field (member_email) — VARCHAR2(100)
- Field (member_joindate) — DATE
Untitled (FP_Hobby_Category server)
- Key (hobby_category_no) — NUMBER — 기본 키 — NOT NULL
- Field (hobby_category_name) — VARCHAR2(100)
Untitled (FP_MemberHobby)
- Key (memberhobby_no) — NUMBER — 기본 키 — NOT NULL
- member_no — NUMBER — 외래 키 → Untitled.member_no — NOT NULL
- Key (hobby_category_no) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
Untitled (FP_BoardImage)
- Key (image_no) — NUMBER — 기본 키 — NOT NULL
- board_no — NUMBER — 외래 키 → FP_Board.board_no — NOT NULL
- Field (image_url) — VARCHAR2(300)
- Field (image_original_filename) — VARCHAR2(400)
Untitled (FP_Comment)
- Key (comment_no) — NUMBER — 기본 키 — NOT NULL
- member_no — NUMBER — 외래 키 → Untitled.member_no — NOT NULL
- board_no — NUMBER — 외래 키 → FP_Board.board_no — NOT NULL
- Field (comment_content) — VARCHAR2(1000)
- Field (comment_writedate) — DATE
Untitled (FP_MailAuth)
- Key (mailauth_no) — NUMBER — 기본 키 — NOT NULL
- member_no — NUMBER — 외래 키 → Untitled.member_no — NOT NULL
- Field (mailauth_key) — VARCHAR2(400)
- Field (mailauth_complete) — VARCHAR2(1)
- Field (mailauth_date) — DATE
Untitled2 (FP_BoardLike)
- Key (like_no) — NUMBER — 기본 키 — NOT NULL
- member_no — NUMBER — 외래 키 → Untitled.member_no — NOT NULL
- board_no — NUMBER — 외래 키 → FP_Board.board_no — NOT NULL
- Field (like_date) — DATE