{"action":"created","issue":{"url":"https://api.github.com/repos/ViBii/mitemiru/issues/3","labels_url":"https://api.github.com/repos/ViBii/mitemiru/issues/3/labels{/name}","comments_url":"https://api.github.com/repos/ViBii/mitemiru/issues/3/comments","events_url":"https://api.github.com/repos/ViBii/mitemiru/issues/3/events","html_url":"https://github.com/ViBii/mitemiru/issues/3","id":100996331,"number":3,"title":"US01-F01-SP03: システム上のデータベーススキーマを決定する 3.5h","user":{"login":"yaginuuu","id":3440182,"avatar_url":"https://avatars.githubusercontent.com/u/3440182?v=3","gravatar_id":"","url":"https://api.github.com/users/yaginuuu","html_url":"https://github.com/yaginuuu","followers_url":"https://api.github.com/users/yaginuuu/followers","following_url":"https://api.github.com/users/yaginuuu/following{/other_user}","gists_url":"https://api.github.com/users/yaginuuu/gists{/gist_id}","starred_url":"https://api.github.com/users/yaginuuu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yaginuuu/subscriptions","organizations_url":"https://api.github.com/users/yaginuuu/orgs","repos_url":"https://api.github.com/users/yaginuuu/repos","events_url":"https://api.github.com/users/yaginuuu/events{/privacy}","received_events_url":"https://api.github.com/users/yaginuuu/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/ViBii/mitemiru/labels/SUPPORT","name":"SUPPORT","color":"5319e7"}],"state":"open","locked":false,"assignee":{"login":"yaginuuu","id":3440182,"avatar_url":"https://avatars.githubusercontent.com/u/3440182?v=3","gravatar_id":"","url":"https://api.github.com/users/yaginuuu","html_url":"https://github.com/yaginuuu","followers_url":"https://api.github.com/users/yaginuuu/followers","following_url":"https://api.github.com/users/yaginuuu/following{/other_user}","gists_url":"https://api.github.com/users/yaginuuu/gists{/gist_id}","starred_url":"https://api.github.com/users/yaginuuu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yaginuuu/subscriptions","organizations_url":"https://api.github.com/users/yaginuuu/orgs","repos_url":"https://api.github.com/users/yaginuuu/repos","events_url":"https://api.github.com/users/yaginuuu/events{/privacy}","received_events_url":"https://api.github.com/users/yaginuuu/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/ViBii/mitemiru/milestones/1","html_url":"https://github.com/ViBii/mitemiru/milestones/%E7%AC%AC1%E3%82%B9%E3%83%97%E3%83%AA%E3%83%B3%E3%83%88","labels_url":"https://api.github.com/repos/ViBii/mitemiru/milestones/1/labels","id":1255048,"number":1,"title":"第1スプリント","description":"15/08/13 - 15/08/31","creator":{"login":"yaginuuu","id":3440182,"avatar_url":"https://avatars.githubusercontent.com/u/3440182?v=3","gravatar_id":"","url":"https://api.github.com/users/yaginuuu","html_url":"https://github.com/yaginuuu","followers_url":"https://api.github.com/users/yaginuuu/followers","following_url":"https://api.github.com/users/yaginuuu/following{/other_user}","gists_url":"https://api.github.com/users/yaginuuu/gists{/gist_id}","starred_url":"https://api.github.com/users/yaginuuu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yaginuuu/subscriptions","organizations_url":"https://api.github.com/users/yaginuuu/orgs","repos_url":"https://api.github.com/users/yaginuuu/repos","events_url":"https://api.github.com/users/yaginuuu/events{/privacy}","received_events_url":"https://api.github.com/users/yaginuuu/received_events","type":"User","site_admin":false},"open_issues":39,"closed_issues":17,"state":"open","created_at":"2015-08-14T11:46:39Z","updated_at":"2015-08-24T08:28:09Z","due_on":"2015-08-30T15:00:00Z","closed_at":null},"comments":7,"created_at":"2015-08-14T11:52:39Z","updated_at":"2015-08-25T06:38:02Z","closed_at":null,"body":"## 大木が作成したER図を基にシステム上のスキーマを考えてみました\r\n- 論理モデル\r\n![image](https://cloud.githubusercontent.com/assets/3440182/9459659/e902557c-4b38-11e5-9b69-53242a0721dd.png)\r\n\r\n- 物理モデル\r\n![image](https://cloud.githubusercontent.com/assets/3440182/9459669/fa1ae644-4b38-11e5-88c0-94e6ec13ae6a.png)\r\n\r\n- 変更点, 考慮点\r\n- Active Recordを考慮したスキーマに変更しました\r\n    - 主キーはidで統一した\r\n        - 開発者のアドレスで絞り込みをしてから, idで関連テーブルを取得する\r\n        - 秘密鍵情報テーブルも同様\r\n- Railsでの物理モデルにしました\r\n    - テーブル名はスネークケースで記述し, 複数形にする\r\n    - created_at(テーブル作成日時), updated_at(テーブル更新日時)は自動生成される"},"comment":{"url":"https://api.github.com/repos/ViBii/mitemiru/issues/comments/134499193","html_url":"https://github.com/ViBii/mitemiru/issues/3#issuecomment-134499193","issue_url":"https://api.github.com/repos/ViBii/mitemiru/issues/3","id":134499193,"user":{"login":"ryoki1118","id":6702920,"avatar_url":"https://avatars.githubusercontent.com/u/6702920?v=3","gravatar_id":"","url":"https://api.github.com/users/ryoki1118","html_url":"https://github.com/ryoki1118","followers_url":"https://api.github.com/users/ryoki1118/followers","following_url":"https://api.github.com/users/ryoki1118/following{/other_user}","gists_url":"https://api.github.com/users/ryoki1118/gists{/gist_id}","starred_url":"https://api.github.com/users/ryoki1118/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ryoki1118/subscriptions","organizations_url":"https://api.github.com/users/ryoki1118/orgs","repos_url":"https://api.github.com/users/ryoki1118/repos","events_url":"https://api.github.com/users/ryoki1118/events{/privacy}","received_events_url":"https://api.github.com/users/ryoki1118/received_events","type":"User","site_admin":false},"created_at":"2015-08-25T06:38:02Z","updated_at":"2015-08-25T06:38:02Z","body":"申し訳ない、論理モデル修正しました。\r\nテーブルの作成日時と更新日時も入れてあります。\r\n![mitemiru_db1-1](https://cloud.githubusercontent.com/assets/6702920/9460248/3570b22c-4b3f-11e5-9718-3ad8b2797440.jpg)\r\n\r\nここに保存してあるから使ってもよいよ\r\n\"ViBi\\00各種ドキュメント\\95図\\ER図\""}}