26.03.04

Tables (3)

comment_tbl

  • PK (comment_id) — INT — Primary key — NOT NULL — Auto Increment
  • PK (topic_id) — INT — Foreign key → topic_tbl.PK — NOT NULL — Auto Increment
  • FK (member_id2) — VARCHAR(50) — Foreign key → topic_tbl.FK — NOT NULL — 중복제거
  • PK (member_id) — VARCHAR(50) — Foreign key → member_tbl.PK — NOT NULL — 중복제거
  • 내용 (content) — VARCHAR(250) — NOT NULL

member_tbl

  • PK (member_id) — VARCHAR(50) — Primary key — NOT NULL — 중복제거
  • 패스워드 (password) — VARCHAR(50) — NOT NULL
  • 이름 (name) — VARCHAR(50)
  • 이메일 (email) — VARCHAR(100) — NOT NULL — 중복제거
  • 자기소개 (description) — VARCHAR(250)

topic_tbl

  • PK (topic_id) — INT — Primary key — NOT NULL — Auto Increment
  • FK (member_id) — VARCHAR(50) — Foreign key → member_tbl.PK — NOT NULL — 중복제거
  • 제목 (title) — VARCHAR(100)
  • 내용 (content) — TEXT