Demande:
  actAs:
    Timestampable: ~
    Sluggable:
      fields: [sujet]
  columns:
    sujet:
      type: string(255)
      notnull: true
    non_respect_process: #Valeur possible 0 : pas encore vérifier, 1 respecté, 2 non respecté.
      type: enum
      values: [0, 1, 2]
      default: 0
      notnull: true
    id_km:
      type: integer
      notnull: true
      default: 0
    id_site:
      type: integer
    label_site:
      type: string(255)
    premier_commentaire:
      type: clob
      notnull: true
    etat_demande_id:
      type: integer
      notnull: true
    utilisateur_createur_id:
      type: integer
    priorite:
      type: integer
      default: 0
      notnull: true
    ordre:
      type: integer
      default: 0
      notnull: true
    flag_incident:
      type: boolean
      default: false
    flag_gantt:
      type: boolean
      default: false
    date_creation:
      type: timestamp
    date_derniere_modif_km:
      type: timestamp
    pole_distinataire:
      type : integer
AgentsAssignes:
  columns:
    demande_id:
      type: integer
      primary: ture
    agent_id:
      type: integer
      primary: ture
  relations:
    sfGuardUser:
      local: agent_id
      foreign: id
      foreignAlias: AgentAssigne
    Demande:
      local: demande_id
      foreign: id
      foreignAlias: DemandeAssignee