<?php

/**
 * BaseJob
 * 
 * This class has been auto-generated by the Doctrine ORM Framework
 * 
 * @property integer $profile_id
 * @property integer $category_id
 * @property integer $type_id
 * @property integer $style_id
 * @property integer $country_id
 * @property string $name
 * @property string $city
 * @property string $street
 * @property integer $zip
 * @property clob $text
 * @property date $valid_from
 * @property integer $valid_months
 * @property date $valid_to
 * @property boolean $is_active
 * @property float $price
 * @property float $discount
 * @property integer $prepayment_rows
 * @property Profile $Profile
 * @property JobCategory $JobCategory
 * @property JobType $JobType
 * @property JobStyle $JobStyle
 * @property Country $Country
 * @property Doctrine_Collection $Specializations
 * @property Doctrine_Collection $Regions
 * @property TopJob $TopJob
 * @property Doctrine_Collection $JobSpecializationRelations
 * @property Doctrine_Collection $JobRegionRelations
 * @property Doctrine_Collection $InoiceItems
 * 
 * @method integer             getProfileId()                  Returns the current record's "profile_id" value
 * @method integer             getCategoryId()                 Returns the current record's "category_id" value
 * @method integer             getTypeId()                     Returns the current record's "type_id" value
 * @method integer             getStyleId()                    Returns the current record's "style_id" value
 * @method integer             getCountryId()                  Returns the current record's "country_id" value
 * @method string              getName()                       Returns the current record's "name" value
 * @method string              getCity()                       Returns the current record's "city" value
 * @method string              getStreet()                     Returns the current record's "street" value
 * @method integer             getZip()                        Returns the current record's "zip" value
 * @method clob                getText()                       Returns the current record's "text" value
 * @method date                getValidFrom()                  Returns the current record's "valid_from" value
 * @method integer             getValidMonths()                Returns the current record's "valid_months" value
 * @method date                getValidTo()                    Returns the current record's "valid_to" value
 * @method boolean             getIsActive()                   Returns the current record's "is_active" value
 * @method float               getPrice()                      Returns the current record's "price" value
 * @method float               getDiscount()                   Returns the current record's "discount" value
 * @method integer             getPrepaymentRows()             Returns the current record's "prepayment_rows" value
 * @method Profile             getProfile()                    Returns the current record's "Profile" value
 * @method JobCategory         getJobCategory()                Returns the current record's "JobCategory" value
 * @method JobType             getJobType()                    Returns the current record's "JobType" value
 * @method JobStyle            getJobStyle()                   Returns the current record's "JobStyle" value
 * @method Country             getCountry()                    Returns the current record's "Country" value
 * @method Doctrine_Collection getSpecializations()            Returns the current record's "Specializations" collection
 * @method Doctrine_Collection getRegions()                    Returns the current record's "Regions" collection
 * @method TopJob              getTopJob()                     Returns the current record's "TopJob" value
 * @method Doctrine_Collection getJobSpecializationRelations() Returns the current record's "JobSpecializationRelations" collection
 * @method Doctrine_Collection getJobRegionRelations()         Returns the current record's "JobRegionRelations" collection
 * @method Doctrine_Collection getInoiceItems()                Returns the current record's "InoiceItems" collection
 * @method Job                 setProfileId()                  Sets the current record's "profile_id" value
 * @method Job                 setCategoryId()                 Sets the current record's "category_id" value
 * @method Job                 setTypeId()                     Sets the current record's "type_id" value
 * @method Job                 setStyleId()                    Sets the current record's "style_id" value
 * @method Job                 setCountryId()                  Sets the current record's "country_id" value
 * @method Job                 setName()                       Sets the current record's "name" value
 * @method Job                 setCity()                       Sets the current record's "city" value
 * @method Job                 setStreet()                     Sets the current record's "street" value
 * @method Job                 setZip()                        Sets the current record's "zip" value
 * @method Job                 setText()                       Sets the current record's "text" value
 * @method Job                 setValidFrom()                  Sets the current record's "valid_from" value
 * @method Job                 setValidMonths()                Sets the current record's "valid_months" value
 * @method Job                 setValidTo()                    Sets the current record's "valid_to" value
 * @method Job                 setIsActive()                   Sets the current record's "is_active" value
 * @method Job                 setPrice()                      Sets the current record's "price" value
 * @method Job                 setDiscount()                   Sets the current record's "discount" value
 * @method Job                 setPrepaymentRows()             Sets the current record's "prepayment_rows" value
 * @method Job                 setProfile()                    Sets the current record's "Profile" value
 * @method Job                 setJobCategory()                Sets the current record's "JobCategory" value
 * @method Job                 setJobType()                    Sets the current record's "JobType" value
 * @method Job                 setJobStyle()                   Sets the current record's "JobStyle" value
 * @method Job                 setCountry()                    Sets the current record's "Country" value
 * @method Job                 setSpecializations()            Sets the current record's "Specializations" collection
 * @method Job                 setRegions()                    Sets the current record's "Regions" collection
 * @method Job                 setTopJob()                     Sets the current record's "TopJob" value
 * @method Job                 setJobSpecializationRelations() Sets the current record's "JobSpecializationRelations" collection
 * @method Job                 setJobRegionRelations()         Sets the current record's "JobRegionRelations" collection
 * @method Job                 setInoiceItems()                Sets the current record's "InoiceItems" collection
 * 
 * @package    Pharmalink - Inzerce
 * @subpackage model
 * @author     Tomas Naibrt <tomas@naibrt.cz>
 * @version    SVN: $Id: Builder.php 7490 2010-03-29 19:53:27Z jwage $
 */
abstract class BaseJob extends sfDoctrineRecord
{
    public function setTableDefinition()
    {
        $this->setTableName('job');
        $this->hasColumn('profile_id', 'integer', null, array(
             'type' => 'integer',
             'notnull' => false,
             ));
        $this->hasColumn('category_id', 'integer', null, array(
             'type' => 'integer',
             'notnull' => true,
             ));
        $this->hasColumn('type_id', 'integer', null, array(
             'type' => 'integer',
             'notnull' => true,
             ));
        $this->hasColumn('style_id', 'integer', null, array(
             'type' => 'integer',
             'notnull' => true,
             ));
        $this->hasColumn('country_id', 'integer', null, array(
             'type' => 'integer',
             'notnull' => true,
             ));
        $this->hasColumn('name', 'string', 255, array(
             'type' => 'string',
             'notnull' => true,
             'length' => 255,
             ));
        $this->hasColumn('city', 'string', 255, array(
             'type' => 'string',
             'notnull' => false,
             'length' => 255,
             ));
        $this->hasColumn('street', 'string', 255, array(
             'type' => 'string',
             'notnull' => false,
             'length' => 255,
             ));
        $this->hasColumn('zip', 'integer', null, array(
             'type' => 'integer',
             'notnull' => false,
             ));
        $this->hasColumn('text', 'clob', null, array(
             'type' => 'clob',
             ));
        $this->hasColumn('valid_from', 'date', null, array(
             'type' => 'date',
             'notnull' => true,
             ));
        $this->hasColumn('valid_months', 'integer', null, array(
             'type' => 'integer',
             'notnull' => true,
             'default' => 1,
             ));
        $this->hasColumn('valid_to', 'date', null, array(
             'type' => 'date',
             'notnull' => true,
             ));
        $this->hasColumn('is_active', 'boolean', null, array(
             'type' => 'boolean',
             'notnull' => true,
             'default' => false,
             ));
        $this->hasColumn('price', 'float', null, array(
             'type' => 'float',
             'notnull' => true,
             'default' => 0,
             ));
        $this->hasColumn('discount', 'float', null, array(
             'type' => 'float',
             'notnull' => true,
             'default' => 1,
             ));
        $this->hasColumn('prepayment_rows', 'integer', null, array(
             'type' => 'integer',
             'notnull' => true,
             'default' => 0,
             ));

        $this->option('collate', 'utf8_czech_ci');
        $this->option('charset', 'utf8');
    }

    public function setUp()
    {
        parent::setUp();
        $this->hasOne('Profile', array(
             'local' => 'profile_id',
             'foreign' => 'id',
             'onDelete' => 'CASCADE'));

        $this->hasOne('JobCategory', array(
             'local' => 'category_id',
             'foreign' => 'id',
             'onDelete' => 'CASCADE'));

        $this->hasOne('JobType', array(
             'local' => 'type_id',
             'foreign' => 'id',
             'onDelete' => 'CASCADE'));

        $this->hasOne('JobStyle', array(
             'local' => 'style_id',
             'foreign' => 'id',
             'onDelete' => 'CASCADE'));

        $this->hasOne('Country', array(
             'local' => 'country_id',
             'foreign' => 'id',
             'onDelete' => 'CASCADE'));

        $this->hasMany('JobSpecialization as Specializations', array(
             'refClass' => 'JobSpecializationRelation',
             'local' => 'job_id',
             'foreign' => 'specialization_id'));

        $this->hasMany('Region as Regions', array(
             'refClass' => 'JobRegionRelation',
             'local' => 'job_id',
             'foreign' => 'region_id'));

        $this->hasOne('TopJob', array(
             'local' => 'id',
             'foreign' => 'job_id'));

        $this->hasMany('JobSpecializationRelation as JobSpecializationRelations', array(
             'local' => 'id',
             'foreign' => 'job_id'));

        $this->hasMany('JobRegionRelation as JobRegionRelations', array(
             'local' => 'id',
             'foreign' => 'job_id'));

        $this->hasMany('InvoiceItem as InoiceItems', array(
             'local' => 'id',
             'foreign' => 'job_id'));

        $timestampable0 = new Doctrine_Template_Timestampable();
        $sluggable0 = new Doctrine_Template_Sluggable(array(
             'fields' => 
             array(
              0 => 'name',
             ),
             'unique' => true,
             'builder' => 
             array(
              0 => 'saInflector',
              1 => 'urlize',
             ),
             ));
        $this->actAs($timestampable0);
        $this->actAs($sluggable0);
    }
}