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

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:
    user_id: integer(11)
    phone: string(12)
  relations:
    User:
      foreignAlias: Phonenumbers


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