Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Newer
Older
100644 169 lines (159 sloc) 6.021 kB
c91080d Release 6.5.0
John Mertic authored
1 <?php
2 if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
3 /*********************************************************************************
4 * SugarCRM Community Edition is a customer relationship management program developed by
5 * SugarCRM, Inc. Copyright (C) 2004-2012 SugarCRM Inc.
6 *
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.
13 *
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
17 * details.
18 *
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
22 * 02110-1301 USA.
23 *
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.
26 *
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.
30 *
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 ********************************************************************************/
37
38 $dictionary['prospect_lists_prospects'] = array (
39
40 'table' => 'prospect_lists_prospects',
41
42 'fields' => array (
43 array (
44 'name' => 'id',
45 'type' => 'varchar',
46 'len' => '36',
47 ),
48 array (
49 'name' => 'prospect_list_id',
50 'type' => 'varchar',
51 'len' => '36',
52 ),
53 array (
54 'name' => 'related_id',
55 'type' => 'varchar',
56 'len' => '36',
57 ),
58 array (
59 'name' => 'related_type',
60 'type' => 'varchar',
61 'len' => '25', //valid values are Prospect, Contact, Lead, User
62 ),
63 array (
64 'name' => 'date_modified',
65 'type' => 'datetime'
66 ),
67 array (
68 'name' => 'deleted',
69 'type' => 'bool',
70 'len' => '1',
71 'default' => '0'
72 ),
73 ),
74
75 'indices' => array (
76 array (
77 'name' => 'prospect_lists_prospectspk',
78 'type' => 'primary',
79 'fields' => array ( 'id' )
80 ),
81 array (
82 'name' => 'idx_plp_pro_id',
83 'type' => 'index',
84 'fields' => array ('prospect_list_id')
85 ),
86 array (
87 'name' => 'idx_plp_rel_id',
88 'type' => 'alternate_key',
89 'fields' => array ( 'related_id',
90 'related_type',
91 'prospect_list_id'
92 )
93 ),
94 ),
95
96 'relationships' => array (
97 'prospect_list_contacts' => array( 'lhs_module'=> 'ProspectLists',
98 'lhs_table'=> 'prospect_lists',
99 'lhs_key' => 'id',
100 'rhs_module'=> 'Contacts',
101 'rhs_table'=> 'contacts',
102 'rhs_key' => 'id',
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'
109 ),
110
111 'prospect_list_prospects' =>array( 'lhs_module'=> 'ProspectLists',
112 'lhs_table'=> 'prospect_lists',
113 'lhs_key' => 'id',
114 'rhs_module'=> 'Prospects',
115 'rhs_table'=> 'prospects',
116 'rhs_key' => 'id',
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'
123 ),
124
125 'prospect_list_leads' =>array( 'lhs_module'=> 'ProspectLists',
126 'lhs_table'=> 'prospect_lists',
127 'lhs_key' => 'id',
128 'rhs_module'=> 'Leads',
129 'rhs_table'=> 'leads',
130 'rhs_key' => 'id',
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',
137 ),
138
139 'prospect_list_users' =>array( 'lhs_module'=> 'ProspectLists',
140 'lhs_table'=> 'prospect_lists',
141 'lhs_key' => 'id',
142 'rhs_module'=> 'Users',
143 'rhs_table'=> 'users',
144 'rhs_key' => 'id',
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',
151 ),
152
153 'prospect_list_accounts' =>array( 'lhs_module'=> 'ProspectLists',
154 'lhs_table'=> 'prospect_lists',
155 'lhs_key' => 'id',
156 'rhs_module'=> 'Accounts',
157 'rhs_table'=> 'accounts',
158 'rhs_key' => 'id',
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',
165 )
166 )
167
168 )
169 ?>
Something went wrong with that request. Please try again.