Re: [SQL] Database normalization

2008-05-06 Thread Sid 'Neko Tamashii'
To be more clear: > client: > id: {type: integer} > > users: > user_id: {type: integer, primaryKey:true, foreignTable: client, > foreignReference: id} > id: {type: integer} > > profiles: > client_id: {type: integer, primaryKey:true, foreignTable: client, > foreignReference: id} > id: {ty

Re: [SQL] Database normalization

2008-05-06 Thread Richard Huxton
Sid 'Neko Tamashii' wrote: Is this model (Symfony's YML based) wrong based on normalization? propel: client: client_id: {type: integer} foo: client_id: {type: integer, foreignTable: client, foreignReference: client_id} foo_id: {type: integer} bar: client_id: {type: inte

[SQL] Database normalization

2008-05-06 Thread Sid 'Neko Tamashii'
Is this model (Symfony's YML based) wrong based on normalization? propel: > client: > client_id: {type: integer} > > foo: > client_id: {type: integer, foreignTable: client, foreignReference: > client_id} > foo_id: {type: integer} > > bar: > client_id: {type: integer, foreign