{"action":"created","issue":{"url":"https://api.github.com/repos/Capstone-Design1/sogang-space/issues/1","repository_url":"https://api.github.com/repos/Capstone-Design1/sogang-space","labels_url":"https://api.github.com/repos/Capstone-Design1/sogang-space/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/Capstone-Design1/sogang-space/issues/1/comments","events_url":"https://api.github.com/repos/Capstone-Design1/sogang-space/issues/1/events","html_url":"https://github.com/Capstone-Design1/sogang-space/issues/1","id":326382078,"number":1,"title":"DB 설계","user":{"login":"heumsi","id":31306282,"avatar_url":"https://avatars0.githubusercontent.com/u/31306282?v=4","gravatar_id":"","url":"https://api.github.com/users/heumsi","html_url":"https://github.com/heumsi","followers_url":"https://api.github.com/users/heumsi/followers","following_url":"https://api.github.com/users/heumsi/following{/other_user}","gists_url":"https://api.github.com/users/heumsi/gists{/gist_id}","starred_url":"https://api.github.com/users/heumsi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/heumsi/subscriptions","organizations_url":"https://api.github.com/users/heumsi/orgs","repos_url":"https://api.github.com/users/heumsi/repos","events_url":"https://api.github.com/users/heumsi/events{/privacy}","received_events_url":"https://api.github.com/users/heumsi/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2018-05-25T05:01:51Z","updated_at":"2018-05-29T10:29:12Z","closed_at":null,"author_association":"NONE","body":"크게, 테이블 필드를 다음과 같이 나눈다.\r\n**(위치) (시설) (환경) (평가)**\r\n\r\n- **(위치)**\r\n건물 / 층 / 강의실이름\r\n_ex.  J / 3 / J319_\r\n\r\n- **(시설)**\r\n시간표 / 강의실 사진 / 평면도 / 면적 / 사용가능인원 / 책상 수 / 시설 종류 (에어컨, 스피커 등) / 활용방법\r\n_ex. (코멘트로 달아주세요.)_\r\n\r\n- **(환경)**\r\n시간 / 온도 / 습도 / 이산화탄소 / 미세먼지\r\n_ex. 2018-05-10 : 09:14:00 / 24.5 / 34 / 870 / 20_\r\n\r\n- **(평가)**\r\n사람 수 / 환경점수(5점 만점) / 불쾌지수(Trello 에서 모델 확인)\r\n_ex. 3 / 3.5 / 60_"},"comment":{"url":"https://api.github.com/repos/Capstone-Design1/sogang-space/issues/comments/392729616","html_url":"https://github.com/Capstone-Design1/sogang-space/issues/1#issuecomment-392729616","issue_url":"https://api.github.com/repos/Capstone-Design1/sogang-space/issues/1","id":392729616,"user":{"login":"taeseunglee","id":9005291,"avatar_url":"https://avatars3.githubusercontent.com/u/9005291?v=4","gravatar_id":"","url":"https://api.github.com/users/taeseunglee","html_url":"https://github.com/taeseunglee","followers_url":"https://api.github.com/users/taeseunglee/followers","following_url":"https://api.github.com/users/taeseunglee/following{/other_user}","gists_url":"https://api.github.com/users/taeseunglee/gists{/gist_id}","starred_url":"https://api.github.com/users/taeseunglee/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/taeseunglee/subscriptions","organizations_url":"https://api.github.com/users/taeseunglee/orgs","repos_url":"https://api.github.com/users/taeseunglee/repos","events_url":"https://api.github.com/users/taeseunglee/events{/privacy}","received_events_url":"https://api.github.com/users/taeseunglee/received_events","type":"User","site_admin":false},"created_at":"2018-05-29T10:29:12Z","updated_at":"2018-05-29T10:29:12Z","author_association":"CONTRIBUTOR","body":"시설 table 생성 query (예정)\r\nCREATE TABLE facility (\r\n    name             varchar[16],\r\n    building         varchar[8],\r\n    floor               int,\r\n    floor_plan      varchar[64],\r\n    area               real,\r\n    accomodation  int,\r\n    num_desk         int,\r\n    facilities            int[],\r\n);"}}
{"actor":{"display_login":"taeseunglee"}}