<?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['emails_email_addr_rel'] = [ 'table' => 'emails_email_addr_rel', 'comment' => 'Normalization of address fields FROM, TO, CC, and BCC', 'activity_enabled' => false, 'fields' => [ 'id' => [ 'name' => 'id', 'vname' => 'LBL_ID', 'type' => 'id', 'required' => true, 'reportable' => true, 'duplicate_on_record_copy' => 'no', 'mandatory_fetch' => true, ], 'email_id' => [ 'name' => 'email_id', 'vname' => 'LBL_EMAIL_ID', 'type' => 'id', ], 'from' => [ 'name' => 'from', 'vname' => 'LBL_EMAILS_FROM', 'type' => 'link', 'relationship' => 'emails_from', 'source' => 'non-db', 'reportable' => false, ], 'to' => [ 'name' => 'to', 'vname' => 'LBL_EMAILS_TO', 'type' => 'link', 'relationship' => 'emails_to', 'source' => 'non-db', 'reportable' => false, ], 'cc' => [ 'name' => 'cc', 'vname' => 'LBL_EMAILS_CC', 'type' => 'link', 'relationship' => 'emails_cc', 'source' => 'non-db', 'reportable' => false, ], 'bcc' => [ 'name' => 'bcc', 'vname' => 'LBL_EMAILS_BCC', 'type' => 'link', 'relationship' => 'emails_bcc', 'source' => 'non-db', 'reportable' => false, ], 'address_type' => [ 'name' => 'address_type', 'vname' => 'LBL_ADDRESS_TYPE', 'type' => 'varchar', 'len' => 4, 'required' => true, 'comment' => 'The role (from, to, cc, bcc) that the entry plays in the email', ], 'email_address_id' => [ 'name' => 'email_address_id', 'vname' => 'LBL_EMAIL_ADDRESS_ID', 'type' => 'id', // Only required at send-time. 'required' => false, ], 'email_addresses' => [ 'name' => 'email_addresses', 'vname' => 'LBL_EMAIL_ADDRESS', 'type' => 'link', 'relationship' => 'emailaddresses_emailparticipants', 'source' => 'non-db', ], 'email_address' => [ 'name' => 'email_address', 'vname' => 'LBL_EMAIL_ADDRESS', 'type' => 'relate', 'rname' => 'email_address', 'source' => 'non-db', 'id_name' => 'email_address_id', 'link' => 'email_addresses', 'module' => 'EmailAddresses', ], 'invalid_email' => [ 'name' => 'invalid_email', 'vname' => 'LBL_INVALID_EMAIL', 'type' => 'relate', 'rname' => 'invalid_email', 'source' => 'non-db', 'id_name' => 'email_address_id', 'link' => 'email_addresses', ], 'opt_out' => [ 'name' => 'opt_out', 'vname' => 'LBL_OPT_OUT', 'type' => 'relate', 'rname' => 'opt_out', 'source' => 'non-db', 'id_name' => 'email_address_id', 'link' => 'email_addresses', ], 'parent_type' => [ 'name' => 'parent_type', 'vname' => 'LBL_PARENT_NAME', 'type' => 'parent_type', 'dbType' => 'varchar', 'options' => 'record_type_display_emailparticipants', 'required' => false, ], 'parent_id' => [ 'name' => 'parent_id', 'vname' => 'LBL_PARENT_ID', 'type' => 'id', 'comment' => "The bean's ID", ], 'parent_name' => [ 'name' => 'parent_name', 'vname' => 'LBL_LIST_RELATED_TO', 'type' => 'parent', 'type_name' => 'parent_type', 'id_name' => 'parent_id', 'source' => 'non-db', 'parent_type' => 'record_type_display_emailparticipants', 'options' => 'record_type_display_emailparticipants', ], 'deleted' => [ 'name' => 'deleted', 'type' => 'bool', 'default' => 0, ], 'date_entered' => [ 'name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', ], 'date_modified' => [ 'name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', ], ], 'indices' => [ [ 'name' => 'emails_email_addr_relpk', 'type' => 'primary', 'fields' => [ 'id', ], ], [ 'name' => 'idx_eearl_email_id', 'type' => 'index', 'fields' => [ 'email_id', 'address_type', ], ], [ 'name' => 'idx_eearl_email_address_deleted', 'type' => 'index', 'fields' => [ 'email_address_id', 'deleted', ], ], [ 'name' => 'idx_eearl_email_address_role', 'type' => 'index', 'fields' => [ 'email_address_id', 'address_type', 'deleted', ], ], [ 'name' => 'idx_eearl_parent', 'type' => 'index', 'fields' => [ 'parent_type', 'parent_id', 'deleted', ], ], [ 'name' => 'idx_eearl_parent_role', 'type' => 'index', 'fields' => [ 'parent_type', 'parent_id', 'address_type', 'deleted', ], ], ], 'relationships' => [ 'emailaddresses_emailparticipants' => [ 'lhs_module' => 'EmailAddresses', 'lhs_table' => 'email_addresses', 'lhs_key' => 'id', 'rhs_module' => 'EmailParticipants', 'rhs_table' => 'emails_email_addr_rel', 'rhs_key' => 'email_address_id', 'relationship_type' => 'one-to-many', ], ], 'portal_visibility' => [ 'class' => 'EmailParticipants', ], ]; $dictionary['email_addr_bean_rel'] = [ 'table' => 'email_addr_bean_rel', 'fields' => [ 'id' => [ 'name' => 'id', 'type' => 'id', 'required' => true, ], 'email_address_id' => [ 'name' => 'email_address_id', 'type' => 'id', 'required' => true, ], 'bean_id' => [ 'name' => 'bean_id', 'type' => 'id', 'required' => true, ], 'bean_module' => [ 'name' => 'bean_module', 'type' => 'varchar', 'len' => 100, 'required' => true, ], 'primary_address' => [ 'name' => 'primary_address', 'type' => 'bool', 'default' => '0', ], 'reply_to_address' => [ 'name' => 'reply_to_address', 'type' => 'bool', 'default' => '0', ], 'date_created' => [ 'name' => 'date_created', 'type' => 'datetime', ], 'date_modified' => [ 'name' => 'date_modified', 'type' => 'datetime', ], 'deleted' => [ 'name' => 'deleted', 'type' => 'bool', 'default' => 0, ], ], 'indices' => [ [ 'name' => 'email_addresses_relpk', 'type' => 'primary', 'fields' => [ 'id', ], ], [ 'name' => 'idx_bean_id', 'type' => 'index', 'fields' => [ 'bean_id', 'bean_module', ], ], [ 'name' => 'idx_email_address_bean', 'type' => 'index', 'fields' => [ 'email_address_id', 'bean_module', 'bean_id', ], ], [ 'name' => 'idx_primary_address_bean', 'type' => 'index', 'fields' => [ 'primary_address', 'deleted', 'bean_id', ], ], ], 'relationships' => [ ], ];