------=_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'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--


|