options:
  type: INNODB
  collate: utf8_general_ci
  charset: utf8

User:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
    firstname:
      type: string(20)
    lastname:
      type: string(20)
    email:
      type: string(100)
    password:
      type: string(64)
  actAs:
    Timestampable:
      created:
        name: date_created
      updated:
        name: date_modified
  relations:
    UserAttributes:
      class: UserAttributes
      local: id
      foreign: user_id
      foreignType: many
      type: many

UserAttributes:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
    user_id:
      type: integer
    name:
      type: string(20)
    value:
      type: string(200)
      default: false
  relations:
    User:
      class: User
      local: user_id
      foreign: id
      foreignType: one
      type: one