Great question. We are currently using YII to build an extranet for our partners, which shares the same database as our website. The existing data structure, although works well for our internal use, does not meet the needs of our partners. As a medium term solution, we decided to add an assignment table.