Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # 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) }
- ville: { type: string(255) } # Pour les stats
- cp: { type: string(255) } # Pour les stats
- tel_fixe: { type: string(255) } # et si plusieurs ? Mobile/fixe au moins
- tel_portable: { type: string(255) }
- email: { type: string(255) }
- site_web: { type: string(255) }
- commentaire: { type: string(4000) } # "Il faut parler fort, il est sourd", etc.
- relations:
- Appels: { class: Appel, local: id, foreign: prospect_id, type: many }
- Appel:
- actAs: { Timestampable: ~ }
- columns:
- date: { type: date }
- date_recontact: { type: date }
- commentaire: { type: string(4000) }
- a_rappeler: { type: boolean }
- prospect_id: { type: integer }
- membre_id: { type: integer }
- type_appel_id: { type: integer }
- relations:
- Prospect: { local: prospect_id, foreign: id, type: one }
- Membre: { local: membre_id, foreign: id, type: one }
- TypeAppel: { local: type_appel_id, foreign: id, type: one }
- Membre:
- actAs: { Timestampable: ~ }
- columns:
- nom: { type: string(255) }
- relations:
- Appels: { class: Appel, local:id, foreign: prospect_id, type: many }
- # Appel sortant, manqué, décroché
- TypeAppel:
- columns:
- nom: { type: string(255) }
Add Comment
Please, Sign In to add comment