132 lines
9.7 KiB
PHP
132 lines
9.7 KiB
PHP
<?php
|
|
$dictionary['securitygroups_records'] = array(
|
|
'table' => 'securitygroups_records',
|
|
'fields' => array(
|
|
array('name' =>'id', 'type' =>'char', 'len'=>'36', 'required'=>true, 'default'=>'')
|
|
, array('name' =>'securitygroup_id', 'type' =>'char', 'len'=>'36')
|
|
, array('name' =>'record_id', 'type' =>'char', 'len'=>'36')
|
|
, array('name' =>'module', 'type' =>'varchar', 'len'=>'100')
|
|
, array('name' =>'date_modified','type' => 'datetime')
|
|
, array('name' =>'modified_user_id', 'type' =>'char', 'len'=>'36')
|
|
, array('name' =>'created_by', 'type' =>'char', 'len'=>'36')
|
|
, array('name' =>'deleted', 'type' =>'bool', 'len'=>'1', 'required'=>true, 'default'=>'0')
|
|
),
|
|
'indices' => array(
|
|
array('name' =>'securitygroups_recordspk', 'type' =>'primary', 'fields'=>array('id')),
|
|
array('name' =>'idx_securitygroups_records_mod', 'type' =>'index', 'fields'=>array( 'module', 'deleted', 'record_id', 'securitygroup_id')),
|
|
array('name' =>'idx_securitygroups_records_del', 'type' =>'index', 'fields'=>array( 'deleted', 'record_id', 'module', 'securitygroup_id')),
|
|
),
|
|
'relationships' => array(
|
|
|
|
'securitygroups_accounts' => array(
|
|
'lhs_module'=> 'SecurityGroups', 'lhs_table'=> 'securitygroups', 'lhs_key' => 'id',
|
|
'rhs_module'=> 'Accounts', 'rhs_table'=> 'accounts', 'rhs_key' => 'id',
|
|
'relationship_type'=>'many-to-many',
|
|
'join_table'=> 'securitygroups_records', 'join_key_lhs'=>'securitygroup_id', 'join_key_rhs'=>'record_id',
|
|
'relationship_role_column'=>'module','relationship_role_column_value'=>'Accounts'),
|
|
'securitygroups_bugs' => array(
|
|
'lhs_module'=> 'SecurityGroups', 'lhs_table'=> 'securitygroups', 'lhs_key' => 'id',
|
|
'rhs_module'=> 'Bugs', 'rhs_table'=> 'bugs', 'rhs_key' => 'id',
|
|
'relationship_type'=>'many-to-many',
|
|
'join_table'=> 'securitygroups_records', 'join_key_lhs'=>'securitygroup_id', 'join_key_rhs'=>'record_id',
|
|
'relationship_role_column'=>'module','relationship_role_column_value'=>'Bugs'),
|
|
'securitygroups_calls' => array(
|
|
'lhs_module'=> 'SecurityGroups', 'lhs_table'=> 'securitygroups', 'lhs_key' => 'id',
|
|
'rhs_module'=> 'Calls', 'rhs_table'=> 'calls', 'rhs_key' => 'id',
|
|
'relationship_type'=>'many-to-many',
|
|
'join_table'=> 'securitygroups_records', 'join_key_lhs'=>'securitygroup_id', 'join_key_rhs'=>'record_id',
|
|
'relationship_role_column'=>'module','relationship_role_column_value'=>'Calls'),
|
|
'securitygroups_campaigns' => array(
|
|
'lhs_module'=> 'SecurityGroups', 'lhs_table'=> 'securitygroups', 'lhs_key' => 'id',
|
|
'rhs_module'=> 'Campaigns', 'rhs_table'=> 'campaigns', 'rhs_key' => 'id',
|
|
'relationship_type'=>'many-to-many',
|
|
'join_table'=> 'securitygroups_records', 'join_key_lhs'=>'securitygroup_id', 'join_key_rhs'=>'record_id',
|
|
'relationship_role_column'=>'module','relationship_role_column_value'=>'Campaigns'),
|
|
'securitygroups_cases' => array(
|
|
'lhs_module'=> 'SecurityGroups', 'lhs_table'=> 'securitygroups', 'lhs_key' => 'id',
|
|
'rhs_module'=> 'Cases', 'rhs_table'=> 'cases', 'rhs_key' => 'id',
|
|
'relationship_type'=>'many-to-many',
|
|
'join_table'=> 'securitygroups_records', 'join_key_lhs'=>'securitygroup_id', 'join_key_rhs'=>'record_id',
|
|
'relationship_role_column'=>'module','relationship_role_column_value'=>'Cases'),
|
|
'securitygroups_contacts' => array(
|
|
'lhs_module'=> 'SecurityGroups', 'lhs_table'=> 'securitygroups', 'lhs_key' => 'id',
|
|
'rhs_module'=> 'Contacts', 'rhs_table'=> 'contacts', 'rhs_key' => 'id',
|
|
'relationship_type'=>'many-to-many',
|
|
'join_table'=> 'securitygroups_records', 'join_key_lhs'=>'securitygroup_id', 'join_key_rhs'=>'record_id',
|
|
'relationship_role_column'=>'module','relationship_role_column_value'=>'Contacts'),
|
|
'securitygroups_documents' => array(
|
|
'lhs_module'=> 'SecurityGroups', 'lhs_table'=> 'securitygroups', 'lhs_key' => 'id',
|
|
'rhs_module'=> 'Documents', 'rhs_table'=> 'documents', 'rhs_key' => 'id',
|
|
'relationship_type'=>'many-to-many',
|
|
'join_table'=> 'securitygroups_records', 'join_key_lhs'=>'securitygroup_id', 'join_key_rhs'=>'record_id',
|
|
'relationship_role_column'=>'module','relationship_role_column_value'=>'Documents'),
|
|
'securitygroups_emails' => array(
|
|
'lhs_module'=> 'SecurityGroups', 'lhs_table'=> 'securitygroups', 'lhs_key' => 'id',
|
|
'rhs_module'=> 'Emails', 'rhs_table'=> 'emails', 'rhs_key' => 'id',
|
|
'relationship_type'=>'many-to-many',
|
|
'join_table'=> 'securitygroups_records', 'join_key_lhs'=>'securitygroup_id', 'join_key_rhs'=>'record_id',
|
|
'relationship_role_column'=>'module','relationship_role_column_value'=>'Emails'),
|
|
'securitygroups_emailtemplates' => array(
|
|
'lhs_module'=> 'SecurityGroups', 'lhs_table'=> 'securitygroups', 'lhs_key' => 'id',
|
|
'rhs_module'=> 'EmailTemplates', 'rhs_table'=> 'email_templates', 'rhs_key' => 'id',
|
|
'relationship_type'=>'many-to-many',
|
|
'join_table'=> 'securitygroups_records', 'join_key_lhs'=>'securitygroup_id', 'join_key_rhs'=>'record_id',
|
|
'relationship_role_column'=>'module','relationship_role_column_value'=>'EmailTemplates'),
|
|
'securitygroups_leads' => array(
|
|
'lhs_module'=> 'SecurityGroups', 'lhs_table'=> 'securitygroups', 'lhs_key' => 'id',
|
|
'rhs_module'=> 'Leads', 'rhs_table'=> 'leads', 'rhs_key' => 'id',
|
|
'relationship_type'=>'many-to-many',
|
|
'join_table'=> 'securitygroups_records', 'join_key_lhs'=>'securitygroup_id', 'join_key_rhs'=>'record_id',
|
|
'relationship_role_column'=>'module','relationship_role_column_value'=>'Leads'),
|
|
'securitygroups_meetings' => array(
|
|
'lhs_module'=> 'SecurityGroups', 'lhs_table'=> 'securitygroups', 'lhs_key' => 'id',
|
|
'rhs_module'=> 'Meetings', 'rhs_table'=> 'meetings', 'rhs_key' => 'id',
|
|
'relationship_type'=>'many-to-many',
|
|
'join_table'=> 'securitygroups_records', 'join_key_lhs'=>'securitygroup_id', 'join_key_rhs'=>'record_id',
|
|
'relationship_role_column'=>'module','relationship_role_column_value'=>'Meetings'),
|
|
'securitygroups_notes' => array(
|
|
'lhs_module'=> 'SecurityGroups', 'lhs_table'=> 'securitygroups', 'lhs_key' => 'id',
|
|
'rhs_module'=> 'Notes', 'rhs_table'=> 'notes', 'rhs_key' => 'id',
|
|
'relationship_type'=>'many-to-many',
|
|
'join_table'=> 'securitygroups_records', 'join_key_lhs'=>'securitygroup_id', 'join_key_rhs'=>'record_id',
|
|
'relationship_role_column'=>'module','relationship_role_column_value'=>'Notes'),
|
|
'securitygroups_opportunities' => array(
|
|
'lhs_module'=> 'SecurityGroups', 'lhs_table'=> 'securitygroups', 'lhs_key' => 'id',
|
|
'rhs_module'=> 'Opportunities', 'rhs_table'=> 'opportunities', 'rhs_key' => 'id',
|
|
'relationship_type'=>'many-to-many',
|
|
'join_table'=> 'securitygroups_records', 'join_key_lhs'=>'securitygroup_id', 'join_key_rhs'=>'record_id',
|
|
'relationship_role_column'=>'module','relationship_role_column_value'=>'Opportunities'),
|
|
'securitygroups_project' => array(
|
|
'lhs_module'=> 'SecurityGroups', 'lhs_table'=> 'securitygroups', 'lhs_key' => 'id',
|
|
'rhs_module'=> 'Project', 'rhs_table'=> 'project', 'rhs_key' => 'id',
|
|
'relationship_type'=>'many-to-many',
|
|
'join_table'=> 'securitygroups_records', 'join_key_lhs'=>'securitygroup_id', 'join_key_rhs'=>'record_id',
|
|
'relationship_role_column'=>'module','relationship_role_column_value'=>'Project'),
|
|
'securitygroups_project_task' => array(
|
|
'lhs_module'=> 'SecurityGroups', 'lhs_table'=> 'securitygroups', 'lhs_key' => 'id',
|
|
'rhs_module'=> 'ProjectTask', 'rhs_table'=> 'project_task', 'rhs_key' => 'id',
|
|
'relationship_type'=>'many-to-many',
|
|
'join_table'=> 'securitygroups_records', 'join_key_lhs'=>'securitygroup_id', 'join_key_rhs'=>'record_id',
|
|
'relationship_role_column'=>'module','relationship_role_column_value'=>'ProjectTask'),
|
|
'securitygroups_prospect_lists' => array(
|
|
'lhs_module'=> 'SecurityGroups', 'lhs_table'=> 'securitygroups', 'lhs_key' => 'id',
|
|
'rhs_module'=> 'ProspectLists', 'rhs_table'=> 'prospect_lists', 'rhs_key' => 'id',
|
|
'relationship_type'=>'many-to-many',
|
|
'join_table'=> 'securitygroups_records', 'join_key_lhs'=>'securitygroup_id', 'join_key_rhs'=>'record_id',
|
|
'relationship_role_column'=>'module','relationship_role_column_value'=>'ProspectLists'),
|
|
'securitygroups_prospects' => array(
|
|
'lhs_module'=> 'SecurityGroups', 'lhs_table'=> 'securitygroups', 'lhs_key' => 'id',
|
|
'rhs_module'=> 'Prospects', 'rhs_table'=> 'prospects', 'rhs_key' => 'id',
|
|
'relationship_type'=>'many-to-many',
|
|
'join_table'=> 'securitygroups_records', 'join_key_lhs'=>'securitygroup_id', 'join_key_rhs'=>'record_id',
|
|
'relationship_role_column'=>'module','relationship_role_column_value'=>'Prospects'),
|
|
'securitygroups_tasks' => array(
|
|
'lhs_module'=> 'SecurityGroups', 'lhs_table'=> 'securitygroups', 'lhs_key' => 'id',
|
|
'rhs_module'=> 'Tasks', 'rhs_table'=> 'tasks', 'rhs_key' => 'id',
|
|
'relationship_type'=>'many-to-many',
|
|
'join_table'=> 'securitygroups_records', 'join_key_lhs'=>'securitygroup_id', 'join_key_rhs'=>'record_id',
|
|
'relationship_role_column'=>'module','relationship_role_column_value'=>'Tasks'),
|
|
|
|
)
|
|
);
|