options:
  type: InnoDB
  collate: utf8_unicode_ci
  charset: utf8

Category:
  columns:
    id:          { type: integer, primary: true, autoincrement: true }
    name:        { type: string(255), notnull: true }
    description: { type: clob }
    image:       { type: string(255) }
  actAs:
    Sluggable:
    Timestampable:
    Auditable:
      user_id:
        expression:
          symfony_context:  "getUser()->getAttribute('user')->id"
    Archivable:
      expression:
        symfony_context:  "getUser()->getAttribute('archive_level')"
    Sortable:


Author:
  columns:
    id:          { type: integer, primary: true, autoincrement: true }
    name:        { type: string(255),notnull: true }
    description: { type: clob }

Kind:
  columns:
    id:          { type: integer, primary: true, autoincrement: true }
    name:        { type: string(255),notnull: true }

Item:
  columns:
    id:          { type: integer, primary: true, autoincrement: true }
    category_id: { type: integer  }
    author_id:   { type: integer }
    kind_id:    { type: integer }
    name:        { type: string(255),notnull: true }
    description: { type: clob }
    image:       { type: string(255) }
    code:        { type: string(255) }
    year:        { type: string(4)   }
    size:        { type: string(255) }
    price_start:
      type: decimal(10,2)
      notnull: true
    price_actual:
      type: decimal(10,2)
    price_bid:
      type: decimal(10,2)
      notnull: true
    is_published:
      type: boolean
      default: 0
    time_start:    { type: timestamp }
    time_end:    { type: timestamp }
    continuation: { type: boolean }
    is_finished:   { type: boolean }
    status: { type: integer  }
  relations:
    Category: { local: category_id, foreign: id, foreignAlias: Items }
    Author: { local: author_id, foreign: id, foreignAlias: Items }
    Kind: { local: kind_id, foreign: id, foreignAlias: Items }
  actAs:
    Sluggable:
    Timestampable:
    Auditable:
      user_id:
        expression:
          symfony_context:  "getUser()->getAttribute('user')->id"
    Archivable:
      expression:
        symfony_context:  "getUser()->getAttribute('archive_level')"

User:
  columns:
    id:          { type: integer, primary: true, autoincrement: true }
    email:       { type: string(255),notnull: true,unique: true }
    password:    { type: string(255),notnull: true }
    name:        { type: string(255),notnull: true }
    street:      { type: string(255),notnull: true }
    city:        { type: string(255),notnull: true }
    zip:         { type: string(255),notnull: true }
    state:       { type: string(255),notnull: true }
    tel:         { type: string(255),notnull: true }
    is_admin:    { type: boolean, default: false }

Bid:
  columns:
    id:          { type: integer, primary: true, autoincrement: true }
    user_id:     { type: integer }
    item_id:     { type: integer }
    price_bid:
      type: decimal(10, 2)
    time_bid:        { type: timestamp, notnull: true }
  relations:
    Item: { local: item_id, foreign: id, foreignAlias: Bids }
    User: { local: user_id, foreign: id, foreignAlias: Bids }
    
Bid_limit:
  columns:
    id:          { type: integer, primary: true, autoincrement: true }
    user_id:     { type: integer }
    item_id:     { type: integer }
    price_bid:
      type: decimal(10,2)
  relations:
    Item: { local: item_id, foreign: id, foreignAlias: Bids }
    User: { local: user_id, foreign: id, foreignAlias: Bids }

Page:
  columns:
    id:          { type: integer, primary: true, autoincrement: true }
    page_id: { type: integer  }
    name:        { type: string(255),notnull: true }
    content: { type: clob }
    in_menu: { type: boolean, default: true }
  relations:
    Page:
      local: page_id
      foreign: id
      foreignAlias: SubPages }
  actAs:
    Sluggable:
    Timestampable:
    Auditable:
      user_id:
        expression:
          symfony_context:  "getUser()->getAttribute('user')->id"
    Sortable:
      uniqueBy: [ page_id ]