FreeTalk
Tables (3)
Comment
- C_no (comment_no) — INT(11) — Primary key — NOT NULL
- C_co (comment_contnet) — VARCHAR(255)
- N_no (notice_no) — INT(11) — Foreign key → Notice.N_no — NOT NULL
- M_no (member_no) — INT(11) — Foreign key → Member.M_no — NOT NULL
Member
- M_no (member_no) — INT(11) — Primary key — NOT NULL
- M_Id (member_id) — VARCHAR(255)
- M_Pw (member_pw) — VARCHAR(255)
- M_Ph (member_phone) — VARCHAR(20)
- M_Em (member_email) — VARCHAR(100)
- M_Ni (member_nick) — VARCHAR(50)
Notice
- N_no (notice_no) — INT(11) — Primary key — NOT NULL
- N_Ti (noitce_title) — VARCHAR(255)
- N_Co (notice_content) — VARCHAR(255)
- M_no (member_no) — INT(11) — Foreign key → Member.M_no — NOT NULL