notes_gathersmetadata.php

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

<?php
/*********************************************************************************
 * Relationship definition for module and gather
 * Allows to relate specific gather to a module
 ********************************************************************************/
$dictionary['notes_gathers'] = array (
	'table'  => 'notes_gathers',
	'fields' => array (
  array('name'=> 'id',             'type'=> 'char','len'=> '36',  'required'=> true, 'default'=> '')
, array('name'=> 'note_id','type'=> 'char', 'len'=> '36', 'required'=>  true)
, array('name'=> 'gather_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'=>'note_gatherpk',       'type'=>'primary',      'fields'=> array('id'))
, array('name'=>'idx_note_id',            'type'=>'index',        'fields'=> array('note_id'))
, array('name'=>'idx_gather_id',               'type'=>'index',        'fields'=> array('gather_id'))
, array('name'=>'idx_note_gather_ids', 'type'=>'alternate_key','fields'=> array('note_id','gather_id'))
 ) 
, 'relationships' => array (
   'notes_gathers'  => array(
    'lhs_module'        => 'Notes',    'lhs_table'=> 'notes','lhs_key'=> 'id',
	   'rhs_module'        => 'Gathers', 'rhs_table'=> 'gathers',  'rhs_key'=> 'id',
	   'relationship_type' => 'many-to-many',
	   'join_table'        => 'notes_gathers', 'join_key_lhs'=> 'note_id', 'join_key_rhs'=> 'gather_id'))
)
?>