tasks_gathersmetadata.php

来自「开源的CRM,功能全面,国内最优秀的源码」· PHP 代码 · 共 29 行

<?php
/*********************************************************************************
 * Relationship definition for module and gather
 * Allows to relate specific gather to a module
 ********************************************************************************/
$dictionary['tasks_gathers'] = array (
	'table'  => 'tasks_gathers',
	'fields' => array (
  array('name'=> 'id',             'type'=> 'char','len'=> '36',  'required'=> true, 'default'=> '')
, array('name'=> 'task_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'=>'task_gatherpk',       'type'=>'primary',      'fields'=> array('id'))
, array('name'=>'idx_task_id',            'type'=>'index',        'fields'=> array('task_id'))
, array('name'=>'idx_gather_id',               'type'=>'index',        'fields'=> array('gather_id'))
, array('name'=>'idx_task_gather_ids', 'type'=>'alternate_key','fields'=> array('task_id','gather_id'))
 ) 
, 'relationships' => array (
   'tasks_gathers'  => array(
    'lhs_module'        => 'Tasks',    'lhs_table'=> 'tasks','lhs_key'=> 'id',
	   'rhs_module'        => 'Gathers', 'rhs_table'=> 'gathers',  'rhs_key'=> 'id',
	   'relationship_type' => 'many-to-many',
	   'join_table'        => 'tasks_gathers', 'join_key_lhs'=> 'task_id', 'join_key_rhs'=> 'gather_id'))
)
?>