Chatspase DB設計

usersテーブル

Column	Type	Options
email	string	null: false
password	string	null: false
username	string	null: false

Association

• has_many :groups_users
• has_many :comments
• has_many groups through:groups_users

groupsテーブル

Column	Type	Options
name	string	null: false

Association

• has_many :groups_users
• has_many :comments
• has_many users through:groups_users

groups_usersテーブル

Column	Type	Options
user_id	integer	null: false, foreign_key: true
group_id	integer	null: false, foreign_key: true

Association

• belongs_to :group
• belongs_to :user

commentsテーブル

Column	Type	Options
text	string	null: false
image	string	null: false
user_id	integer	null: false, foreign_key: true
group_id	integer	null: false, foreign_key: true

Association

• belongs_to :user
• belongs_to :group