3 Tables With An Intermediate Table

Yii 1.1 General Discussion
1

i have 3 tables: action(ID,Name), cycle(ID,Name) and category(ID,Name). these 3 tables are related with an intermediate table actCycleCat(actionID, cycleID, categoryID). is there any way to express the relation between these tables. i made a many to one relation between action - actCycleCat, cycle - actCycleCat and category - actCycleCat, is that correct?

2

have a look at the MANY_MANY relation type, i suggest that you implement it with ‘through’

http://www.yiiframework.com/doc/guide/1.1/en/database.arr