UserModel:
  columns:
    id:
      primary: true
      type: integer
      autoincrement: true
    username:
      type: string
      unique: true
    password: string(40)
    salt: string(16)
    emailaddress:
      type: string(255)
      email:
        check_mx: false
    relations:
      Clients:
        local: user_id
        foreign: client_id
        refClass: ClientUser
Client:
  columns:
    id:
      primary: true
      type: integer
      autoincrement: true
    licencenumber:
      type: string(16)
      unique: true
    relationnumber:
      type: string(16)
      unique: true
  relations:
    Users:
      local: client_id
      foreign: user_id
      foreignAlias: Clients
      class: UserModel
      refClass: ClientUser

ClientUser:
  columns:
    client_id:
      type: integer
      primary: true
    user_id:
      type: integer
      primary: true