On Wed, May 14, 2008 at 11:20 AM, Alex <outroa...@gmail.com> wrote:
> But with column aggregation I also have to define an additional column
> manually. It generates a TYPE column, but then I also need to create a
> TYPE_ID column so that the vote corresponds to the right item or topic.

> What's the ideal solution?

> - alex (from iphone)

> On 14-May-08, at 11:51 AM, "Jonathan Wage" <jonw...@gmail.com> wrote:

> Simple inheritance is one table with all columns on the parent.

> You want something like column aggregation inheritance it sounds like.

> - Jon

> On Tue, May 13, 2008 at 5:17 PM, Alex < <outroa...@gmail.com>
> outroa...@gmail.com> wrote:

>> What exactly is simple inheritance? With what I have below, it doesn't
>> create any addiotional tables. How will I be able to query only votes
>> for Items?

>> Thanks!

>> Vote:
>>  tableName: votes
>>  actAs:
>>    Timestampable:
>>      created:
>>        name: created_at
>>        type: timestamp
>>        format:Y-m-d H:i:s
>>      updated:
>>        disabled: true
>>  columns:
>>    id:
>>      unsigned: 0
>>      primary: true
>>      notnull: true
>>      autoincrement: true
>>      type: integer
>>    user_id:
>>      unsigned: 0
>>      primary: false
>>      notnull: false
>>      autoincrement: false
>>      type: integer

>> VoteItem:
>>  inheritance:
>>    extends: Vote
>>    type: simple

>> VoteComment:
>>  inheritance:
>>    extends: Vote
>>    type: simple

> --
> Jonathan Wage
> <http://www.jwage.com>http://www.jwage.com
> <http://www.centresource.com>http://www.centresource.com