{"action":"closed","issue":{"url":"https://api.github.com/repos/opencloset/opencloset/issues/516","labels_url":"https://api.github.com/repos/opencloset/opencloset/issues/516/labels{/name}","comments_url":"https://api.github.com/repos/opencloset/opencloset/issues/516/comments","events_url":"https://api.github.com/repos/opencloset/opencloset/issues/516/events","html_url":"https://github.com/opencloset/opencloset/issues/516","id":94918972,"number":516,"title":"2015년 2월 16일 이전 데이터베이스에 저장된 대여 목적의 정규화","user":{"login":"yongbin","id":52704,"avatar_url":"https://avatars.githubusercontent.com/u/52704?v=3","gravatar_id":"","url":"https://api.github.com/users/yongbin","html_url":"https://github.com/yongbin","followers_url":"https://api.github.com/users/yongbin/followers","following_url":"https://api.github.com/users/yongbin/following{/other_user}","gists_url":"https://api.github.com/users/yongbin/gists{/gist_id}","starred_url":"https://api.github.com/users/yongbin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yongbin/subscriptions","organizations_url":"https://api.github.com/users/yongbin/orgs","repos_url":"https://api.github.com/users/yongbin/repos","events_url":"https://api.github.com/users/yongbin/events{/privacy}","received_events_url":"https://api.github.com/users/yongbin/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/opencloset/opencloset/labels/%EC%8B%A4DB","name":"실DB","color":"e11d21"}],"state":"closed","locked":false,"assignee":{"login":"yongbin","id":52704,"avatar_url":"https://avatars.githubusercontent.com/u/52704?v=3","gravatar_id":"","url":"https://api.github.com/users/yongbin","html_url":"https://github.com/yongbin","followers_url":"https://api.github.com/users/yongbin/followers","following_url":"https://api.github.com/users/yongbin/following{/other_user}","gists_url":"https://api.github.com/users/yongbin/gists{/gist_id}","starred_url":"https://api.github.com/users/yongbin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yongbin/subscriptions","organizations_url":"https://api.github.com/users/yongbin/orgs","repos_url":"https://api.github.com/users/yongbin/repos","events_url":"https://api.github.com/users/yongbin/events{/privacy}","received_events_url":"https://api.github.com/users/yongbin/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/opencloset/opencloset/milestones/5","html_url":"https://github.com/opencloset/opencloset/milestones/3%EC%B0%A8%20%EC%98%A4%ED%94%88","labels_url":"https://api.github.com/repos/opencloset/opencloset/milestones/5/labels","id":963095,"number":5,"title":"3차 오픈","description":"2차 오픈 및 2차 피드백 이후 진행할 이슈","creator":{"login":"keedi","id":138451,"avatar_url":"https://avatars.githubusercontent.com/u/138451?v=3","gravatar_id":"","url":"https://api.github.com/users/keedi","html_url":"https://github.com/keedi","followers_url":"https://api.github.com/users/keedi/followers","following_url":"https://api.github.com/users/keedi/following{/other_user}","gists_url":"https://api.github.com/users/keedi/gists{/gist_id}","starred_url":"https://api.github.com/users/keedi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/keedi/subscriptions","organizations_url":"https://api.github.com/users/keedi/orgs","repos_url":"https://api.github.com/users/keedi/repos","events_url":"https://api.github.com/users/keedi/events{/privacy}","received_events_url":"https://api.github.com/users/keedi/received_events","type":"User","site_admin":false},"open_issues":10,"closed_issues":43,"state":"open","created_at":"2015-02-03T08:40:51Z","updated_at":"2015-07-29T04:41:05Z","due_on":"2015-07-05T15:00:00Z","closed_at":null},"comments":13,"created_at":"2015-07-14T10:53:05Z","updated_at":"2015-07-29T04:41:05Z","closed_at":"2015-07-29T04:41:05Z","body":"현재 DB의 `order` 테이블의 `purpose` 컬럼은 대여자의 대여목적 대분류의 정보를 담고 있습니다. 열린옷장에서는 각종 통계분석에서 이 대여목적에 따른 분석을 진행하고 싶지만 현재 DB상의 자료는 사용자의 입력실수등으로 카테고리가 많이 분산되어있는 상태입니다. 따라서 현재 DB상에 나눠져있는 대여목적을 일정수 이하의 항목으로 정규화하는 작업을 별도로 진행하겠습니다.\r\n\r\n![screenshot 2015-07-14 19 52 43](https://cloud.githubusercontent.com/assets/52704/8671643/eda97b7a-2a61-11e5-9ab8-0d7156af8d7f.png)\r\n"}}