FinalProject
Tables (7)
FP_Member
- Field (member_no) — number — Primary key — NOT NULL
- This is Member ID (member_id) — varchar2(20) — NOT NULL
- Field (member_pw) — varchar2(160) — NOT NULL
- Field2 (member_nick) — varchar2(20) — NOT NULL
- Field (member_gender) — varchar2(4) — NOT NULL
- Field (member_birth) — date — NOT NULL
- Field (member_phone) — varchar2(20)
- Field (member_email) — NOT NULL
- Field (member_joindate) — date — NOT NULL
Untitled (FP_Hobby_category)
- Key (hobby_category_no) — number — Primary key — NOT NULL
- Field (hobby_category_name) — varchar2(20) — NOT NULL
Untitled (FP_Hobby)
- Key (hobby_no) — number — Primary key — NOT NULL
- Field (member_no) — number — Foreign key → FP_Member.Field — NOT NULL
- Key (hobby_category_no) — number — Foreign key → Untitled.Key — NOT NULL
Untitled (FP_Comment)
- Key (comment_no) — number — Primary key — NOT NULL
- Key (board_no) — number — Foreign key → Untitled2.Key — NOT NULL
- Field (member_no) — number — Foreign key → Untitled2.Field — NOT NULL
- Field (comment_content) — varchar2(500) — NOT NULL
- Field (comment_writedate) — date — NOT NULL
Untitled (FP_Recommend)
- Key (reco_no) — number — Primary key — NOT NULL
- Key (board_no) — number — Foreign key → Untitled2.Key — NOT NULL
- Field (member_no) — number — Foreign key → FP_Member.Field — NOT NULL
- Field (reco_date) — date — NOT NULL
Untitled (FP_MailAuth)
- Key (mailauth_no) — number — Primary key — NOT NULL
- Field (member_no) — number — Foreign key → FP_Member.Field — NOT NULL
- Field (mailauth_key) — varchar2(200) — NOT NULL
- Field (mailauth_complete) — varchar2(4) — NOT NULL
- Field (mailauth_date) — date
Untitled2 (FP_Board)
- Key (board_no) — number — Primary key — NOT NULL
- Field (member_no) — number — Foreign key → FP_Member.Field — NOT NULL
- Field (board_title) — varchar2(400) — NOT NULL
- Field (board_content) — varchar2(4000) — NOT NULL
- Field (board_readcount) — number — NOT NULL
- Field (board_writedate) — date — NOT NULL