2 if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
3 /*********************************************************************************
4 * SugarCRM is a customer relationship management program developed by
5 * SugarCRM, Inc. Copyright (C) 2004-2011 SugarCRM Inc.
7 * This program is free software; you can redistribute it and/or modify it under
8 * the terms of the GNU Affero General Public License version 3 as published by the
9 * Free Software Foundation with the addition of the following permission added
10 * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
11 * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
12 * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
14 * This program is distributed in the hope that it will be useful, but WITHOUT
15 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
16 * FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
19 * You should have received a copy of the GNU Affero General Public License along with
20 * this program; if not, see http://www.gnu.org/licenses or write to the Free
21 * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
24 * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
25 * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
27 * The interactive user interfaces in modified source and object code versions
28 * of this program must display Appropriate Legal Notices, as required under
29 * Section 5 of the GNU Affero General Public License version 3.
31 * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
32 * these Appropriate Legal Notices must retain the display of the "Powered by
33 * SugarCRM" logo. If the display of the logo is not reasonably feasible for
34 * technical reasons, the Appropriate Legal Notices must display the words
35 * "Powered by SugarCRM".
36 ********************************************************************************/
38 $dictionary['prospect_lists_prospects'] = array (
40 'table' => 'prospect_lists_prospects',
49 'name' => 'prospect_list_id',
54 'name' => 'related_id',
59 'name' => 'related_type',
61 'len' => '25', //valid values are Prospect, Contact, Lead, User
64 'name' => 'date_modified',
77 'name' => 'prospect_lists_prospectspk',
79 'fields' => array ( 'id' )
82 'name' => 'idx_plp_pro_id',
84 'fields' => array ('prospect_list_id')
87 'name' => 'idx_plp_rel_id',
88 'type' => 'alternate_key',
89 'fields' => array ( 'related_id',
96 'relationships' => array (
97 'prospect_list_contacts' => array( 'lhs_module'=> 'ProspectLists',
98 'lhs_table'=> 'prospect_lists',
100 'rhs_module'=> 'Contacts',
101 'rhs_table'=> 'contacts',
103 'relationship_type'=>'many-to-many',
104 'join_table'=> 'prospect_lists_prospects',
105 'join_key_lhs'=>'prospect_list_id',
106 'join_key_rhs'=>'related_id',
107 'relationship_role_column'=>'related_type',
108 'relationship_role_column_value'=>'Contacts'
111 'prospect_list_prospects' =>array( 'lhs_module'=> 'ProspectLists',
112 'lhs_table'=> 'prospect_lists',
114 'rhs_module'=> 'Prospects',
115 'rhs_table'=> 'prospects',
117 'relationship_type'=>'many-to-many',
118 'join_table'=> 'prospect_lists_prospects',
119 'join_key_lhs'=>'prospect_list_id',
120 'join_key_rhs'=>'related_id',
121 'relationship_role_column'=>'related_type',
122 'relationship_role_column_value'=>'Prospects'
125 'prospect_list_leads' =>array( 'lhs_module'=> 'ProspectLists',
126 'lhs_table'=> 'prospect_lists',
128 'rhs_module'=> 'Leads',
129 'rhs_table'=> 'leads',
131 'relationship_type'=>'many-to-many',
132 'join_table'=> 'prospect_lists_prospects',
133 'join_key_lhs'=>'prospect_list_id',
134 'join_key_rhs'=>'related_id',
135 'relationship_role_column'=>'related_type',
136 'relationship_role_column_value'=>'Leads',
139 'prospect_list_users' =>array( 'lhs_module'=> 'ProspectLists',
140 'lhs_table'=> 'prospect_lists',
142 'rhs_module'=> 'Users',
143 'rhs_table'=> 'users',
145 'relationship_type'=>'many-to-many',
146 'join_table'=> 'prospect_lists_prospects',
147 'join_key_lhs'=>'prospect_list_id',
148 'join_key_rhs'=>'related_id',
149 'relationship_role_column'=>'related_type',
150 'relationship_role_column_value'=>'Users',
153 'prospect_list_accounts' =>array( 'lhs_module'=> 'ProspectLists',
154 'lhs_table'=> 'prospect_lists',
156 'rhs_module'=> 'Accounts',
157 'rhs_table'=> 'accounts',
159 'relationship_type'=>'many-to-many',
160 'join_table'=> 'prospect_lists_prospects',
161 'join_key_lhs'=>'prospect_list_id',
162 'join_key_rhs'=>'related_id',
163 'relationship_role_column'=>'related_type',
164 'relationship_role_column_value'=>'Accounts',