---
User:
  columns:
    id:
      primary: true
      autoincrement: true
      type: integer(4)
    username: string(255)
    password: string(255)
    email_id: integer(11)
  relations:
    Groups:
      class: Group
      refClass: UserGroup
      foreignAlias: Users
    Email:
      class: Email
      foreignType: one
    Phone:
      local: id
      foreign: owner_id
      type: many

Group:
  tableName: groups
  columns:
    id:
      primary: true
      autoincrement: true
      type: integer(4)
    name: string(255)

UserGroup:
  columns:
    user_id: integer(4)
    group_id: integer(4)
  relations:
    User:
      onDelete: CASCADE
    Group:
      onDelete: CASCADE

Email:
  columns:
    email: string(100)

Phone:
  columns:
    owner_id: integer(11)
    phone: string(12)
    areacode_id: integer(11)



GroupType:
  columns:
    typename: string(255)
    group_id: integer(11)
  relations:
    Group:
      foreignAlias: Grouptypes


AreaCode:
  columns:
    areacode: integer(3)
  relations:
    Phone:
      local: id
      foreign: areacode_id
      type: many