Account:
  tableName: account
  columns:
    id: integer(9)
    username: varchar(255) #name to display
    login: varchar(255) #name for log in (merge both ?)
    avatar: varchar(255) #name of the file
    password: varchar(255)
    credit: integer(9) #points
    level: tinyint(3) #0 = user, 1 = administrator
  relations:
    Maps: #posted
      class: Map
      local: id
      foreign: author_id
    Downloads: #downloaded maps
      class: Map
      local: downloader_id
      foreign: map_id
      refClass: AccountMap
Map:
  tableName: map
  columns:
    id: integer(9)
    author_id: integer(9)
    file: varchar(255) #the name of the file/of the screen (so without extension here)
    price: smallint(3) #the price (smallint = 32767)
  relations:
    Author:
      class: Account
      local: author_id
      foreign: id
    Downloaders:
      class: Account
      local: map_id
      foreign: downloader_id
      refClass: AccountMap
AccountMap:
  tableName: account_map
  columns:
    id: integer(9)
    map_id: integer(9)
    downloader_id: integer(9)