도란도란

테이블 (6)

Category

  • category_id — INT(11) — 기본 키 — NOT NULL
  • content — TEXT — NOT NULL

Comment

  • comment_id — INT(11) — 기본 키 — NOT NULL
  • member_id — VARCHAR(30) — 외래 키 → Member.member_id — NOT NULL
  • group_id — INT(11) — 외래 키 → Group.group_id — NOT NULL
  • content — TEXT
  • write_time — DATETIME

Group

  • group_id — INT(11) — 기본 키 — NOT NULL
  • category_id — INT(11) — 외래 키 → Category.category_id — NOT NULL
  • name — VARCHAR(30)
  • content — VARCHAR(30)
  • deadline_type — INT(11)
  • deadline_member — INT(11)
  • deadline_time — DATETIME
  • status — BOOLEAN
  • create_time — DATETIME
  • image — VARCHAR(100)

Group_Member

  • member_id — VARCHAR(30) — 외래 키 → Member.member_id — NOT NULL
  • group_id — INT(11) — 외래 키 → Group.group_id — NOT NULL
  • is_founder — BOOLEAN
  • member_status — INT(11)
  • member_count — INT(11)

Member

  • member_id — VARCHAR(30) — 기본 키 — NOT NULL
  • password — VARCHAR(30)
  • name — VARCHAR(30)
  • position — VARCHAR(30)
  • grade — INT(11)
  • gender — INT(11)
  • phone_number — VARCHAR(30)
  • image — VARCHAR(100)

Untitled (Request_Member)

  • group_id — INT(11) — 외래 키 → Group.group_id — NOT NULL
  • Field2 (current_member)
  • Field (wait_member)