Etat:
  tableName: etat
  columns:
    titre:
      type: string(255)
      notnull: true
    color:
      type: string(255)
      notnull: true
Comment:
  actAs:
    Timestampable: ~
  tableName: comment
  columns:
    titre:
      type: string(255)
    comment:
      type: clob
      notnull: true
    user_id:
      type: integer(4)
  relations:
    sfGuardUser:
      type: one
      foreignType: many
      local: user_id
      foreign: id
      foreignAlias: Users
Tache:
  actAs:
    Timestampable: ~
  tableName: tache
  columns:
    activite:
      type: string(255)
      notnull: true
    id_etat:
      type: integer
      notnull: true
  relations:
    Etat:  { onDelete: CASCADE, local: id_etat, foreign: id }
    TacheComments:
      class: Comment
      refClass: TacheComment
      local: id_tache
      foreign: id_comment
    sfGuardUsers:
      class: sfGuardUser
      refClass: TacheUser
      local: id_tache
      foreign: id_user
TacheUser:
  tableName: tache_user
  columns:
    id_tache:
      type: integer
      notnull: true
    id_user:
      type: integer(4)
      notnull: true
  relations:
    Tache:  { onDelete: CASCADE, local: id_tache, foreign: id }
    sfGuardUser: { onDelete: CASCADE, local: id_user, foreign: id }
TacheComment:
  tableName: tache_comment
  columns:
    id_tache:
      type: integer
      notnull: true
    id_comment:
      type: integer
      notnull: true
  relations:
    Tache:  { onDelete: CASCADE, local: id_tache, foreign: id }
    Comment: { onDelete: CASCADE, local: id_comment, foreign: id }