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