{"action":"created","issue":{"url":"https://api.github.com/repos/zdogma/nyaran/issues/1","labels_url":"https://api.github.com/repos/zdogma/nyaran/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/zdogma/nyaran/issues/1/comments","events_url":"https://api.github.com/repos/zdogma/nyaran/issues/1/events","html_url":"https://github.com/zdogma/nyaran/issues/1","id":91278190,"number":1,"title":"スキーマ提案","user":{"login":"t-hrhs","id":4661349,"avatar_url":"https://avatars.githubusercontent.com/u/4661349?v=3","gravatar_id":"","url":"https://api.github.com/users/t-hrhs","html_url":"https://github.com/t-hrhs","followers_url":"https://api.github.com/users/t-hrhs/followers","following_url":"https://api.github.com/users/t-hrhs/following{/other_user}","gists_url":"https://api.github.com/users/t-hrhs/gists{/gist_id}","starred_url":"https://api.github.com/users/t-hrhs/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/t-hrhs/subscriptions","organizations_url":"https://api.github.com/users/t-hrhs/orgs","repos_url":"https://api.github.com/users/t-hrhs/repos","events_url":"https://api.github.com/users/t-hrhs/events{/privacy}","received_events_url":"https://api.github.com/users/t-hrhs/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":8,"created_at":"2015-06-26T15:22:49Z","updated_at":"2015-06-27T14:12:10Z","closed_at":null,"body":"table1 : ranking_map\r\nランキングのidと実際のランキングテーブルを紐づけるテーブル\r\n```\r\nid (int) #各種ランキングの固有id\r\nname (varchar) # ランキングの名前\r\nmedia_type (int) # メディアの種類(サイトごと)\r\nranking_table (varchar) # ランキングのテーブル名(もしくはランキングテーブルのModel)\r\n```\r\ntable2 : nico_hoge_ranking\r\nnicoのhogeジャンルのランキングを管理するテーブル\r\n(サービスやジャンルを増やすときはこのtableが増殖する)\r\n```\r\nrank (int) # 順位\r\nscore (int) # 評価値\r\ndistinct_str (varchar) # 各種動画を識別するuniqueなstring(apiを叩くときに利用)\r\ncreated_at (int) レコードが作成されたタイミング(daily rankingの識別に利用)\r\n```"},"comment":{"url":"https://api.github.com/repos/zdogma/nyaran/issues/comments/116060428","html_url":"https://github.com/zdogma/nyaran/issues/1#issuecomment-116060428","issue_url":"https://api.github.com/repos/zdogma/nyaran/issues/1","id":116060428,"user":{"login":"zdogma","id":1973683,"avatar_url":"https://avatars.githubusercontent.com/u/1973683?v=3","gravatar_id":"","url":"https://api.github.com/users/zdogma","html_url":"https://github.com/zdogma","followers_url":"https://api.github.com/users/zdogma/followers","following_url":"https://api.github.com/users/zdogma/following{/other_user}","gists_url":"https://api.github.com/users/zdogma/gists{/gist_id}","starred_url":"https://api.github.com/users/zdogma/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zdogma/subscriptions","organizations_url":"https://api.github.com/users/zdogma/orgs","repos_url":"https://api.github.com/users/zdogma/repos","events_url":"https://api.github.com/users/zdogma/events{/privacy}","received_events_url":"https://api.github.com/users/zdogma/received_events","type":"User","site_admin":false},"created_at":"2015-06-27T14:12:10Z","updated_at":"2015-06-27T14:12:10Z","body":"※ id, timestamp2種(created_at, updated_at) はすべてに付く。\r\n```\r\nrankings\r\n・id (int)\r\n・name (string)\r\n・is_public (boolean)\r\n```\r\n```\r\nranking_contents\r\n・id (int)\r\n・ranking_id (int)\r\n・rank (int)\r\n・score (int)\r\n・distinct_code (string)\r\n・source_media (int)\r\n・media_type (int)\r\n・genre (int)\r\n```\r\nmedia_type ごとにDBが分けられるイメージ。\r\n```\r\nmovies\r\n・id (int)\r\n・distinct_code (string)\r\n・source_media (string)\r\n・api_response_json (text)\r\n```"}}