'contacts_bugs' , 'fields' => array( array('name' => 'id', 'type' => 'varchar', 'len' => '36') , array('name' => 'contact_id', 'type' => 'varchar', 'len' => '36',) , array('name' => 'bug_id', 'type' => 'varchar', 'len' => '36',) , array('name' => 'contact_role', 'type' => 'varchar', 'len' => '50',) , array('name' => 'date_modified', 'type' => 'datetime') , array('name' => 'deleted', 'type' => 'bool', 'len' => '1', 'default' => '0', 'required' => false) ), 'indices' => array( array('name' => 'contacts_bugspk', 'type' => 'primary', 'fields' => array('id')) , array('name' => 'idx_con_bug_con', 'type' => 'index', 'fields' => array('contact_id')) , array('name' => 'idx_con_bug_bug', 'type' => 'index', 'fields' => array('bug_id')) , array('name' => 'idx_contact_bug', 'type' => 'alternate_key', 'fields' => array('contact_id', 'bug_id')) ) , 'relationships' => array( 'contacts_bugs' => array( 'lhs_module' => 'Contacts', 'lhs_table' => 'contacts', 'lhs_key' => 'id', 'rhs_module' => 'Bugs', 'rhs_table' => 'bugs', 'rhs_key' => 'id', 'relationship_type' => 'many-to-many', 'join_table' => 'contacts_bugs', 'join_key_lhs' => 'contact_id', 'join_key_rhs' => 'bug_id')) ) ?>