# config/doctrine/schema.yml
Prospect:
  actAs: { Timestampable: ~ }
  columns:
    Nom:   { type: string(255), notnull: true }
    Contact:      { type: string(255) }
    Fonction:     { type: string(255) }
    Adresse:      { type: string(255) }
    Telephone:    { type: string(255) }
    Email:        { type: string(255) }
    Site_web:     { type: string(255) }

Appel:
  actAs: { Timestampable: ~ }
  columns:
    Prospect_id:           { type: integer, notnull: true }
    Prospecteur:           { type: string(255) }
    Date_recontact:        { type: date }
    Commentaire:           { type: string(4000) }
    A_rappeller:           { type: boolean }
  relations:
    Prospect: { local: Prospect_id, foreign: id, foreignAlias: Appels, type: one, foreignType: many }