최종예제
테이블 (11)
Untitled (FP_Member)
- Key (member_no) — number — 기본 키 — NOT NULL
- Field (member_id) — varchar2(20)
- Field2 (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(400)
- Field3 (board_readcount) — number
- Field4 (board_writedate) — date
Untitled (FP_Hobby_Category)
- Key (hobby_category_no) — number — 기본 키 — NOT NULL
- Field (habby_category_name) — varchar2(100)
Untitled (FP_Member_Hobby)
- Key (memberhobby_no) — number — 기본 키 — NOT NULL
- Key (member_no) — number — 외래 키 → Untitled.Key — NOT NULL
- Key (hobby_category_no) — number — 외래 키 → Untitled.Key — NOT NULL
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
- Field (comment_content) — varchar2(1000)
- Field (comment_writedate) — date
Untitled (FP_Boardimage)
- Key (image_no) — number — 기본 키 — NOT NULL
- Key (board_no) — number — 외래 키 → Untitled.Key — NOT NULL
- Field (image_url) — varchar2(300)
- Field (image_original_fileName) — varchar2(400)
Untitled (FP_MailAuth)
- Key (mailauth_no) — number — 기본 키 — NOT NULL
- Key (member_no) — number — 외래 키 → Untitled.Key — NOT NULL
- Field (mailauth_key) — varchar2(400)
- Field (mailauth_complete) — varchar2(1)
- Field (mailauth_date) — date
Untitled (FP_BoardLike)
- Key (like_no) — number — 기본 키 — NOT NULL
- Key (member_no) — number — 외래 키 → Untitled.Key — NOT NULL
- Key (board_no) — number — 외래 키 → Untitled.Key — NOT NULL
- Field (like_date) — date
Untitled (FP_Commentripple)
- Key (ripple_no) — number — 기본 키 — NOT NULL
- Key (comment_no) — number — 외래 키 → Untitled.Key — NOT NULL
- Key (board_no) — number — 외래 키 → Untitled.Key — NOT NULL
- Key (member_no) — number — 외래 키 → Untitled.Key — NOT NULL
- Field (ripple_content) — varchar2(1000)
- Field (ripple_writedate) — date
Untitled (KT_Member)
- Key (member_no) — number — 기본 키 — NOT NULL
- Field (member_id) — varchar2(100)
- Field (member_pw) — varchar2(100)
- Field (member_nick) — varchar2(100)
- Field (member_gender) — varchar2(1)
- Field (member_birth) — date
- Field (member_phone) — varchar2(100)
- Field (member_email) — varchar2(100)
- Field (member_joindate) — DATE
Untitled (KT_Board)
- Key (board_no) — number — 기본 키 — NOT NULL
- Key (member_no) — number — 외래 키 → Untitled.Key — NOT NULL
- Field (board_title) — varchar2(100)
- Field (board_content) — varchar2(100)
- Field (board_writedate) — date
- Field (board_views) — number