Yii ‘s CArrayDataProvider is very helpful to display model relation data's directly on it.But it is truely a confusing one because by default it will assume a table field named “id” as primary key for its pagination purpose and what if you dont have field named “id” as primary key on your table? so its truely confusing and if you tried to display without an “id” field on ur table you will get an error like “yourmodel.id is not defined”.
Please consider the following
Dear software engineers imagine I have a simple ISA hierarchy: parent A with
children B and C.
So let's say we have the corresponding tables named "a", "b", "c" and (created
with the help of the gii model creator) the classes A, B, C
The following is a screenshot from MySQL workbench: