---
propel: 
  _attributes: 
    package: lib.model
  advertisements: 
    _attributes: { phpName: Advertisement } 
      idMethod: native
    id: 
      type: INTEGER
      required: true
      autoIncrement: true
      primaryKey: true
    name: 
      type: VARCHAR
      size: 255
      required: true
      default: 
    email: 
      type: VARCHAR
      size: 255
      required: true
      default: 
    secret: 
      type: VARCHAR
      size: 255
      required: true
      default: 
    title: 
      type: VARCHAR
      size: 255
      required: true
      default: 
    body: 
      type: LONGVARCHAR
      required: true
    ad_status: 
      type: TINYINT
      required: true
      default: 0
    price: 
      type: INTEGER
      required: true
      default: 0
    created: 
      type: TIMESTAMP
    modified: 
      type: TIMESTAMP
    brand: 
      type: VARCHAR
      size: 255
      foreignTable: brands
      foreignReference: brand_name
    category: 
      type: VARCHAR
      size: 255
      foreignTable: types
      foreignReference: ad_type      
    contact: 
      type: VARCHAR
      size: 255
    hit: 
      type: INTEGER
    ad_type: 
      type: VARCHAR
      size: 100
  attachments: 
    _attributes: { phpName: Attachment } 
      idMethod: native
    id: 
      type: INTEGER
      required: true
      autoIncrement: true
      primaryKey: true
    advertisement_id: 
      type: INTEGER
      required: true
      foreignTable: advertisements
      foreignReference: id
      cascade: ondelete
    name: 
      type: VARCHAR
      size: 255
      required: true
      default: 
    type: 
      type: VARCHAR
      size: 255
      required: true
      default: 
    size: 
      type: INTEGER
      required: true
      default: 0
    bin: 
      type: VARBINARY
      required: true
    modified: 
      type: TIMESTAMP
    created: 
      type: TIMESTAMP
  brands: 
    _attributes: { phpName: AdBrand } 
      idMethod: native
    id: 
      type: INTEGER
      required: true
      autoIncrement: true
      primaryKey: true
    brand_name: 
      type: VARCHAR
      size: 255
      required: true
      default: 
  emails: 
    _attributes: { phpName: Email }
      idMethod: native
    id: 
      type: INTEGER
      required: true
      autoIncrement: true
      primaryKey: true
    advertisement_id: 
      type: INTEGER
      required: true
      default: 0
    ip: 
      type: VARCHAR
      size: 255
      required: true
      default: 
    email_from: 
      type: VARCHAR
      size: 255
      required: true
      default: 
    email_to: 
      type: VARCHAR
      size: 255
      required: true
      default: 
    created: 
      type: TIMESTAMP
    modified: 
      type: TIMESTAMP
  sections: 
    _attributes: { phpName: Section }
      idMethod: native
    id: 
      type: INTEGER
      required: true
      autoIncrement: true
      primaryKey: true
    name: 
      type: VARCHAR
      size: 255
      required: true
      default: 
    parent_id: 
      type: INTEGER
      required: true
      default: 0
  statuses: 
    _attributes: 
      idMethod: native
    id: 
      type: INTEGER
      required: true
      autoIncrement: true
      primaryKey: true
    status: 
      type: VARCHAR
      size: 255
      required: true
      default: 
  trackings: 
    _attributes: { phpName: Tracking } 
      idMethod: native
    id: 
      type: INTEGER
      required: true
      autoIncrement: true
      primaryKey: true
    ip: 
      type: VARCHAR
      size: 255
      required: true
      default: 
    advertisement_id: 
      type: INTEGER
    action: 
      type: LONGVARCHAR
      required: true
    url: 
      type: VARCHAR
      size: 255
      required: true
      default: 
    created: 
      type: TIMESTAMP
    referer: 
      type: VARCHAR
      size: 255
  types: 
    _attributes: { phpName: Type } 
      idMethod: native
    id: 
      type: INTEGER
      required: true
      autoIncrement: true
      primaryKey: true
    ad_type: 
      type: VARCHAR
      size: 255