{"action":"opened","issue":{"url":"https://api.github.com/repos/macrozheng/mall/issues/20","repository_url":"https://api.github.com/repos/macrozheng/mall","labels_url":"https://api.github.com/repos/macrozheng/mall/issues/20/labels{/name}","comments_url":"https://api.github.com/repos/macrozheng/mall/issues/20/comments","events_url":"https://api.github.com/repos/macrozheng/mall/issues/20/events","html_url":"https://github.com/macrozheng/mall/issues/20","id":394766519,"node_id":"MDU6SXNzdWUzOTQ3NjY1MTk=","number":20,"title":"三个表之间耦合不好","user":{"login":"V-Legolas","id":37805488,"node_id":"MDQ6VXNlcjM3ODA1NDg4","avatar_url":"https://avatars0.githubusercontent.com/u/37805488?v=4","gravatar_id":"","url":"https://api.github.com/users/V-Legolas","html_url":"https://github.com/V-Legolas","followers_url":"https://api.github.com/users/V-Legolas/followers","following_url":"https://api.github.com/users/V-Legolas/following{/other_user}","gists_url":"https://api.github.com/users/V-Legolas/gists{/gist_id}","starred_url":"https://api.github.com/users/V-Legolas/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/V-Legolas/subscriptions","organizations_url":"https://api.github.com/users/V-Legolas/orgs","repos_url":"https://api.github.com/users/V-Legolas/repos","events_url":"https://api.github.com/users/V-Legolas/events{/privacy}","received_events_url":"https://api.github.com/users/V-Legolas/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-12-29T06:31:09Z","updated_at":"2018-12-29T06:31:09Z","closed_at":null,"author_association":"NONE","body":"请问：sms_flash_promotion(限时购) 和 sms_flash_promotion_session(限时购场次表）是一对多关系吧，还有sms_falsh_promotion_session 又和 pms_product(商品表）是“一对多” 关系，直接用sms_flash_promotion_product_relation作为三个表之间的关联表？就直接导致在SmsFlashSessionService的list(Long flashPromotionId)方法（根据限时购表主键id查询限时购场次信息及商品数目）中查询不方便，效率也不高，建议改为在场次中引入限时购id作为关联，产品中引入场次主键id作为关联"}}
{"actor":{"display_login":"V-Legolas"}}