1: <?php
2:
3: namespace cli_db\propel\map;
4:
5: use \RelationMap;
6: use \TableMap;
7:
8:
9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20:
21: class AssayTableMap extends TableMap
22: {
23:
24: 25: 26:
27: const CLASS_NAME = 'cli_db.map.AssayTableMap';
28:
29: 30: 31: 32: 33: 34: 35:
36: public function initialize()
37: {
38:
39: $this->setName('assay');
40: $this->setPhpName('Assay');
41: $this->setClassname('cli_db\\propel\\Assay');
42: $this->setPackage('cli_db');
43: $this->setUseIdGenerator(true);
44: $this->setPrimaryKeyMethodInfo('assay_assay_id_seq');
45:
46: $this->addPrimaryKey('assay_id', 'AssayId', 'INTEGER', true, null, null);
47: $this->addColumn('arraydesign_id', 'ArraydesignId', 'INTEGER', true, null, null);
48: $this->addForeignKey('protocol_id', 'ProtocolId', 'INTEGER', 'protocol', 'protocol_id', false, null, null);
49: $this->addColumn('assaydate', 'Assaydate', 'TIMESTAMP', false, null, 'now()');
50: $this->addColumn('arrayidentifier', 'Arrayidentifier', 'LONGVARCHAR', false, null, null);
51: $this->addColumn('arraybatchidentifier', 'Arraybatchidentifier', 'LONGVARCHAR', false, null, null);
52: $this->addForeignKey('operator_id', 'OperatorId', 'INTEGER', 'contact', 'contact_id', true, null, null);
53: $this->addColumn('dbxref_id', 'DbxrefId', 'INTEGER', false, null, null);
54: $this->addColumn('name', 'Name', 'LONGVARCHAR', false, null, null);
55: $this->addColumn('description', 'Description', 'LONGVARCHAR', false, null, null);
56:
57: }
58:
59: 60: 61:
62: public function buildRelations()
63: {
64: $this->addRelation('Contact', 'cli_db\\propel\\Contact', RelationMap::MANY_TO_ONE, array('operator_id' => 'contact_id', ), 'CASCADE', null);
65: $this->addRelation('Protocol', 'cli_db\\propel\\Protocol', RelationMap::MANY_TO_ONE, array('protocol_id' => 'protocol_id', ), 'SET NULL', null);
66: $this->addRelation('Acquisition', 'cli_db\\propel\\Acquisition', RelationMap::ONE_TO_MANY, array('assay_id' => 'assay_id', ), 'CASCADE', null, 'Acquisitions');
67: $this->addRelation('AssayBiomaterial', 'cli_db\\propel\\AssayBiomaterial', RelationMap::ONE_TO_MANY, array('assay_id' => 'assay_id', ), 'CASCADE', null, 'AssayBiomaterials');
68: }
69:
70: }
71: