symfonytry2

Contactpersoon:
  connection: doctrine
  tableName: contactpersoon
  columns:
    contactpersoon_id:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: true
    voornaam:
      type: string(15)
      fixed: false
      unsigned: false
      primary: false
      notnull: true
      autoincrement: false
  relations:
    Locatie:
      class: Locatie
      refClass: ContactRegel
      local: contactpersoon_id
      foreign: loc_id
    Organisatie:
      class: Organisatie
      refClass: ContactRegel
      local: contactpersoon_id
      foreign: org_id
Locatie:
  connection: doctrine
  tableName: locatie
  columns:
    loc_id:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: true
    org_id:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: false
      notnull: false
      autoincrement: false
    naam:
      type: string(30)
      fixed: false
      unsigned: false
      primary: false
      notnull: true
      autoincrement: false
  relations:
    Organisatie:
      local: org_id
      foreign: org_id
      type: one
      onDelete: SET NULL
      onUpdate: CASCADE
    Contactpersoon:
      class: Contactpersoon
      refClass: ContactRegel
      local: loc_id
      foreign: contactpersoon_id
Organisatie:
  connection: doctrine
  tableName: organisatie
  columns:
    org_id:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: true
    naam:
      type: string(30)
      fixed: false
      unsigned: false
      primary: false
      notnull: true
      autoincrement: false
  relations:
    Locatie:
      local: org_id
      foreign: org_id
      type: many
    Contactpersoon:
      class: Contactpersoon
      refClass: ContactRegel
      local: org_id
      foreign: contactpersoon_id