<?php
// created: 2016-02-29 15:23:56
$dictionary["sp_campaign_sp_campaignmember"] = array (
  'true_relationship_type' => 'one-to-many',
  'relationships' => 
  array (
    'sp_campaign_sp_campaignmember' => 
    array (
      'lhs_module' => 'SP_Campaign',
      'lhs_table' => 'sp_campaign',
      'lhs_key' => 'id',
      'rhs_module' => 'SP_CampaignMember',
      'rhs_table' => 'sp_campaignmember',
      'rhs_key' => 'id',
      'relationship_type' => 'many-to-many',
      'join_table' => 'sp_campaign_sp_campaignmember_c',
      'join_key_lhs' => 'sp_campaign_sp_campaignmembersp_campaign_ida',
      'join_key_rhs' => 'sp_campaign_sp_campaignmembersp_campaignmember_idb',
    ),
  ),
  'table' => 'sp_campaign_sp_campaignmember_c',
  'fields' => 
  array (
    'id' => 
    array (
      'name' => 'id',
      'type' => 'varchar',
      'len' => 36,
    ),
    'date_modified' => 
    array (
      'name' => 'date_modified',
      'type' => 'datetime',
    ),
    'deleted' => 
    array (
      'name' => 'deleted',
      'type' => 'bool',
      'len' => '1',
      'default' => '0',
      'required' => true,
    ),
    'sp_campaign_sp_campaignmembersp_campaign_ida' => 
    array (
      'name' => 'sp_campaign_sp_campaignmembersp_campaign_ida',
      'type' => 'varchar',
      'len' => 36,
    ),
    'sp_campaign_sp_campaignmembersp_campaignmember_idb' => 
    array (
      'name' => 'sp_campaign_sp_campaignmembersp_campaignmember_idb',
      'type' => 'varchar',
      'len' => 36,
    ),
  ),
  'indices' => 
  array (
    0 => 
    array (
      'name' => 'sp_campaign_sp_campaignmemberspk',
      'type' => 'primary',
      'fields' => 
      array (
        0 => 'id',
      ),
    ),
    1 => 
    array (
      'name' => 'sp_campaign_sp_campaignmember_ida1',
      'type' => 'index',
      'fields' => 
      array (
        0 => 'sp_campaign_sp_campaignmembersp_campaign_ida',
      ),
    ),
    2 => 
    array (
      'name' => 'sp_campaign_sp_campaignmember_alt',
      'type' => 'alternate_key',
      'fields' => 
      array (
        0 => 'sp_campaign_sp_campaignmembersp_campaignmember_idb',
      ),
    ),
  ),
);