{"action":"created","issue":{"url":"https://api.github.com/repos/opencloset/opencloset/issues/79","labels_url":"https://api.github.com/repos/opencloset/opencloset/issues/79/labels{/name}","comments_url":"https://api.github.com/repos/opencloset/opencloset/issues/79/comments","events_url":"https://api.github.com/repos/opencloset/opencloset/issues/79/events","html_url":"https://github.com/opencloset/opencloset/issues/79","id":37956018,"number":79,"title":"의류의 세트를 묶음으로 입력할 수 있는 UI","user":{"login":"10001if","id":4696328,"avatar_url":"https://avatars.githubusercontent.com/u/4696328?v=3","gravatar_id":"","url":"https://api.github.com/users/10001if","html_url":"https://github.com/10001if","followers_url":"https://api.github.com/users/10001if/followers","following_url":"https://api.github.com/users/10001if/following{/other_user}","gists_url":"https://api.github.com/users/10001if/gists{/gist_id}","starred_url":"https://api.github.com/users/10001if/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/10001if/subscriptions","organizations_url":"https://api.github.com/users/10001if/orgs","repos_url":"https://api.github.com/users/10001if/repos","events_url":"https://api.github.com/users/10001if/events{/privacy}","received_events_url":"https://api.github.com/users/10001if/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/opencloset/opencloset/labels/%EB%86%92%EC%9D%8C","name":"높음","color":"eb6420"}],"state":"open","locked":false,"assignee":{"login":"aanoaa","id":170528,"avatar_url":"https://avatars.githubusercontent.com/u/170528?v=3","gravatar_id":"","url":"https://api.github.com/users/aanoaa","html_url":"https://github.com/aanoaa","followers_url":"https://api.github.com/users/aanoaa/followers","following_url":"https://api.github.com/users/aanoaa/following{/other_user}","gists_url":"https://api.github.com/users/aanoaa/gists{/gist_id}","starred_url":"https://api.github.com/users/aanoaa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aanoaa/subscriptions","organizations_url":"https://api.github.com/users/aanoaa/orgs","repos_url":"https://api.github.com/users/aanoaa/repos","events_url":"https://api.github.com/users/aanoaa/events{/privacy}","received_events_url":"https://api.github.com/users/aanoaa/received_events","type":"User","site_admin":false},"milestone":null,"comments":28,"created_at":"2014-07-16T07:28:58Z","updated_at":"2016-01-18T05:16:19Z","closed_at":null,"body":"자켓, 바지\r\n자켓, 스커트\r\n자켓, 바지1, 바지2\r\n자켓, 바지, 베스트 \r\n\r\n처럼 단품이 세트로 등록되어 세트로 인식할 수 있도록 입력을 할 수 있는 기능을 요청드립니다. 세트 확인은 향후 의류 관리시 공간 내에 세트를 동일한 위치에 보관하고, 기타(세탁, 수선) 상황 발생시 짝짝이로 떨어져 있는 의류들의 정렬을 위해 필요한 것입니다.\r\n\r\n세트 확인과 상태(대여가능, 수선, 세탁) 확인의 기능만 있으면 될 것 같구요. 추가적으로 세트로 동작할 다른 이유는 없을 것 같습니다. :)"},"comment":{"url":"https://api.github.com/repos/opencloset/opencloset/issues/comments/172428181","html_url":"https://github.com/opencloset/opencloset/issues/79#issuecomment-172428181","issue_url":"https://api.github.com/repos/opencloset/opencloset/issues/79","id":172428181,"user":{"login":"aanoaa","id":170528,"avatar_url":"https://avatars.githubusercontent.com/u/170528?v=3","gravatar_id":"","url":"https://api.github.com/users/aanoaa","html_url":"https://github.com/aanoaa","followers_url":"https://api.github.com/users/aanoaa/followers","following_url":"https://api.github.com/users/aanoaa/following{/other_user}","gists_url":"https://api.github.com/users/aanoaa/gists{/gist_id}","starred_url":"https://api.github.com/users/aanoaa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aanoaa/subscriptions","organizations_url":"https://api.github.com/users/aanoaa/orgs","repos_url":"https://api.github.com/users/aanoaa/repos","events_url":"https://api.github.com/users/aanoaa/events{/privacy}","received_events_url":"https://api.github.com/users/aanoaa/received_events","type":"User","site_admin":false},"created_at":"2016-01-18T05:16:18Z","updated_at":"2016-01-18T05:16:18Z","body":"테이블 스키마를 변경하지 않고 테이블을 추가해서 해결하려 합니다.\r\n(Group 을 변경하지 않고, Set 의류의 대한 정보를 기록할 수 있는 테이블 추가)\r\n\r\n지금 해결하고자 하는 문제는(앞으로 어떻게 변경될지 고려하지 않고),\r\n자켓과 팬츠, 자켓과 스커트의 연결입니다.\r\n\r\n``` sql\r\nDROP TABLE IF EXISTS `suit` ;\r\nCREATE TABLE `suit` (\r\n  `code_top`    CHAR(5) NOT NULL,\r\n  `code_bottom` CHAR(5) NOT NULL,\r\n\r\n  PRIMARY KEY (`code_top`),\r\n  UNIQUE KEY  (`code_bottom`),\r\n\r\n  CONSTRAINT `fk_suit1` FOREIGN KEY (`code_top`)    REFERENCES `clothes` (`code`) ON DELETE CASCADE,\r\n  CONSTRAINT `fk_suit2` FOREIGN KEY (`code_bottom`) REFERENCES `clothes` (`code`) ON DELETE CASCADE\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n```\r\n\r\n\"a suit\" 의 의미는 위아래 한벌 입니다. 더 기억하기 쉽고 좋은 테이블\r\n명이 필요합니다.\r\n\r\n위아래 한벌을 나타내는 테이블에\r\n\r\n윗옷에 대한 code 와 아래옷의 code 를 저장합니다.\r\n각각은 유일해야 합니다.\r\n\r\n한번에 한개씩만 연결될 수 있습니다.\r\n\r\n자켓A 는 팬츠A 하고만 set 일 수 있습니다.\r\n동시에 팬츠B 와 set 일 수 없습니다.\r\n"}}