payload: {"action":"created","comment":{"url":"https://api.github.com/repos/sggkmrsk/chat-space/pulls/comments/344439930","pull_request_review_id":314553730,"id":344439930,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDM0NDQzOTkzMA==","diff_hunk":"@@ -1,24 +1,50 @@\n # README\n \n-This README would normally document whatever steps are necessary to get the\n-application up and running.\n-\n-Things you may want to cover:\n-\n-* Ruby version\n-\n-* System dependencies\n-\n-* Configuration\n-\n-* Database creation\n-\n-* Database initialization\n-\n-* How to run the test suite\n-\n-* Services (job queues, cache servers, search engines, etc.)\n-\n-* Deployment instructions\n-\n-* ...\n+* Database design\n+## usersテーブル\n+  |Column|Type|Options|\n+  |------|----|-------|\n+  |user_id|integer|null: false, unique: true|\n+  |user_name|varchar|null: false|\n+  |email_address|varchar|null: false,unique: true|\n+  |password|varchar|null: false|\n+\n+  ### Association\n+  - has_many :groups_users\n+    - has_many :group, though: :groups_users\n+  - has_many :massages\n+\n+## groupsテーブル\n+  |Column|Type|Options|\n+  |------|----|-------|\n+  |group_id|integer|null: false, unique: true|\n+  |group_name|varchar|null: false|\n+\n+  ### Association\n+  - has_many :groups_users\n+    - has_many :users, though: :groups_users\n+  - has_many :massages\n+\n+## groups_usersテーブル\n+  |Column|Type|Options|\n+  |------|----|-------|\n+  |user_id|integer|null: false, foreign_key: true|\n+  |group_id|integer|null: false, foreign_key: true|\n+\n+  ### Association\n+  - belongs_to :group\n+  - belongs_to :user\n+\n+## massagesテーブル\n+  |Column|Type|Options|\n+  |------|----|-------|\n+  |massage_id|integer|null: false, unique: true|","path":"README.md","position":null,"original_position":63,"commit_id":"d98b6f1ad83856876a31ad0351c2348f32d63a14","original_commit_id":"0906d02a3c05c2b918d01db1a6e52d2de8b4e9b4","user":{"login":"sggkmrsk","id":57355040,"node_id":"MDQ6VXNlcjU3MzU1MDQw","avatar_url":"https://avatars1.githubusercontent.com/u/57355040?v=4","gravatar_id":"","url":"https://api.github.com/users/sggkmrsk","html_url":"https://github.com/sggkmrsk","followers_url":"https://api.github.com/users/sggkmrsk/followers","following_url":"https://api.github.com/users/sggkmrsk/following{/other_user}","gists_url":"https://api.github.com/users/sggkmrsk/gists{/gist_id}","starred_url":"https://api.github.com/users/sggkmrsk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sggkmrsk/subscriptions","organizations_url":"https://api.github.com/users/sggkmrsk/orgs","repos_url":"https://api.github.com/users/sggkmrsk/repos","events_url":"https://api.github.com/users/sggkmrsk/events{/privacy}","received_events_url":"https://api.github.com/users/sggkmrsk/received_events","type":"User","site_admin":false},"body":"ありがとうございます。修正しました。","created_at":"2019-11-09T11:23:44Z","updated_at":"2019-11-09T11:23:44Z","html_url":"https://github.com/sggkmrsk/chat-space/pull/2#discussion_r344439930","pull_request_url":"https://api.github.com/repos/sggkmrsk/chat-space/pulls/2","author_association":"OWNER","_links":{"self":{"href":"https://api.github.com/repos/sggkmrsk/chat-space/pulls/comments/344439930"},"html":{"href":"https://github.com/sggkmrsk/chat-space/pull/2#discussion_r344439930"},"pull_request":{"href":"https://api.github.com/repos/sggkmrsk/chat-space/pulls/2"}},"in_reply_to_id":344438745},"pull_request":{"url":"https://api.github.com/repos/sggkmrsk/chat-space/pulls/2","id":338979972,"node_id":"MDExOlB1bGxSZXF1ZXN0MzM4OTc5OTcy","html_url":"https://github.com/sggkmrsk/chat-space/pull/2","diff_url":"https://github.com/sggkmrsk/chat-space/pull/2.diff","patch_url":"https://github.com/sggkmrsk/chat-space/pull/2.patch","issue_url":"https://api.github.com/repos/sggkmrsk/chat-space/issues/2","number":2,"state":"open","locked":false,"title":"[WIP]ReadMeのDB設計について #2","user":{"login":"sggkmrsk","id":57355040,"node_id":"MDQ6VXNlcjU3MzU1MDQw","avatar_url":"https://avatars1.githubusercontent.com/u/57355040?v=4","gravatar_id":"","url":"https://api.github.com/users/sggkmrsk","html_url":"https://github.com/sggkmrsk","followers_url":"https://api.github.com/users/sggkmrsk/followers","following_url":"https://api.github.com/users/sggkmrsk/following{/other_user}","gists_url":"https://api.github.com/users/sggkmrsk/gists{/gist_id}","starred_url":"https://api.github.com/users/sggkmrsk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sggkmrsk/subscriptions","organizations_url":"https://api.github.com/users/sggkmrsk/orgs","repos_url":"https://api.github.com/users/sggkmrsk/repos","events_url":"https://api.github.com/users/sggkmrsk/events{/privacy}","received_events_url":"https://api.github.com/users/sggkmrsk/received_events","type":"User","site_admin":false},"body":"#what\r\n・line 45のカラムの名称、型、属性。\r\n・line 51は削除が正しいか。\r\n\r\n#why\r\nimagesテーブル削除に伴い以下の変更を実施した。\r\n45行目を編集\r\n・image_idではなく、imageとした場合、型はvarcharでよいと思ったが問題ないか。\r\n・Optionはなしで良いか。\r\n\r\n51行目を削除\r\n・テーブルがなくなったため、associationは必要なくなったと考えたため削除したが問題ないか。","created_at":"2019-11-09T10:32:48Z","updated_at":"2019-11-09T11:23:44Z","closed_at":null,"merged_at":null,"merge_commit_sha":"4710efa528f8239926eb208e988e087db3cc8892","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/sggkmrsk/chat-space/pulls/2/commits","review_comments_url":"https://api.github.com/repos/sggkmrsk/chat-space/pulls/2/comments","review_comment_url":"https://api.github.com/repos/sggkmrsk/chat-space/pulls/comments{/number}","comments_url":"https://api.github.com/repos/sggkmrsk/chat-space/issues/2/comments","statuses_url":"https://api.github.com/repos/sggkmrsk/chat-space/statuses/d98b6f1ad83856876a31ad0351c2348f32d63a14","head":{"label":"sggkmrsk:wirte_Readme","ref":"wirte_Readme","sha":"d98b6f1ad83856876a31ad0351c2348f32d63a14","user":{"login":"sggkmrsk","id":57355040,"node_id":"MDQ6VXNlcjU3MzU1MDQw","avatar_url":"https://avatars1.githubusercontent.com/u/57355040?v=4","gravatar_id":"","url":"https://api.github.com/users/sggkmrsk","html_url":"https://github.com/sggkmrsk","followers_url":"https://api.github.com/users/sggkmrsk/followers","following_url":"https://api.github.com/users/sggkmrsk/following{/other_user}","gists_url":"https://api.github.com/users/sggkmrsk/gists{/gist_id}","starred_url":"https://api.github.com/users/sggkmrsk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sggkmrsk/subscriptions","organizations_url":"https://api.github.com/users/sggkmrsk/orgs","repos_url":"https://api.github.com/users/sggkmrsk/repos","events_url":"https://api.github.com/users/sggkmrsk/events{/privacy}","received_events_url":"https://api.github.com/users/sggkmrsk/received_events","type":"User","site_admin":false},"repo":{"id":220607784,"node_id":"MDEwOlJlcG9zaXRvcnkyMjA2MDc3ODQ=","name":"chat-space","full_name":"sggkmrsk/chat-space","private":false,"owner":{"login":"sggkmrsk","id":57355040,"node_id":"MDQ6VXNlcjU3MzU1MDQw","avatar_url":"https://avatars1.githubusercontent.com/u/57355040?v=4","gravatar_id":"","url":"https://api.github.com/users/sggkmrsk","html_url":"https://github.com/sggkmrsk","followers_url":"https://api.github.com/users/sggkmrsk/followers","following_url":"https://api.github.com/users/sggkmrsk/following{/other_user}","gists_url":"https://api.github.com/users/sggkmrsk/gists{/gist_id}","starred_url":"https://api.github.com/users/sggkmrsk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sggkmrsk/subscriptions","organizations_url":"https://api.github.com/users/sggkmrsk/orgs","repos_url":"https://api.github.com/users/sggkmrsk/repos","events_url":"https://api.github.com/users/sggkmrsk/events{/privacy}","received_events_url":"https://api.github.com/users/sggkmrsk/received_events","type":"User","site_admin":false},"html_url":"https://github.com/sggkmrsk/chat-space","description":null,"fork":false,"url":"https://api.github.com/repos/sggkmrsk/chat-space","forks_url":"https://api.github.com/repos/sggkmrsk/chat-space/forks","keys_url":"https://api.github.com/repos/sggkmrsk/chat-space/keys{/key_id}","collaborators_url":"https://api.github.com/repos/sggkmrsk/chat-space/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/sggkmrsk/chat-space/teams","hooks_url":"https://api.github.com/repos/sggkmrsk/chat-space/hooks","issue_events_url":"https://api.github.com/repos/sggkmrsk/chat-space/issues/events{/number}","events_url":"https://api.github.com/repos/sggkmrsk/chat-space/events","assignees_url":"https://api.github.com/repos/sggkmrsk/chat-space/assignees{/user}","branches_url":"https://api.github.com/repos/sggkmrsk/chat-space/branches{/branch}","tags_url":"https://api.github.com/repos/sggkmrsk/chat-space/tags","blobs_url":"https://api.github.com/repos/sggkmrsk/chat-space/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/sggkmrsk/chat-space/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/sggkmrsk/chat-space/git/refs{/sha}","trees_url":"https://api.github.com/repos/sggkmrsk/chat-space/git/trees{/sha}","statuses_url":"https://api.github.com/repos/sggkmrsk/chat-space/statuses/{sha}","languages_url":"https://api.github.com/repos/sggkmrsk/chat-space/languages","stargazers_url":"https://api.github.com/repos/sggkmrsk/chat-space/stargazers","contributors_url":"https://api.github.com/repos/sggkmrsk/chat-space/contributors","subscribers_url":"https://api.github.com/repos/sggkmrsk/chat-space/subscribers","subscription_url":"https://api.github.com/repos/sggkmrsk/chat-space/subscription","commits_url":"https://api.github.com/repos/sggkmrsk/chat-space/commits{/sha}","git_commits_url":"https://api.github.com/repos/sggkmrsk/chat-space/git/commits{/sha}","comments_url":"https://api.github.com/repos/sggkmrsk/chat-space/comments{/number}","issue_comment_url":"https://api.github.com/repos/sggkmrsk/chat-space/issues/comments{/number}","contents_url":"https://api.github.com/repos/sggkmrsk/chat-space/contents/{+path}","compare_url":"https://api.github.com/repos/sggkmrsk/chat-space/compare/{base}...{head}","merges_url":"https://api.github.com/repos/sggkmrsk/chat-space/merges","archive_url":"https://api.github.com/repos/sggkmrsk/chat-space/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/sggkmrsk/chat-space/downloads","issues_url":"https://api.github.com/repos/sggkmrsk/chat-space/issues{/number}","pulls_url":"https://api.github.com/repos/sggkmrsk/chat-space/pulls{/number}","milestones_url":"https://api.github.com/repos/sggkmrsk/chat-space/milestones{/number}","notifications_url":"https://api.github.com/repos/sggkmrsk/chat-space/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/sggkmrsk/chat-space/labels{/name}","releases_url":"https://api.github.com/repos/sggkmrsk/chat-space/releases{/id}","deployments_url":"https://api.github.com/repos/sggkmrsk/chat-space/deployments","created_at":"2019-11-09T07:33:48Z","updated_at":"2019-11-09T07:33:56Z","pushed_at":"2019-11-09T11:23:27Z","git_url":"git://github.com/sggkmrsk/chat-space.git","ssh_url":"git@github.com:sggkmrsk/chat-space.git","clone_url":"https://github.com/sggkmrsk/chat-space.git","svn_url":"https://github.com/sggkmrsk/chat-space","homepage":null,"size":22,"stargazers_count":0,"watchers_count":0,"language":"Ruby","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"disabled":false,"open_issues_count":1,"license":null,"forks":0,"open_issues":1,"watchers":0,"default_branch":"master"}},"base":{"label":"sggkmrsk:master","ref":"master","sha":"0a9faff6fa65fb6591b04b04fc3c07e9871a8281","user":{"login":"sggkmrsk","id":57355040,"node_id":"MDQ6VXNlcjU3MzU1MDQw","avatar_url":"https://avatars1.githubusercontent.com/u/57355040?v=4","gravatar_id":"","url":"https://api.github.com/users/sggkmrsk","html_url":"https://github.com/sggkmrsk","followers_url":"https://api.github.com/users/sggkmrsk/followers","following_url":"https://api.github.com/users/sggkmrsk/following{/other_user}","gists_url":"https://api.github.com/users/sggkmrsk/gists{/gist_id}","starred_url":"https://api.github.com/users/sggkmrsk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sggkmrsk/subscriptions","organizations_url":"https://api.github.com/users/sggkmrsk/orgs","repos_url":"https://api.github.com/users/sggkmrsk/repos","events_url":"https://api.github.com/users/sggkmrsk/events{/privacy}","received_events_url":"https://api.github.com/users/sggkmrsk/received_events","type":"User","site_admin":false},"repo":{"id":220607784,"node_id":"MDEwOlJlcG9zaXRvcnkyMjA2MDc3ODQ=","name":"chat-space","full_name":"sggkmrsk/chat-space","private":false,"owner":{"login":"sggkmrsk","id":57355040,"node_id":"MDQ6VXNlcjU3MzU1MDQw","avatar_url":"https://avatars1.githubusercontent.com/u/57355040?v=4","gravatar_id":"","url":"https://api.github.com/users/sggkmrsk","html_url":"https://github.com/sggkmrsk","followers_url":"https://api.github.com/users/sggkmrsk/followers","following_url":"https://api.github.com/users/sggkmrsk/following{/other_user}","gists_url":"https://api.github.com/users/sggkmrsk/gists{/gist_id}","starred_url":"https://api.github.com/users/sggkmrsk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sggkmrsk/subscriptions","organizations_url":"https://api.github.com/users/sggkmrsk/orgs","repos_url":"https://api.github.com/users/sggkmrsk/repos","events_url":"https://api.github.com/users/sggkmrsk/events{/privacy}","received_events_url":"https://api.github.com/users/sggkmrsk/received_events","type":"User","site_admin":false},"html_url":"https://github.com/sggkmrsk/chat-space","description":null,"fork":false,"url":"https://api.github.com/repos/sggkmrsk/chat-space","forks_url":"https://api.github.com/repos/sggkmrsk/chat-space/forks","keys_url":"https://api.github.com/repos/sggkmrsk/chat-space/keys{/key_id}","collaborators_url":"https://api.github.com/repos/sggkmrsk/chat-space/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/sggkmrsk/chat-space/teams","hooks_url":"https://api.github.com/repos/sggkmrsk/chat-space/hooks","issue_events_url":"https://api.github.com/repos/sggkmrsk/chat-space/issues/events{/number}","events_url":"https://api.github.com/repos/sggkmrsk/chat-space/events","assignees_url":"https://api.github.com/repos/sggkmrsk/chat-space/assignees{/user}","branches_url":"https://api.github.com/repos/sggkmrsk/chat-space/branches{/branch}","tags_url":"https://api.github.com/repos/sggkmrsk/chat-space/tags","blobs_url":"https://api.github.com/repos/sggkmrsk/chat-space/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/sggkmrsk/chat-space/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/sggkmrsk/chat-space/git/refs{/sha}","trees_url":"https://api.github.com/repos/sggkmrsk/chat-space/git/trees{/sha}","statuses_url":"https://api.github.com/repos/sggkmrsk/chat-space/statuses/{sha}","languages_url":"https://api.github.com/repos/sggkmrsk/chat-space/languages","stargazers_url":"https://api.github.com/repos/sggkmrsk/chat-space/stargazers","contributors_url":"https://api.github.com/repos/sggkmrsk/chat-space/contributors","subscribers_url":"https://api.github.com/repos/sggkmrsk/chat-space/subscribers","subscription_url":"https://api.github.com/repos/sggkmrsk/chat-space/subscription","commits_url":"https://api.github.com/repos/sggkmrsk/chat-space/commits{/sha}","git_commits_url":"https://api.github.com/repos/sggkmrsk/chat-space/git/commits{/sha}","comments_url":"https://api.github.com/repos/sggkmrsk/chat-space/comments{/number}","issue_comment_url":"https://api.github.com/repos/sggkmrsk/chat-space/issues/comments{/number}","contents_url":"https://api.github.com/repos/sggkmrsk/chat-space/contents/{+path}","compare_url":"https://api.github.com/repos/sggkmrsk/chat-space/compare/{base}...{head}","merges_url":"https://api.github.com/repos/sggkmrsk/chat-space/merges","archive_url":"https://api.github.com/repos/sggkmrsk/chat-space/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/sggkmrsk/chat-space/downloads","issues_url":"https://api.github.com/repos/sggkmrsk/chat-space/issues{/number}","pulls_url":"https://api.github.com/repos/sggkmrsk/chat-space/pulls{/number}","milestones_url":"https://api.github.com/repos/sggkmrsk/chat-space/milestones{/number}","notifications_url":"https://api.github.com/repos/sggkmrsk/chat-space/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/sggkmrsk/chat-space/labels{/name}","releases_url":"https://api.github.com/repos/sggkmrsk/chat-space/releases{/id}","deployments_url":"https://api.github.com/repos/sggkmrsk/chat-space/deployments","created_at":"2019-11-09T07:33:48Z","updated_at":"2019-11-09T07:33:56Z","pushed_at":"2019-11-09T11:23:27Z","git_url":"git://github.com/sggkmrsk/chat-space.git","ssh_url":"git@github.com:sggkmrsk/chat-space.git","clone_url":"https://github.com/sggkmrsk/chat-space.git","svn_url":"https://github.com/sggkmrsk/chat-space","homepage":null,"size":22,"stargazers_count":0,"watchers_count":0,"language":"Ruby","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"disabled":false,"open_issues_count":1,"license":null,"forks":0,"open_issues":1,"watchers":0,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/sggkmrsk/chat-space/pulls/2"},"html":{"href":"https://github.com/sggkmrsk/chat-space/pull/2"},"issue":{"href":"https://api.github.com/repos/sggkmrsk/chat-space/issues/2"},"comments":{"href":"https://api.github.com/repos/sggkmrsk/chat-space/issues/2/comments"},"review_comments":{"href":"https://api.github.com/repos/sggkmrsk/chat-space/pulls/2/comments"},"review_comment":{"href":"https://api.github.com/repos/sggkmrsk/chat-space/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/sggkmrsk/chat-space/pulls/2/commits"},"statuses":{"href":"https://api.github.com/repos/sggkmrsk/chat-space/statuses/d98b6f1ad83856876a31ad0351c2348f32d63a14"}},"author_association":"OWNER"}}
other: {"actor":{"display_login":"sggkmrsk"}}