Category:
  actAs:
    NestedSet:
      hasManyRoots: true
      rootColumnName: root_id
  columns:
    title:
      type: string(150)
    description:
      type: string(255)
    position:
      type: integer(4)

Post:
   columns:
    id:
      type: integer(4)
      primary: true
    language_id:
      type: integer(4)
      primary: true
    language_code:
      type: string(3)
    author_id:
      type: integer(4)
    title:
      type: string(100)
    description:
      type: string(255)
    content:
      type: string(3000)
    status:
      type: enum
      values: [published, private, pending, inherit]
    page_type:
      type: enum
      values: [active, revision]
    position:
      type: integer(4)
    date_added:
      type: timestamp
      format: Y-m-d H:i:s
   relations:
    Language:
      class: Language
      local: language_id
      foreign: id
      foreignAlias: postLanguage
    Categories:
      class: Category
      local: post_id
      foreign: category_id
      foreignAlias: Posts
      refClass: PostCategoryXref

PostCategoryXref:
  columns:
    post_id:
      type: integer(4)
    category_id:
      type: integer
  relations:
    Post:
      local: post_id
      foreign: id
      onDelete: CASCADE
    Category:
      local: category_id
      foreign: id
      onDelete: CASCADE