wish erd
Tables (14)
Member
- Key (member_no) — NUMBER — Primary key — NOT NULL
- Field (member_id) — VARCHAR2(40)
- Field (member_pw) — VARCHAR2(40)
- Field (member_name) — VARCHAR2(40)
- Field (member_phone) — VARCHAR2(40)
- Field (member_email) — VARCHAR2(40)
- Field (member_joindate) — DATE
- Field
Untitled (Interest_Category)
- Key (intercate_no) — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Key (wish_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (wide_cate_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
Untitled (MailAuth)
- Key (mailauth_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Field (mailauth_key) — VARCHAR2(200)
- Field (mailauth_complete) — VARCHAR2(40)
- Field (mailauth_date) — DATE
Untitled (Friends)
- Key (friends_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Field (friends_name)
- Field
Untitled (Customer_Service)
- Key (cs_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Field (cs_question) — VARCHAR2(40)
- Field (cs_answer) — VARCHAR2(40)
Untitled (Todo_)
- Key (todo_no) — Primary key — NOT NULL
- Key (wish_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (todo_title)
- Field (todo_time)
- Field (todo_list)
- Field
Untitled (Comment)
- Key — Primary key — NOT NULL
- Key (todo_no) — Foreign key → Untitled.Key — NOT NULL
- Key (wish_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
Untitled (WishList)
- Key (wish_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Field (wish_title) — VARCHAR2(40)
- Field (wish_dday) — DATE
- Field (wish_content) — VARCHAR2(40)
- Field (wish_readcount) — NUMBER
- Field (wish_writedate) — DATE
Untitled (Ranking)
- Key (rank_no) — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
Untitled (BoardImage)
- Key (image_no) — NUMBER — Primary key — NOT NULL
- Key (board_no) — NUMBER — Foreign key → Untitled2.Key — NOT NULL
- Field (image_link) — VARCHAR2(40)
- Field (image_filename) — VARCHAR2(40)
Untitled (Board_Like)
- Key (board_like_no) — NUMBER — Primary key — NOT NULL
- Key (board_no) — NUMBER — Foreign key → Untitled2.Key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Untitled2.Key — NOT NULL
- Field (likedate) — DATE
Untitled (Wide_Category)
- Key (wide_cate_no) — NUMBER — Primary key — NOT NULL
- Field (wcate_name)
Untitled (Narrow_Cate)
- Key (ncate_no) — NUMBER — Primary key — NOT NULL
- Field
Untitled2 (Board)
- Key (board_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Field (board_title) — VARCHAR2(40)
- Field (board_content) — VARCHAR2(40)
- Field (board_writedate) — DATE
- Field (board_readcount) — NUMBER