---
detect_relations: true

User:
  columns:
    username: string
    password: string(32)
    emailaddress: string(255)
  relations:
    Profile:
      local: id
      foreign: user_id

-- Every user can have 1-many profiles
Profile:
  columns:
    prefix: string
    firstname: string
    middlename: string
    lastname: string
    user_id: integer
  relations:
    User:
    Address:
      local: id
      foreign: profile_id

-- 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: