1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90
| abstract class BaseNUANCE extends sfDoctrineRecord
{
public function setTableDefinition()
{
$this->setTableName('NUANCE');
$this->hasColumn('nu_nuance', 'string', 3, array(
'type' => 'string',
'fixed' => 0,
'unsigned' => false,
'primary' => true,
'length' => 3,
));
$this->hasColumn('nu_abrnom', 'string', 6, array(
'notnull' => false,
'type' => 'string',
'fixed' => 0,
'unsigned' => false,
'primary' => false,
'length' => 6,
));
$this->hasColumn('nu_nom', 'string', 20, array(
'notnull' => false,
'type' => 'string',
'fixed' => 0,
'unsigned' => false,
'primary' => false,
'length' => 20,
));
$this->hasColumn('nu_obsolet', 'string', 1, array(
'notnull' => false,
'type' => 'string',
'fixed' => 0,
'unsigned' => false,
'primary' => false,
'length' => 1,
));
$this->hasColumn('nu_datobsol', 'timestamp', 7, array(
'notnull' => false,
'type' => 'timestamp',
'fixed' => 0,
'unsigned' => false,
'primary' => false,
'length' => 7,
));
$this->hasColumn('nu_crittri', 'integer', 5, array(
'notnull' => false,
'type' => 'integer',
'fixed' => 0,
'unsigned' => false,
'primary' => false,
'length' => 5,
));
$this->hasColumn('nu_coeff', 'decimal', 3, array(
'notnull' => false,
'type' => 'decimal',
'fixed' => 0,
'unsigned' => false,
'primary' => false,
'length' => 3,
));
$this->hasColumn('nu_coeff2', 'decimal', 3, array(
'notnull' => false,
'type' => 'decimal',
'fixed' => 0,
'unsigned' => false,
'primary' => false,
'length' => 3,
));
}
public function setUp()
{
parent::setUp();
$this->hasMany('ECHANTILLON', array(
'local' => 'nu_nuance',
'foreign' => 'nu_nuance2'));
$this->hasMany('ECHANTILLON as ECHANTILLON_18', array(
'local' => 'nu_nuance',
'foreign' => 'nu_nuance3'));
$this->hasMany('ECHANTILLON as ECHANTILLON_19', array(
'local' => 'nu_nuance',
'foreign' => 'nu_nuance'));
$this->hasMany('JUG_NUANCE', array(
'local' => 'nu_nuance',
'foreign' => 'nu_nuance'));
}
} |
Partager