Re: [SQL] Database normalization

2008-05-06 Thread Sid 'Neko Tamashii'
id } > Each client has it's own profiles and users, and each user has some profiles The idea is to enforce the value of client_id to be the same at all moments On Tue, May 6, 2008 at 9:28 AM, Richard Huxton <[EMAIL PROTECTED]> wrote: > Sid 'Neko Tamashii' w

[SQL] Database normalization

2008-05-06 Thread Sid &#x27;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