---
User:
  columns:
    username: string
    password: string(32)
    emailaddress: string(255)

-- Every user can have 1-many profiles
Profile:
  columns:
    prefix: string
    firstname: string
    middlename: string
    lastname: string
    user_id: integer
  relations:
    User:
      local: user_id
      onDelete: CASCADE

-- Every profile has 0-many address
Address:
  columns:
    profile_id: integer
    street: string
    number: string
    addition: string
    city: string
    provence: string
    country: string
  relations:
    Profile:
      local: profile_id
      onDelete: CASCADE