{"action":"created","issue":{"url":"https://api.github.com/repos/KentaYamada/smart-aquarium/issues/2","repository_url":"https://api.github.com/repos/KentaYamada/smart-aquarium","labels_url":"https://api.github.com/repos/KentaYamada/smart-aquarium/issues/2/labels{/name}","comments_url":"https://api.github.com/repos/KentaYamada/smart-aquarium/issues/2/comments","events_url":"https://api.github.com/repos/KentaYamada/smart-aquarium/issues/2/events","html_url":"https://github.com/KentaYamada/smart-aquarium/issues/2","id":542556085,"node_id":"MDU6SXNzdWU1NDI1NTYwODU=","number":2,"title":"アプリケーション基本構想","user":{"login":"KentaYamada","id":4031717,"node_id":"MDQ6VXNlcjQwMzE3MTc=","avatar_url":"https://avatars1.githubusercontent.com/u/4031717?v=4","gravatar_id":"","url":"https://api.github.com/users/KentaYamada","html_url":"https://github.com/KentaYamada","followers_url":"https://api.github.com/users/KentaYamada/followers","following_url":"https://api.github.com/users/KentaYamada/following{/other_user}","gists_url":"https://api.github.com/users/KentaYamada/gists{/gist_id}","starred_url":"https://api.github.com/users/KentaYamada/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/KentaYamada/subscriptions","organizations_url":"https://api.github.com/users/KentaYamada/orgs","repos_url":"https://api.github.com/users/KentaYamada/repos","events_url":"https://api.github.com/users/KentaYamada/events{/privacy}","received_events_url":"https://api.github.com/users/KentaYamada/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"KentaYamada","id":4031717,"node_id":"MDQ6VXNlcjQwMzE3MTc=","avatar_url":"https://avatars1.githubusercontent.com/u/4031717?v=4","gravatar_id":"","url":"https://api.github.com/users/KentaYamada","html_url":"https://github.com/KentaYamada","followers_url":"https://api.github.com/users/KentaYamada/followers","following_url":"https://api.github.com/users/KentaYamada/following{/other_user}","gists_url":"https://api.github.com/users/KentaYamada/gists{/gist_id}","starred_url":"https://api.github.com/users/KentaYamada/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/KentaYamada/subscriptions","organizations_url":"https://api.github.com/users/KentaYamada/orgs","repos_url":"https://api.github.com/users/KentaYamada/repos","events_url":"https://api.github.com/users/KentaYamada/events{/privacy}","received_events_url":"https://api.github.com/users/KentaYamada/received_events","type":"User","site_admin":false},"assignees":[{"login":"KentaYamada","id":4031717,"node_id":"MDQ6VXNlcjQwMzE3MTc=","avatar_url":"https://avatars1.githubusercontent.com/u/4031717?v=4","gravatar_id":"","url":"https://api.github.com/users/KentaYamada","html_url":"https://github.com/KentaYamada","followers_url":"https://api.github.com/users/KentaYamada/followers","following_url":"https://api.github.com/users/KentaYamada/following{/other_user}","gists_url":"https://api.github.com/users/KentaYamada/gists{/gist_id}","starred_url":"https://api.github.com/users/KentaYamada/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/KentaYamada/subscriptions","organizations_url":"https://api.github.com/users/KentaYamada/orgs","repos_url":"https://api.github.com/users/KentaYamada/repos","events_url":"https://api.github.com/users/KentaYamada/events{/privacy}","received_events_url":"https://api.github.com/users/KentaYamada/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2019-12-26T13:27:11Z","updated_at":"2019-12-26T13:47:37Z","closed_at":null,"author_association":"OWNER","body":"## コンセプト\r\n- 水槽内の水温、PH値を測る\r\n- 計測間隔は10分おきとする\r\n- 計測データをグラフで可視化する\r\n- データ収集アプリ、データ参照アプリを別々で稼働するものとする\r\n- DBのトランザクションを制限する\r\n  - データ計測: Write only\r\n  - データ参照: Read only"},"comment":{"url":"https://api.github.com/repos/KentaYamada/smart-aquarium/issues/comments/569061549","html_url":"https://github.com/KentaYamada/smart-aquarium/issues/2#issuecomment-569061549","issue_url":"https://api.github.com/repos/KentaYamada/smart-aquarium/issues/2","id":569061549,"node_id":"MDEyOklzc3VlQ29tbWVudDU2OTA2MTU0OQ==","user":{"login":"KentaYamada","id":4031717,"node_id":"MDQ6VXNlcjQwMzE3MTc=","avatar_url":"https://avatars1.githubusercontent.com/u/4031717?v=4","gravatar_id":"","url":"https://api.github.com/users/KentaYamada","html_url":"https://github.com/KentaYamada","followers_url":"https://api.github.com/users/KentaYamada/followers","following_url":"https://api.github.com/users/KentaYamada/following{/other_user}","gists_url":"https://api.github.com/users/KentaYamada/gists{/gist_id}","starred_url":"https://api.github.com/users/KentaYamada/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/KentaYamada/subscriptions","organizations_url":"https://api.github.com/users/KentaYamada/orgs","repos_url":"https://api.github.com/users/KentaYamada/repos","events_url":"https://api.github.com/users/KentaYamada/events{/privacy}","received_events_url":"https://api.github.com/users/KentaYamada/received_events","type":"User","site_admin":false},"created_at":"2019-12-26T13:47:37Z","updated_at":"2019-12-26T13:47:37Z","author_association":"OWNER","body":"## データベース\r\n### 水槽状態管理テーブル\r\n|論理カラム|物理カラム|データ型|NULL許容|キー|備考|\r\n|:---|:---|:---|:---:|:---:|:---|\r\n|ID|id|integer|x|PK|auto increment|\r\n|計測日時|measured_at|text|x|Unique|fetch時にdatetime型へキャスト|\r\n|pH値|ph|real|x| | |\r\n|水温|temperature|real|x| | |\r\n\r\n### アラート通知テーブル\r\n|論理カラム|物理カラム|データ型|NULL許容|キー|備考|\r\n|:---|:---|:---|:---:|:---:|:---|\r\n|ID|id|integer|x|PK| auto increment|\r\n|登録日時|created_at|text|x|Unique| fetch時にdatetime型へキャスト|\r\n|通知内容|message|text|x|| | |\r\n\r\n### 設定テーブル\r\n|論理カラム|物理カラム|データ型|NULL許容|キー|備考|\r\n|:---|:---|:---|:---:|:---:|:---|\r\n|ID|id|integer|x|PK| |\r\n|pH下限値|ph_lower_limit|real|x| |アラート通知するためのしきい値|\r\n|pH上限値|ph_upper_limit|real|x| |アラート通知するためのしきい値|\r\n|水温下限値|temperature_lower_limit|real|x| |アラート通知するためのしきい値|\r\n|水温上限値|temperature_upper_limit|real|x| |アラート通知するためのしきい値|\r\n|計測試行回数|measurement_trials|integer|x| |データ計測時に通信する回数|\r\n\r\n### SQL\r\n``` sql\r\ncreate table aquarium_water_quarities (\r\n    id integer primary key autoincrement,\r\n    measured_at text not null,\r\n    ph real not null,\r\n    temperature real not null,\r\n    unique(measured_at)\r\n);\r\n\r\ncreate table notifications (\r\n    id integer primary key autoincrement,\r\n    created_at text not null,\r\n    maessage text not null\r\n);\r\n\r\ncreate table configurations (\r\n    id integer primary key,\r\n    ph_lower_limit real not null,\r\n    ph_upper_limit real not null,\r\n    temperature_lower_limit real not null,\r\n    temperature_upper_limit real not null,\r\n    measurement_trials integer not null\r\n);\r\n```"}}
{"actor":{"display_login":"KentaYamada"}}