Elep

<?php
/*
 * Your installation or use of this SugarCRM file is subject to the applicable
 * terms available at
 * http://support.sugarcrm.com/Resources/Master_Subscription_Agreements/.
 * If you do not agree to all of the applicable terms or do not have the
 * authority to bind the entity as an authorized representative, then do not
 * install or use this SugarCRM file.
 *
 * Copyright (C) SugarCRM Inc. All rights reserved.
 */
$dictionary['WorkFlowAlert'] = array('table' => 'workflow_alerts'
                               ,'fields' => array (
  'id' => 
  array (
    'name' => 'id',
    'vname' => 'LBL_NAME',
    'type' => 'id',
    'required' => true,
    'reportable'=>false,
  ),
   'deleted' => 
  array (
    'name' => 'deleted',
    'vname' => 'LBL_DELETED',
    'type' => 'bool',
    'required' => false,
    'default' => '0',
    'reportable'=>false,
  ),
   'date_entered' => 
  array (
    'name' => 'date_entered',
    'vname' => 'LBL_DATE_ENTERED',
    'type' => 'datetime',
    'required' => true,
  ),
  'date_modified' => 
  array (
    'name' => 'date_modified',
    'vname' => 'LBL_DATE_MODIFIED',
    'type' => 'datetime',
    'required' => true,
  ),
    'modified_user_id' => 
  array (
    'name' => 'modified_user_id',
    'rname' => 'user_name',
    'id_name' => 'modified_user_id',
    'vname' => 'LBL_ASSIGNED_TO',
    'type' => 'assigned_user_name',
    'table' => 'users',
    'isnull' => 'false',
    'dbType' => 'id',
    'reportable'=>true,
  ),
  'created_by' => 
  array (
    'name' => 'created_by',
    'rname' => 'user_name',
    'id_name' => 'modified_user_id',
    'vname' => 'LBL_ASSIGNED_TO',
    'type' => 'assigned_user_name',
    'table' => 'users',
    'isnull' => 'false',
    'dbType' => 'id'
  ),
    'field_value' => 
  array (
    'name' => 'field_value',
    'vname' => 'LBL_FIELD_VALUE',
    'type' => 'varchar',
    'len' => '50',
  ),
   'rel_email_value' => 
  array (
    'name' => 'rel_email_value',
    'vname' => 'LBL_REL_EMAIL_VALUE',
    'type' => 'varchar',
    'len' => '50',
  ),
    'rel_module1' => 
  array (
    'name' => 'rel_module1',
    'vname' => 'LBL_REL_MODULE1',
    'type' => 'varchar',
    'len' => '255',
    'required' => false,
  ),
    'rel_module2' => 
  array (
    'name' => 'rel_module2',
    'vname' => 'LBL_REL_MODULE2',
    'type' => 'varchar',
    'len' => '255',
    'required' => false,
  ),
      'rel_module1_type' => 
  array (
    'name' => 'rel_module1_type',
    'vname' => 'LBL_RELATED_TYPE',
    'type' => 'enum',
    'options' => 'wflow_rel_type_dom',
    'len'=>10,
  ),
      'rel_module2_type' => 
  array (
    'name' => 'rel_module2_type',
    'vname' => 'LBL_RELATED_TYPE',
    'type' => 'enum',
    'options' => 'wflow_rel_type_dom',
    'len'=>10,
  ),
   'where_filter' => 
  array (
    'name' => 'where_filter',
    'vname' => 'LBL_WHERE_FILTER',
    'type' => 'bool',
    'default' => '0',
  ),
  'user_type' => 
  array (
    'name' => 'user_type',
    'vname' => 'LBL_USER_TYPE',
    'type' => 'enum',
    'required' => true,
    'options' => 'wflow_user_type_dom',
    'len' => 100,
  ),
    'array_type' => 
  array (
    'name' => 'array_type',
    'vname' => 'LBL_ARRAY_TYPE',
    'type' => 'enum',
    'required' => false,
    'options' => 'wflow_array_type_dom',
    'len' => 100,
  ),
    'relate_type' => 
  array (
    'name' => 'relate_type',
    'vname' => 'LBL_RELATE_TYPE',
    'type' => 'enum',
    'required' => false,
    'options' => 'wflow_relate_type_dom',
    'len' => 100,
  ),
    'address_type' => 
  array (
    'name' => 'address_type',
    'vname' => 'LBL_ADDRESS_TYPE',
    'type' => 'enum',
    'required' => false,
    'options' => 'wflow_address_type_dom',
    'len' => 100,
  ),
  	'expressions' => 
  array (
  	'name' => 'expressions',
    'type' => 'link',
    'relationship' => 'expressions',
    'module'=>'Expressions',
    'bean_name'=>'Expression',
    'source'=>'non-db',
  ),
    'parent_id' => 
 	array (
    'name' => 'parent_id',
    'type' => 'id',
    'required' => true,
    'reportable'=>false,
  ),
  'user_display_type' => 
  array (
    'name' => 'user_display_type',
    'vname' => 'LBL_USER_DISPLAY_TYPE',
    'type' => 'enum',
    'required' => false,
    'options' => 'wflow_user_display_type_dom',
    'len' => 100,
  ),  
     'rel1_alert_fil' => 
  array (
  	'name' => 'rel1_alert_fil',
    'type' => 'link',
    'relationship' => 'rel1_alert_fil',
    'module'=>'Expressions',
    'bean_name'=>'Expression',
    'source'=>'non-db',
  ),
     'rel2_alert_fil' => 
  array (
  	'name' => 'rel2_alert_fil',
    'type' => 'link',
    'relationship' => 'rel2_alert_fil',
    'module'=>'Expressions',
    'bean_name'=>'Expression',
    'source'=>'non-db',
  ),    
),
'acls' => array('SugarACLDeveloperOrAdmin' => true),
'indices' => array (
       array('name' =>'workflowalerts_k', 'type' =>'primary', 'fields'=>array('id')),
                                                      )

, 'relationships' => array (
		'expressions' => array('lhs_module'=> 'WorkFlowAlerts', 'lhs_table'=> 'workflow_alerts', 'lhs_key' => 'id',
							  'rhs_module'=> 'Expressions', 'rhs_table'=> 'expressions', 'rhs_key' => 'parent_id',	
							  'relationship_role_column'=>'parent_type',
							  'relationship_role_column_value'=>'filter','relationship_type'=>'one-to-many')	
	
	,'rel1_alert_fil' => array('lhs_module'=> 'WorkFlowAlerts', 'lhs_table'=> 'workflow_alerts', 'lhs_key' => 'id',
							  'rhs_module'=> 'Expressions', 'rhs_table'=> 'expressions', 'rhs_key' => 'parent_id',	
							  'relationship_role_column'=>'parent_type',
							  'relationship_role_column_value'=>'rel1_alert_fil', 'relationship_type'=>'one-to-many')
							  							  							  	                                                    
	,'rel2_alert_fil' => array('lhs_module'=> 'WorkFlowAlerts', 'lhs_table'=> 'workflow_alerts', 'lhs_key' => 'id',
							  'rhs_module'=> 'Expressions', 'rhs_table'=> 'expressions', 'rhs_key' => 'parent_id',	
							  'relationship_role_column'=>'parent_type',
							  'relationship_role_column_value'=>'rel2_alert_fil', 'relationship_type'=>'one-to-many')							  							  	
	),
                                                      
                            );