Number:
  tableName: numbers
  columns:
    number: string(20)
    countrycode:
      type: string(3)
      default: '1'
Phonenumber:
  tableName: phonenumbers
  columns:
    name: string(20)
    number_id: integer(9)
  relations:
    Number:
      class: Number
      local: number_id
      foreign: id
      foreignAlias: Number
      foreignType: one
      type: one

Category:
  tableName: Categories
  columns:
    name: string(50)
BlogCategory:
  tableName: BlogCategories
  columns:
    blog_id: integer
    category_id: integer
Blog:
  tableName: Blogs
  columns:
    title: string(100)
    subtitle: string(100)
    entry: string
    author_id: integer
    pubDate:
      type: timestamp(25)
      notnull: true
    slug: string(100)
  relations:
    User:
      class: User
      local: author_id
      foreign: id
      foreignAlias: User
      foreignType: one
      type: one
    Categories:
      refClass: BlogCategory
      class: Category
      foreignAlias: Blogs
Credential:
  tableName: Credentials
  columns:
    admin:
      type: enum(1)
      values: ['1', '0']
      default: '0'
      notnull: true
    name: string(50)
UserCredential:
  tableName: UserCredentials
  columns:
    user_id: integer
    credential_id: integer
User:
  tableName: Users
  columns:
    firstname:
      type: string(50)
      default: ''
      notnull: true
    lastname:
      type: string(50)
      default: ''
      notnull: true
    email:
      type: string(50)
      default: ''
      notnull: true
    address:
      type: string(50)
      default: ''
      notnull: true
    address2:
      type: string(50)
      default: ''
    state:
      type: string(2)
      default: ''
      notnull: true
    country:
      type: string(2)
      default: ''
      notnull: true
    zip:
      type: string(10)
      default: ''
      notnull: true
    gender:
      type: enum(1)
      values: [m, f]
      default: m
      notnull: true
    logincounter:
      type: integer(3)
      unsigned: '1'
      default: '0'
      notnull: true
    predefined_skin:
      type: integer(3)
      unsigned: '1'
      default: '1'
      notnull: true
    is_listed:
      type: integer(3)
      unsigned: '1'
      default: '1'
      notnull: true
    ispending:
      type: integer(3)
      unsigned: '1'
      default: '1'
      notnull: true
    number_id:
      type: integer(3)
      notnull: true
    sync:
      type: integer(3)
      unsigned: '1'
      default: '0'
      notnull: true
    last_update:
      type: timestamp(25)
      notnull: true
    ais_listed:
      type: integer(4)
      default: '0'
      notnull: true
    pis_listed:
      type: integer(4)
      default: '0'
      notnull: true
    password: string(100)
    username: string(30)
    dob: timestamp(25)
    pic: string(70)
    description: string(2147483647)
    title: string(10)
    city: string(50)
    webaddress: string(96)
    shelbyid: integer(4)
    registrationdate: timestamp(25)
    lastlogin: timestamp(25)
    slug: string(255)
  relations:
    Phonenumber:
      class: Phonenumber
      local: number_id
      foreign: id
      foreignAlias: Phonenumber
      foreignType: one
      type: one
    Credentials:
      refClass: UserCredential
      class: Credential
      foreignAlias: Users