3 +--------------------------------------------------------------------+
4 | Copyright CiviCRM LLC. All rights reserved. |
6 | This work is published under the GNU AGPLv3 license with some |
7 | permitted exceptions and without any warranty. For full license |
8 | and copyright information, see https://civicrm.org/licensing |
9 +--------------------------------------------------------------------+
13 * Class representing the table relationships
16 * @copyright CiviCRM LLC https://civicrm.org/licensing
20 class CRM_Core_TableHierarchy
{
23 * This array defines weights for table, which are used to sort array of table in from clause
26 public static $info = [
27 'civicrm_contact' => '01',
28 'civicrm_address' => '09',
29 'civicrm_county' => '10',
30 'civicrm_state_province' => '11',
31 'civicrm_country' => '12',
32 'civicrm_email' => '13',
33 'civicrm_phone' => '14',
35 'civicrm_openid' => '17',
36 'civicrm_location_type' => '18',
37 'civicrm_group_contact' => '19',
38 'civicrm_group_contact_cache' => '20',
39 'civicrm_group' => '21',
40 'civicrm_subscription_history' => '22',
41 'civicrm_entity_tag' => '23',
42 'civicrm_note' => '24',
43 'civicrm_contribution' => '25',
44 'civicrm_financial_type' => '26',
45 'civicrm_participant' => '27',
46 'civicrm_event' => '28',
47 'civicrm_worldregion' => '29',
48 'civicrm_case_contact' => '30',
49 'civicrm_case' => '31',
50 'case_relationship' => '32',
51 'case_relation_type' => '33',
52 'civicrm_activity' => '34',
53 'civicrm_mailing_summary' => '35',
54 'civicrm_mailing_recipients' => '36',
55 'civicrm_mailing' => '37',
56 'civicrm_mailing_job' => '38',
57 'civicrm_mailing_event_queue' => '39',
58 'civicrm_mailing_event_bounce' => '40',
59 'civicrm_mailing_event_opened' => '41',
60 'civicrm_mailing_event_reply' => '42',
61 'civicrm_mailing_event_trackable_url_open' => '43',
67 public static function &info() {
68 //get the campaign related tables.
69 CRM_Campaign_BAO_Query
::info(self
::$info);