notitle

Tables (3)

よせがき (yosegaki)

  • id — int — Primary key — NOT NULL
  • content — varchar
  • created_at — timestamp
  • updated_at — timestamp
  • member_id — int — Foreign key → メンバー.id — NOT NULL

グループ (group)

  • id — int — Primary key — NOT NULL
  • name — varchar
  • password — varchar
  • created_at — timestamp
  • updaetd_at (updated_at) — timestamp

メンバー (member)

  • id — int — Primary key — NOT NULL
  • name — varchar
  • created_at — timestamp
  • updated_at — timestamp
  • room_id — int — Foreign key → グループ.id — NOT NULL