Techie Corner

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.

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

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

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

Credit: Symfony Documentation

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

---