SfGuardUserProfile:
  actAs:
    #JCroppable:
    #  images: [avatar]
    Sluggable:
      fields: [firstname, lastname]
      options:
        notnull: true
  columns:
    id:
      type: integer(4)
      primary: true
      unique: true
      notnull: true
    is_ce:
      type: boolean
      default: 0
    firstname:
      type: string(255)
      notnull: true
    lastname:
      type: string(255)
      notnull: true
    birthdate:
      type: date
      notnull: true
    gender:
      type: enum
      values: ['man','woman']
      notnull: true
    email:
      type: string(255)
      notnull: true
    email_is_public:
      type: boolean
      default: 1
      notnull: true
    type_job_id:
      type: integer(1)
      notnull: true
    bio:
      type: string(1000)
    accepted_at:
      type: date
  relations:
    sfGuardUser:
      local: id
      foreign: id
      type: one
      foreignType: one
      foreignAlias: Profile
      alias: User
      onDelete: CASCADE
    TypeJob:
      local: type_job_id
      foreign: id
      type: one