//erreur lors du chargement des fixtures

  SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`staystory_local`.`it_ss_employee_edifice`, CONSTRAINT `it_ss_employee_edifice_it_ss_employee_id_it_ss_edifice_id` FOREIGN KEY (`it_ss_employee_id`) REFERENCES `it_ss_edifice` (`id`))



// mes fixtures

ItSsHotel:
  ItSsHotel_1:
    Partner: ItSsPartner_1
    name: 'Hotel Test 1'
    story: 'The amazing story of the Hotel 1'
    practical_information: 'The practical informations of the Hotel 1'
    Address: ItSsAddress_2
    type: hotel
    is_historic: false

ItSsMonument:
  ItSsMonument_2:
    Partner: ItSsPartner_1
    name: 'Monument Test 1'
    story: 'The amazing story of the Monument Test 1'
    practical_information: 'The practical informations of the Monument Test 1'
    Address: ItSsAddress_3
    type: monument
    is_historic: false


ItSsEmployee:
  ItSsEmployee_2:
    username: employee1
    email: serard@serard.com
    algorithm: sha1
    salt: e108223e38e4ad7ebe04c34594640c4c
    password: e25f37e1951148987b85e44a57809244549ed645
    is_active: true
    is_super_admin: false
    last_login: null
    forgot_password_code: null
    type: employee
    created_at: '2011-01-13 14:24:33'
    updated_at: '2011-01-13 14:24:33'
    EmployeeOfEdifices:
      - ItSsMonument_2
      - ItSsHotel_1


//model:

ItSsEmployee:
  inheritance:
    extends: ItSsUser
    type: column_aggregation
    keyField: type
    keyValue: employee
  relations:
    EmployeeOfEdifices:
      class: ItSsEdifice
      local: it_ss_employee_id
      foreign: it_ss_edifice_id
      refClass: ItSsEmployeeEdifice
      foreignAlias: Employees

ItSsEmployeeEdifice:
  options:
    symfony:
      form:   false
      filter: false
  columns:
    it_ss_edifice_id: {type: integer(11), notnull: true}
    it_ss_employee_id: {type: integer(11), notnull: true}
  relations:
    Employee:
      class: ItSsEmployee
      local: it_ss_edifice_id
    Edifice:
      class: ItSsEdifice
      local: it_ss_employee_id

ItSsEdifice:
  actAs:
    DmVersionable: ~
    DmBlameable: ~
    Timestampable: ~
  columns:
    # 'type' must be used as keyField in order to inherit this class
    it_ss_partner_id:       {type: integer(11), notnull: true, extra: paginated}
    name:                   {type: string(255), notnull: true}
    story:                  {type: clob, extra: markdown}
    practical_information:  {type: clob, extra: markdown}
    it_ss_address_id: {type: integer(11), notnull: true}
  relations:
    Employees:
      class: ItSsEmployee
      local: it_ss_edifice_id
      foreign: it_ss_employee_id
      refClass: ItSsEmployeeEdifice
      foreignAlias: EmployeeOfEdifices