<?php
Doctrine_Manager::getInstance()->bindComponent('CBR_COMITE_FICHA', 'doctrine');
/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

/**
 * Description of BaseCBR_COMITE_FICHA
 *
 * @author Manuel Enrique Paredes Lopez
 */
abstract class BaseCBR_COMITE_FICHA extends sfDoctrineRecord {
    
     public function setTableDefinition()
    {
        $this->setTableName('CBR_COMITE_FICHA');
        $this->hasColumn('id_comite_ficha', 'integer', 20, array(
             'type' => 'integer',
             'fixed' => 0,
             'unsigned' => false,
             'primary' => true,
             'length' => 20,
             ));
        $this->hasColumn('id_comite_cartera', 'integer', 20, array(
             'notnull' => true,
             'type' => 'integer',
             'fixed' => 0,
             'unsigned' => false,
             'primary' => false,
             'length' => 20,
             ));
        $this->hasColumn('no_ficha', 'string', 20, array(
             'notnull' => false,
             'type' => 'string',
             'fixed' => 0,
             'unsigned' => false,
             'primary' => false,
             'length' => 20,
             ));
        $this->hasColumn('fecha_ficha', 'timestamp', 7, array(
             'notnull' => true,
             'type' => 'timestamp',
             'fixed' => 0,
             'unsigned' => false,
             'primary' => false,
             'length' => 7,
             ));
        $this->hasColumn('detalle_plantilla', 'clob', 4000, array(
             'notnull' => true,
             'type' => 'clob',
             'fixed' => 0,
             'unsigned' => false,
             'primary' => false,
             'length' => 4000,
             ));
        $this->hasColumn('observaciones', 'string', 2000, array(
             'notnull' => false,
             'type' => 'string',
             'fixed' => 0,
             'unsigned' => false,
             'primary' => false,
             'length' => 2000,
             ));
        $this->hasColumn('adjunto', 'string', 150, array(
             'notnull' => false,
             'type' => 'string',
             'fixed' => 0,
             'unsigned' => false,
             'primary' => false,
             'length' => 150,
             ));
        $this->hasColumn('id_plantilla', 'integer', 20, array(
             'notnull' => false,
             'type' => 'integer',
             'fixed' => 0,
             'unsigned' => false,
             'primary' => false,
             'length' => 20,
             ));
        $this->hasColumn('fecha_log', 'timestamp', 7, array(
             'notnull' => true,
             'type' => 'timestamp',
             'fixed' => 0,
             'unsigned' => false,
             'primary' => false,
             'length' => 7,
             )); 
        $this->hasColumn('usuario_log', 'integer', 20, array(
             'notnull' => true,
             'type' => 'integer',
             'fixed' => 0,
             'unsigned' => false,
             'primary' => false,
             'length' => 20,
             ));     
    }
    
    
     public function setUp()
    {
         parent::setUp();
         $this->hasOne('CBR_COMITE_CARTERA', array(
             'local' => 'id_comite_cartera',
             'foreign' => 'id_comite_cartera'));
         $this->hasOne('CBR_PLANTILLA', array(
             'local' => 'id_plantilla',
             'foreign' => 'id_plantilla'));
         
         
    }
    
    
}
