<?php

/**
 * This class has been auto-generated by the Doctrine ORM Framework
 */
abstract class BaseStatistic extends sfDoctrineRecord
{
    public function setTableDefinition()
    {
        $this->setTableName('statistic');
        $this->hasColumn('attachment_id', 'integer', null, array(
             'type' => 'integer',
             'primary' => true,
             ));
        $this->hasColumn('card_id', 'integer', 4, array(
             'type' => 'integer',
             'notnull' => true,
             'length' => '4',
             ));
        $this->hasColumn('supplier_id', 'integer', 4, array(
             'type' => 'integer',
             'notnull' => true,
             'length' => '4',
             ));
        $this->hasColumn('user_id', 'integer', 4, array(
             'type' => 'integer',
             'notnull' => true,
             'length' => '4',
             ));
        $this->hasColumn('user_first_name', 'string', 200, array(
             'type' => 'string',
             'length' => '200',
             ));
        $this->hasColumn('user_last_name', 'string', 200, array(
             'type' => 'string',
             'length' => '200',
             ));
        $this->hasColumn('contract_type', 'integer', 4, array(
             'type' => 'integer',
             'length' => '4',
             ));
        $this->hasColumn('supplier', 'string', 200, array(
             'type' => 'string',
             'length' => '200',
             ));
        $this->hasColumn('supplier_code', 'string', 200, array(
             'type' => 'string',
             'length' => '200',
             ));
        $this->hasColumn('client', 'string', 200, array(
             'type' => 'string',
             'length' => '200',
             ));
        $this->hasColumn('start_date', 'date', null, array(
             'type' => 'date',
             ));
        $this->hasColumn('end_date', 'date', null, array(
             'type' => 'date',
             ));
        $this->hasColumn('case_days', 'integer', 4, array(
             'type' => 'integer',
             'length' => '4',
             ));
        $this->hasColumn('state', 'string', 200, array(
             'type' => 'string',
             'length' => '200',
             ));
        $this->hasColumn('sum_supplier', 'decimal', 10, array(
             'type' => 'decimal',
             'scale' => '2',
             'length' => '10',
             ));
        $this->hasColumn('sum_payment', 'decimal', 10, array(
             'type' => 'decimal',
             'scale' => '2',
             'length' => '10',
             ));
        $this->hasColumn('case_penalty', 'decimal', 10, array(
             'type' => 'decimal',
             'scale' => '2',
             'length' => '10',
             ));
        $this->hasColumn('cert_taken', 'boolean', null, array(
             'type' => 'boolean',
             'default' => false,
             ));
        $this->hasColumn('case_income', 'decimal', 10, array(
             'type' => 'decimal',
             'scale' => '2',
             'length' => '10',
             ));
        $this->hasColumn('user_finished', 'boolean', null, array(
             'type' => 'boolean',
             ));

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

}