relationships.cache.php

用php开发的crm系统

    'lhs_key' => 'id',
    'rhs_module' => 'Tasks',
    'rhs_table' => 'tasks',
    'rhs_key' => 'parent_id',
    'join_table' => NULL,
    'join_key_lhs' => NULL,
    'join_key_rhs' => NULL,
    'relationship_type' => 'one-to-many',
    'relationship_role_column' => 'parent_type',
    'relationship_role_column_value' => 'Opportunities',
    'reverse' => '0',
    'deleted' => '0',
  ),
  'lead_calls' => 
  array (
    'id' => '253be967-c857-2acb-dd7c-4679fc940ca0',
    'relationship_name' => 'lead_calls',
    'lhs_module' => 'Leads',
    'lhs_table' => 'leads',
    'lhs_key' => 'id',
    'rhs_module' => 'Calls',
    'rhs_table' => 'calls',
    'rhs_key' => 'parent_id',
    'join_table' => NULL,
    'join_key_lhs' => NULL,
    'join_key_rhs' => NULL,
    'relationship_type' => 'one-to-many',
    'relationship_role_column' => 'parent_type',
    'relationship_role_column_value' => 'Leads',
    'reverse' => '0',
    'deleted' => '0',
  ),
  'roles_users' => 
  array (
    'id' => '25450f5b-5e53-e63b-8923-4679fc0c2460',
    'relationship_name' => 'roles_users',
    'lhs_module' => 'Roles',
    'lhs_table' => 'roles',
    'lhs_key' => 'id',
    'rhs_module' => 'Users',
    'rhs_table' => 'users',
    'rhs_key' => 'id',
    'join_table' => 'roles_users',
    'join_key_lhs' => 'role_id',
    'join_key_rhs' => 'user_id',
    'relationship_type' => 'many-to-many',
    'relationship_role_column' => NULL,
    'relationship_role_column_value' => NULL,
    'reverse' => '0',
    'deleted' => '0',
  ),
  'ApproveRecord_created_by' => 
  array (
    'id' => '272a0623-3c85-8984-4539-4679fc1b809e',
    'relationship_name' => 'ApproveRecord_created_by',
    'lhs_module' => 'Users',
    'lhs_table' => 'users',
    'lhs_key' => 'id',
    'rhs_module' => 'ApproveRecords',
    'rhs_table' => 'approve_records',
    'rhs_key' => 'created_by',
    'join_table' => NULL,
    'join_key_lhs' => NULL,
    'join_key_rhs' => NULL,
    'relationship_type' => 'one-to-many',
    'relationship_role_column' => NULL,
    'relationship_role_column_value' => NULL,
    'reverse' => '0',
    'deleted' => '0',
  ),
  'opportunity_notes' => 
  array (
    'id' => '290bc6b2-15df-8192-040d-4679fc7186df',
    'relationship_name' => 'opportunity_notes',
    'lhs_module' => 'Opportunities',
    'lhs_table' => 'opportunities',
    'lhs_key' => 'id',
    'rhs_module' => 'Notes',
    'rhs_table' => 'notes',
    'rhs_key' => 'parent_id',
    'join_table' => NULL,
    'join_key_lhs' => NULL,
    'join_key_rhs' => NULL,
    'relationship_type' => 'one-to-many',
    'relationship_role_column' => 'parent_type',
    'relationship_role_column_value' => 'Opportunities',
    'reverse' => '0',
    'deleted' => '0',
  ),
  'lead_emails' => 
  array (
    'id' => '2a33f207-fa41-0fc6-af96-4679fc097682',
    'relationship_name' => 'lead_emails',
    'lhs_module' => 'Leads',
    'lhs_table' => 'leads',
    'lhs_key' => 'id',
    'rhs_module' => 'Emails',
    'rhs_table' => 'emails',
    'rhs_key' => 'parent_id',
    'join_table' => NULL,
    'join_key_lhs' => NULL,
    'join_key_rhs' => NULL,
    'relationship_type' => 'one-to-many',
    'relationship_role_column' => 'parent_type',
    'relationship_role_column_value' => 'Leads',
    'reverse' => '0',
    'deleted' => '0',
  ),
  'project_task_calls' => 
  array (
    'id' => '2a495f10-c59a-2b59-b093-4679fc05d522',
    'relationship_name' => 'project_task_calls',
    'lhs_module' => 'ProjectTask',
    'lhs_table' => 'project_task',
    'lhs_key' => 'id',
    'rhs_module' => 'Calls',
    'rhs_table' => 'calls',
    'rhs_key' => 'parent_id',
    'join_table' => NULL,
    'join_key_lhs' => NULL,
    'join_key_rhs' => NULL,
    'relationship_type' => 'one-to-many',
    'relationship_role_column' => 'parent_type',
    'relationship_role_column_value' => 'ProjectTask',
    'reverse' => '0',
    'deleted' => '0',
  ),
  'projects_contacts' => 
  array (
    'id' => '2ac6c211-34a6-4cf9-7ceb-4679fc7cb24f',
    'relationship_name' => 'projects_contacts',
    'lhs_module' => 'Project',
    'lhs_table' => 'project',
    'lhs_key' => 'id',
    'rhs_module' => 'Contacts',
    'rhs_table' => 'contacts',
    'rhs_key' => 'id',
    'join_table' => 'project_relation',
    'join_key_lhs' => 'project_id',
    'join_key_rhs' => 'relation_id',
    'relationship_type' => 'many-to-many',
    'relationship_role_column' => 'relation_type',
    'relationship_role_column_value' => 'Contacts',
    'reverse' => '0',
    'deleted' => '0',
  ),
  'quotes_documents' => 
  array (
    'id' => '2b2cbf64-b4c1-88d8-210c-4679fcc2dbf6',
    'relationship_name' => 'quotes_documents',
    'lhs_module' => 'Quotes',
    'lhs_table' => 'quotes',
    'lhs_key' => 'id',
    'rhs_module' => 'Documents',
    'rhs_table' => 'documents',
    'rhs_key' => 'id',
    'join_table' => 'quotes_documents',
    'join_key_lhs' => 'quote_id',
    'join_key_rhs' => 'document_id',
    'relationship_type' => 'many-to-many',
    'relationship_role_column' => NULL,
    'relationship_role_column_value' => NULL,
    'reverse' => '0',
    'deleted' => '0',
  ),
  'approve_records_approve_record_details' => 
  array (
    'id' => '2c7e6866-feaf-f98d-bc24-4679fc86dca9',
    'relationship_name' => 'approve_records_approve_record_details',
    'lhs_module' => 'ApproveRecords',
    'lhs_table' => 'approve_records',
    'lhs_key' => 'id',
    'rhs_module' => 'ApproveRecordDetails',
    'rhs_table' => 'approve_record_details',
    'rhs_key' => 'parent_id',
    'join_table' => NULL,
    'join_key_lhs' => NULL,
    'join_key_rhs' => NULL,
    'relationship_type' => 'one-to-many',
    'relationship_role_column' => NULL,
    'relationship_role_column_value' => NULL,
    'reverse' => '0',
    'deleted' => '0',
  ),
  'project_task_emails' => 
  array (
    'id' => '2e8e9777-db72-ac28-36b5-4679fca083a6',
    'relationship_name' => 'project_task_emails',
    'lhs_module' => 'ProjectTask',
    'lhs_table' => 'project_task',
    'lhs_key' => 'id',
    'rhs_module' => 'Emails',
    'rhs_table' => 'emails',
    'rhs_key' => 'parent_id',
    'join_table' => NULL,
    'join_key_lhs' => NULL,
    'join_key_rhs' => NULL,
    'relationship_type' => 'one-to-many',
    'relationship_role_column' => 'parent_type',
    'relationship_role_column_value' => 'ProjectTask',
    'reverse' => '0',
    'deleted' => '0',
  ),
  'followup_meetings' => 
  array (
    'id' => '2ead7a42-35a5-396b-d74c-4679fc2c1dce',
    'relationship_name' => 'followup_meetings',
    'lhs_module' => 'Followups',
    'lhs_table' => 'followups',
    'lhs_key' => 'id',
    'rhs_module' => 'Meetings',
    'rhs_table' => 'meetings',
    'rhs_key' => 'parent_id',
    'join_table' => NULL,
    'join_key_lhs' => NULL,
    'join_key_rhs' => NULL,
    'relationship_type' => 'one-to-many',
    'relationship_role_column' => 'parent_type',
    'relationship_role_column_value' => 'Followups',
    'reverse' => '0',
    'deleted' => '0',
  ),
  'opportunity_emails' => 
  array (
    'id' => '2ec41956-5f4a-d24b-44de-4679fc78d1fd',
    'relationship_name' => 'opportunity_emails',
    'lhs_module' => 'Opportunities',
    'lhs_table' => 'opportunities',
    'lhs_key' => 'id',
    'rhs_module' => 'Emails',
    'rhs_table' => 'emails',
    'rhs_key' => 'parent_id',
    'join_table' => NULL,
    'join_key_lhs' => NULL,
    'join_key_rhs' => NULL,
    'relationship_type' => 'one-to-many',
    'relationship_role_column' => 'parent_type',
    'relationship_role_column_value' => 'Opportunities',
    'reverse' => '0',
    'deleted' => '0',
  ),
  'contacts_users' => 
  array (
    'id' => '2edb902b-451d-9175-760b-4679fc07838b',
    'relationship_name' => 'contacts_users',
    'lhs_module' => 'Contacts',
    'lhs_table' => 'contacts',
    'lhs_key' => 'id',
    'rhs_module' => 'Users',
    'rhs_table' => 'users',
    'rhs_key' => 'id',
    'join_table' => 'contacts_users',
    'join_key_lhs' => 'contact_id',
    'join_key_rhs' => 'user_id',
    'relationship_type' => 'many-to-many',
    'relationship_role_column' => NULL,
    'relationship_role_column_value' => NULL,
    'reverse' => '0',
    'deleted' => '0',
  ),
  'projects_opportunities' => 
  array (
    'id' => '2f146f68-e7a6-a502-01fb-4679fc7cfdc5',
    'relationship_name' => 'projects_opportunities',
    'lhs_module' => 'Project',
    'lhs_table' => 'project',
    'lhs_key' => 'id',
    'rhs_module' => 'Opportunities',
    'rhs_table' => 'opportunities',
    'rhs_key' => 'id',
    'join_table' => 'project_relation',
    'join_key_lhs' => 'project_id',
    'join_key_rhs' => 'relation_id',
    'relationship_type' => 'many-to-many',
    'relationship_role_column' => 'relation_type',
    'relationship_role_column_value' => 'Opportunities',
    'reverse' => '0',
    'deleted' => '0',
  ),
  'problem_notes' => 
  array (
    'id' => '2f312aab-4f7e-ea7f-cb78-4679fcc7f045',
    'relationship_name' => 'problem_notes',
    'lhs_module' => 'Problem',
    'lhs_table' => 'problem',
    'lhs_key' => 'id',
    'rhs_module' => 'Notes',
    'rhs_table' => 'notes',
    'rhs_key' => 'parent_id',
    'join_table' => NULL,
    'join_key_lhs' => NULL,
    'join_key_rhs' => NULL,
    'relationship_type' => 'one-to-many',
    'relationship_role_column' => 'parent_type',
    'relationship_role_column_value' => 'Problem',
    'reverse' => '0',
    'deleted' => '0',
  ),
  'lead_revmsgs' => 
  array (
    'id' => '2f66130a-76fa-5bd6-f80a-4679fcf6c5f6',
    'relationship_name' => 'lead_revmsgs',
    'lhs_module' => 'Leads',
    'lhs_table' => 'leads',
    'lhs_key' => 'id',
    'rhs_module' => 'Revmsgs',
    'rhs_table' => 'revmsgs',
    'rhs_key' => 'lead_id',
    'join_table' => NULL,
    'join_key_lhs' => NULL,
    'join_key_rhs' => NULL,
    'relationship_type' => 'one-to-many',
    'relationship_role_column' => NULL,
    'relationship_role_column_value' => NULL,
    'reverse' => '0',
    'deleted' => '0',
  ),
  'member_accounts' => 
  array (
    'id' => '2f76efab-e005-eda8-d415-4679fc54edff',
    'relationship_name' => 'member_accounts',
    'lhs_module' => 'Accounts',
    'lhs_table' => 'accounts',
    'lhs_key' => 'id',
    'rhs_module' => 'Accounts',
    'rhs_table' => 'accounts',
    'rhs_key' => 'parent_id',
    'join_table' => NULL,
    'join_key_lhs' => NULL,
    'join_key_rhs' => NULL,
    'relationship_type' => 'one-to-many',
    'relationship_role_column' => NULL,
    'relationship_role_column_value' => NULL,
    'reverse' => '0',
    'deleted' => '0',
  ),
  'opportunity_leads' => 
  array (
    'id' => '3336ac56-8084-892b-84fa-4679fc25d1dc',
    'relationship_name' => 'opportunity_leads',
    'lhs_module' => 'Opportunities',
    'lhs_table' => 'opportunities',
    'lhs_key' => 'id',
    'rhs_module' => 'Leads',
    'rhs_table' => 'leads',
    'rhs_key' => 'opportunity_id',
    'join_table' => NULL,
    'join_key_lhs' => NULL,
    'join_key_rhs' => NULL,
    'relationship_type' => 'one-to-many',
    'relationship_role_column' => NULL,
    'relationship_role_column_value' => NULL,
    'reverse' => '0',
    'deleted' => '0',
  ),
  'account_productservices' => 
  array (
    'id' => '33556a53-d41d-4505-0119-4679fc768b1c',
    'relationship_name' => 'account_productservices',
    'lhs_module' => 'Accounts',
    'lhs_table' => 'accounts',
    'lhs_key' => 'id',
    'rhs_module' => 'ProductServices',
    'rhs_table' => 'product_service',
    'rhs_key' => 'account_id',
    'join_table' => NULL,
    'join_key_lhs' => NULL,
    'join_key_rhs' => NULL,
    'relationship_type' => 'one-to-many',
    'relationship_role_column' => NULL,
    'relationship_role_column_value' => NULL,
    'reverse' => '0',
    'deleted' => '0',
  ),
  'followups_assigned_user' => 
  array (
    'id' => '33c915e6-7f4e-35c7-0dcb-4679fcdd4295',
    'relationship_name' => 'followups_assigned_user',
    'lhs_module' => 'Users',
    'lhs_table' => 'users',
    'lhs_key' => 'id',
    'rhs_module' => 'Followups',
    'rhs_table' => 'followups',
    'rhs_key' => 'assigned_user_id',
    'join_table' => NULL,
    'join_key_lhs' => NULL,
    'join_key_rhs' => NULL,
    'relationship_type' => 'one-to-many',
    'relationship_role_column' => NULL,
    'relationship_role_column_value' => NULL,
    'reverse' => '0',
    'deleted' => '0',
  ),
  'problem_problemsolutions' => 
  array (
    'id' => '33ec24ba-722d-0aaa-9eed-4679fc50439c',
    'relationship_name' => 'problem_problemsolutions',
    'lhs_module' => 'Problem',
    'lhs_table' => 'problem',
    'lhs_key' => 'id',
    'rhs_module' => 'ProblemSolution',
    'rhs_table' => 'problem_solution',
    'rhs_key' => 'parent_id',
    'join_table' => NULL,
    'join_key_lhs' => NULL,
    'join_key_rhs' => NULL,
    'relationship_type' => 'one-to-many',
    'relationship_role_column' => NULL,
    'relationship_role_column_value' => NULL,
    'reverse' => '0',
    'deleted' => '0',
  ),
  'project_task_assigned_user' => 
  array (
    'id' => '34737204-34c8-dd91-a146-4679fcce1b1e',
    'relationship_name' => 'project_task_assigned_user',
    'lhs_module' => 'Users',
    'lhs_table' => 'users',
    'lhs_key' => 'id',
    'rhs_module' => 'ProjectTask',
    'rhs_table' => 'project_task',
    'rhs_key' => 'assigned_user_id',
    'join_table' => NULL,
    'join_key_lhs' => NULL,
    'join_key_rhs' => NULL,