Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Sql > Database normal...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 3 Topic 3452 of 3559
Post > Topic >>

Database normalization

by gatoelho@[EMAIL PROTECTED] ("Sid 'Neko Tamashii'") May 6, 2008 at 08:06 AM

------=_Part_13946_8515752.1210071999465
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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, foreignTable: client, foreignReference:
client_id}
>     bar_id: {type: integer}
>
>   foobar:
>     client_id: {type: integer}
>     foo_id: {type: integer}
>     bar_id: {type: integer}
>     _foreignKeys:
>       fk_foo:
>         foreignTable: foo
>         references:
>           - { local: client_id, foreign: client_id }
>           - { local: foo_id, foreign: foo_id }
>       fk_bar:
>         foreignTable: bar
>         references:
>           - { local: client_id, foreign: client_id }
>           - { local: bar_id, foreign: bar_id }
>
>
The full discussion can be found at
http://www.symfony-project.org/forum/index.php/t/12807/

All I want is the best option, but not based in common sense, but in
rules,
cause after a lot of discussions I found this way better than the usual
one.

------=_Part_13946_8515752.1210071999465
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Is this model (Symfony&#39;s YML based) wrong based on
normalization?<br><br><blockquote style="border-left: 1px solid rgb(204,
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"
class="gmail_quote"><span class="MsgBodyText"><pre>
propel:<br>  client:<br>    client_id: {type: integer}<br><br>  foo:<br>  
 client_id: {type: integer, foreignTable: client, foreignReference:
client_id}<br>    foo_id: {type: integer}<br><br>  bar:<br>    client_id:
{type: integer, foreignTable: client, foreignReference: client_id}<br>
    bar_id: {type: integer}<br><br>  foobar:<br>    client_id: {type:
integer}<br>    foo_id: {type: integer}<br>    bar_id: {type: integer}<br>
   _foreignKeys:<br>      fk_foo:<br>        foreignTable: foo<br>       
references:<br>
          - { local: client_id, foreign: client_id }<br>          - {
local: foo_id, foreign: foo_id }<br>      fk_bar:<br>        foreignTable:
bar<br>        references:<br>          - { local: client_id, foreign:
client_id }<br>
          - { local: bar_id, foreign: bar_id
}</pre></span></blockquote><div><br>The full discussion can be found at <a
href="http://www.symfony-project.org/forum/index.php/t/12807/">http://www.symfony-project.org/forum/index.php/t/12807/</a><br>
<br>All I want is the best option, but not based in common sense, but in
rules, cause after a lot of discussions I found this way better than the
usual one.<br></div>

------=_Part_13946_8515752.1210071999465--
 




 3 Posts in Topic:
Database normalization
gatoelho@[EMAIL PROTECTED  2008-05-06 08:06:39 
Re: Database normalization
dev@[EMAIL PROTECTED] (R  2008-05-06 13:28:14 
Re: Database normalization
gatoelho@[EMAIL PROTECTED  2008-05-06 09:33:48 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Sun Jul 6 22:04:35 CDT 2008.