metadata.php

开源的CRM,功能全面,国内最优秀的源码

<?php
/*********************************************************************************
 * Relationship definition for module and SimpleObj
 * Allows to relate specific SimpleObj to a module
 ********************************************************************************/
$dictionary['Module_SimpleMod'] = array (
	'table'  => 'Module_SimpleMod',
	'fields' => array (
  array('name'=> 'id',             'type'=> 'char','len'=> '36',  'required'=> true, 'default'=> '')
, array('name'=> 'subpanelBean_id','type'=> 'char', 'len'=> '36', 'required'=>  true)
, array('name'=> 'SimpleObj_id',   'type'=> 'char', 'len'=> '36', 'required'=>  true)
, array('name'=> 'date_modified',  'type'=> 'datetime',           'required'=>  true)
, array('name'=> 'deleted',        'type'=> 'bool', 'len'=> '1',  'required'=>  true, 'default'=> '0')
),
 'indices' => array (
  array('name'=>'subpanelBean_SimpleObjpk',       'type'=>'primary',      'fields'=> array('id'))
, array('name'=>'idx_subpanelBean_id',            'type'=>'index',        'fields'=> array('subpanelBean_id'))
, array('name'=>'idx_SimpleObj_id',               'type'=>'index',        'fields'=> array('SimpleObj_id'))
, array('name'=>'idx_subpanelBean_SimpleObj_ids', 'type'=>'alternate_key','fields'=> array('subpanelBean_id','SimpleObj_id'))
 ) 
, 'relationships' => array (
   'Module_SimpleMod'  => array(
    'lhs_module'        => 'ModuleUp',    'lhs_table'=> 'subpanel_table','lhs_key'=> 'id',
	   'rhs_module'        => 'SimpleModUp', 'rhs_table'=> 'simple_table',  'rhs_key'=> 'id',
	   'relationship_type' => 'many-to-many',
	   'join_table'        => 'Module_SimpleMod', 'join_key_lhs'=> 'subpanelBean_id', 'join_key_rhs'=> 'SimpleObj_id'))
)
?>