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

Speed Up and Save Your Website Bandwidth with GZip Compression

How to backup MySQL Database in command line with compression

Symfony: How to query using Criteria OR

How to import contacts from Mac to Nokia N900

How to setup mysqldump without password in cronjob

How to clear play history in VLC media player

How to split compressed file into smaller files in Linux / Mac

Bootstrap 3: Responsive image align center

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