options:
  type: InnoDB
  collate: utf8_unicode_ci
  charset: utf8

Page:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
    parent_id:
      type: integer
      notnull: false
    region_id:
      type: integer
      notnull: false
    title:
      type: string(255)
      notnull: true
    description:
      type: clob
    content:
      type: clob
    can_edit:
      type: boolean
      default: 0
    can_delete:
      type: boolean
      default: 0
    can_subpage:
      type: boolean
      default: 0
    seq:
      type: integer
      default: 1000
  relations:
    Page:
      local: parent_id
      foreign: id
      foreignAlias: SubPages
    Region:
      local: region_id
      foreign: id
      foreignAlias: Pages
  actAs:
    Timestampable:
    Sluggable:
      fields: [ parent_id, title ]
      unique: true

Region:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
    title:
      type: string(255)
      notnull: true
    subtitle:
      type: string(255)
      notnull: true
  actAs:
    Timestampable:
    Sluggable:

Issue_region:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
    name:
      type: string(100)
      notnull: true
    region_id:
      type: integer
      notnull: true
    file_name:
      type: string(100)
  relations:
    Region:
      local: region_id
      foreign: id
  actAs:
    Timestampable:      

#
# Polls
#
Poll:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
    name:
      type: string(255)
      notnull: true
    description:
      type: clob
    is_published:
      type: boolean
      notnull: true
      default: false
  actAs:
    Timestampable:
Poll_answer:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
    poll_id:
      type: integer
    name:
      type: string(255)
      notnull: true
    answer_count:
      type: integer
      default: 0
    answer_last:
      type: timestamp
    seq:
      type: integer
      default: 10
  relations:
    Poll:
      local: poll_id
      foreign: id
      foreignAlias: Answers

Message:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
    name:
      type: string(255)
    phone:
      type: string(255)
    email:
      type: string(255)
    message:
      type: clob
  actAs:
    Timestampable: