This symfony doctrine schema relationship sample is for my own reference. I think many people out there also facing the same problem as me when writing the doctrine schema relationship. Here are some of the relationship sample that give a very simple sample.
Advertisements
One to One relationship between User and Profile:-
|
1 2 3 4 5 6 7 8 9 10 11 12 |
Profile: columns: user_id: integer name: string(255) email_address: type: string(255) relations: User: local: user_id foreign: id type: one foreignType: one |
One to Many relationship between User and Phonenumber:-
|
1 2 3 4 5 6 7 8 9 10 11 |
Phonenumber: columns: user_id: integer phonenumber: string(255) relations: User: foreignAlias: Phonenumbers local: user_id foreign: id type: one foreignType: many |
Many to Many relation between BlogPost and Tag:-
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
BlogPost: columns: user_id: integer title: string(255) body: clob relations: User: local: user_id foreign: id type: one foreignType: one foreignAlias: BlogPosts Tags: class: Tag foreignAlias: BlogPosts refClass: BlogPostTag local: blog_post_id foreign: tag_id Tag: columns: name: string(255) BlogPostTag: columns: blog_post_id: type: integer primary: true tag_id: type: integer primary: true relations: BlogPost: local: blog_post_id foreign: id foreignAlias: BlogPostTags Tag: local: tag_id foreign: id foreignAlias: BlogPostTags |
Credit: Symfony Documentation
Related posts:
CPAN Error: make test had returned bad status, won't install without force
How to use apt to list available packages?
WordPress: How to create left sidebar template in TwentyEleven theme?
Mod Security - Open source Web Application Firewall
Contact Form 7: Clear all field except specific after submission
How to create mailing list in Thunderbird
Symfony 1.4: How to sort foreign key record?
How to svn thru ssh in Linux / Mac
Share this with your friends:-
