Symfony doctrine schema relationship sample

symfony 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:-

Profile:
  columns:
    user_id: integer
    name: string(255)
    email_address:
      type: string(255)
  relations:
    User:
      local: user_id
      foreign: id
      type: one
      foreignType: one

Profile:

columns:

user_id: integer

email_address:

type: string(255)

relations:

User:

local: user_id

foreign: id

type: one

foreignType: one

One to Many relationship between User and Phonenumber:-

Phonenumber:
  columns:
    user_id: integer
    phonenumber: string(255)
  relations:
    User:
      foreignAlias: Phonenumbers
      local: user_id
      foreign: id
      type: one
      foreignType: many

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:-

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

BlogPost:

columns:

user_id: integer

title: string(255)

body: clob

relations:

User:

local: user_id

foreign: id

type: one

foreignType: one

foreignAlias: BlogPosts

Tags:

foreignAlias: BlogPosts

refClass: BlogPostTag

local: blog_post_id

foreign: tag_id

Tag:

columns:

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

Turn on MySQL query cache to speed up query performance?

How to svn thru ssh in Linux / Mac

How to upload file in Symfony 1.4

How to sort drop down - Admin Generator - Symfony 1.4

Common MySQL database maintenance command

MySQL: Full text search for multiple words

Cynogenmod: No Vibration when Receiving SMS

Composer: PHP Fatal error: Allowed memory size of ... exhausted...

Tags: doctrine schema relationship sample, symfony, symfony doctrine schema, symfony doctrine schema relationship, symfony relationship sample, symfony schema relationship

Share this with your friends:-

Techie Corner