User:
  columns:
    id:
      type: integer(10)
      primary: true
      autoincrement: true
    slug:
      type: string(64)
    username:
      type: string(64)
    password:
      type: string(64)
    email:
      type: string(64)
  indexes:
    username:
      fields: [username]
      type: unique
  actAs:
    Activation:
    Authorable:
    Timestampable:
    Sluggable:
      fields: [username]
      type: string
      length: 64
      unique: true
      canUpdate: true
  relations:
    UserProfile:
      type: one
      foreignType: one
    Created:
      class: User
      local: created_by
      foreign: id
      type: one
      foreignType: many
      foreignAlias: CreatedUsers
    Updated:
      class: User
      local: updated_by
      foreign: id
      type: one
      foreignType: many
      foreignAlias: UpdatedUsers
    Groups:
      class: Group
      local: user_id
      foreign: group_id
      refClass: UserGroup
      foreignAlias: Users
    Rights:
      class: Right
      local: user_id
      foreign: right_id
      refClass: UserRight
      foreignAlias: Users


UserProfile:
  columns:
    user_id:
      type: integer(10)
      primary: true
    first_name:
      type: string(255)
    last_name:
      type: string(255)