Skip to content

Instantly share code, notes, and snippets.

@totten totten/1-fields.php Secret
Last active Oct 15, 2019

Embed
What would you like to do?
<?php
// Analyze the full/active data-model and attempt to infer optimal
// escaping policy for each field.
// Run it with `cv scr fields.php`
// NOTE: Third-party/uninstalled extensions not visible to us
function categorize($field, $type) {
$skipList = CRM_Utils_API_HTMLInputCoder::singleton()->getSkipFields();
if (in_array($field, $skipList)) {
// This field is expected to store HTML content (e.g. `description` or `msg_bo.
return 'string-canonical';
}
switch ($type) {
case CRM_Utils_Type::T_INT:
case CRM_Utils_Type::T_BOOLEAN:
// case CRM_Utils_Type::T_ENUM: UGH! Same value as T_STRING...
case CRM_Utils_Type::T_FLOAT:
case CRM_Utils_Type::T_MONEY:
case CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME:
case CRM_Utils_Type::T_DATE:
case CRM_Utils_Type::T_TIME:
case CRM_Utils_Type::T_TIMESTAMP:
return 'sql-strong-type';
case CRM_Utils_Type::T_CCNUM:
throw new \Exception('wtf');
case CRM_Utils_Type::T_BLOB:
case CRM_Utils_Type::T_EMAIL:
case CRM_Utils_Type::T_LONGTEXT:
case CRM_Utils_Type::T_MEDIUMBLOB:
case CRM_Utils_Type::T_STRING:
case CRM_Utils_Type::T_TEXT:
case CRM_Utils_Type::T_URL:
// This field is not semantically HTML, but it's been coereced to HTML for
// output purposes. Note that the $type alone doesn't determine this - rather,
// we infer based (a) it is NOT in the skip list and (b) it IS a string.
return 'string-quasi-encoded-?';
default:
return 'unknown';
}
}
$tables = CRM_Core_DAO_AllCoreTables::getCoreTables();
ksort($tables);
$allFields = [];
$allApiEntities = civicrm_api3('Entity', 'get', []);
foreach ($tables as $table => $daoClass) {
$fields = $daoClass::fields();
ksort($fields);
$entity = CRM_Core_DAO_AllCoreTables::getBriefName($daoClass);
$isEntity = in_array($entity, $allApiEntities['values']);
foreach ($fields as $fieldName => $field) {
$allFields[] = [
'mysql_table' => $table,
'api3_entity' => $isEntity ? $entity : '*NONE*',
'field' => $fieldName,
'type' => CRM_Utils_Type::typeToString($field['type']),
'current-storage-format' => categorize($fieldName, $field['type']),
];
}
}
fputcsv(STDOUT, array_keys($allFields[0]));
foreach ($allFields as $field) {
fputcsv(STDOUT, $field);
}
mysql_table api3_entity field type current-storage-format
civicrm_acl *NONE* acl_id Int sql-strong-type
civicrm_acl *NONE* acl_table String string-quasi-encoded-?
civicrm_acl *NONE* deny Boolean sql-strong-type
civicrm_acl *NONE* entity_id Int sql-strong-type
civicrm_acl *NONE* entity_table String string-quasi-encoded-?
civicrm_acl *NONE* id Int sql-strong-type
civicrm_acl *NONE* is_active Boolean sql-strong-type
civicrm_acl *NONE* name String string-quasi-encoded-?
civicrm_acl *NONE* object_id Int sql-strong-type
civicrm_acl *NONE* object_table String string-quasi-encoded-?
civicrm_acl *NONE* operation String string-quasi-encoded-?
civicrm_acl_cache *NONE* acl_id Int sql-strong-type
civicrm_acl_cache *NONE* contact_id Int sql-strong-type
civicrm_acl_cache *NONE* id Int sql-strong-type
civicrm_acl_cache *NONE* modified_date Timestamp sql-strong-type
civicrm_acl_contact_cache *NONE* contact_id Int sql-strong-type
civicrm_acl_contact_cache *NONE* id Int sql-strong-type
civicrm_acl_contact_cache *NONE* operation String string-quasi-encoded-?
civicrm_acl_contact_cache *NONE* user_id Int sql-strong-type
civicrm_acl_entity_role *NONE* acl_role_id Int sql-strong-type
civicrm_acl_entity_role *NONE* entity_id Int sql-strong-type
civicrm_acl_entity_role *NONE* entity_table String string-quasi-encoded-?
civicrm_acl_entity_role *NONE* id Int sql-strong-type
civicrm_acl_entity_role *NONE* is_active Boolean sql-strong-type
civicrm_action_log *NONE* action_date_time Timestamp sql-strong-type
civicrm_action_log *NONE* action_schedule_id Int sql-strong-type
civicrm_action_log *NONE* contact_id Int sql-strong-type
civicrm_action_log *NONE* entity_id Int sql-strong-type
civicrm_action_log *NONE* entity_table String string-quasi-encoded-?
civicrm_action_log *NONE* id Int sql-strong-type
civicrm_action_log *NONE* is_error Boolean sql-strong-type
civicrm_action_log *NONE* message Text string-quasi-encoded-?
civicrm_action_log *NONE* reference_date Timestamp sql-strong-type
civicrm_action_log *NONE* repetition_number Int sql-strong-type
civicrm_action_mapping *NONE* entity String string-quasi-encoded-?
civicrm_action_mapping *NONE* entity_date_end String string-quasi-encoded-?
civicrm_action_mapping *NONE* entity_date_start String string-quasi-encoded-?
civicrm_action_mapping *NONE* entity_recipient String string-quasi-encoded-?
civicrm_action_mapping *NONE* entity_status String string-quasi-encoded-?
civicrm_action_mapping *NONE* entity_status_label String string-quasi-encoded-?
civicrm_action_mapping *NONE* entity_value String string-quasi-encoded-?
civicrm_action_mapping *NONE* entity_value_label String string-quasi-encoded-?
civicrm_action_mapping *NONE* id Int sql-strong-type
civicrm_action_schedule ActionSchedule absolute_date Date sql-strong-type
civicrm_action_schedule ActionSchedule body_html Text string-canonical
civicrm_action_schedule ActionSchedule body_text Text string-canonical
civicrm_action_schedule ActionSchedule communication_language String string-quasi-encoded-?
civicrm_action_schedule ActionSchedule end_action String string-quasi-encoded-?
civicrm_action_schedule ActionSchedule end_date String string-quasi-encoded-?
civicrm_action_schedule ActionSchedule end_frequency_interval Int sql-strong-type
civicrm_action_schedule ActionSchedule end_frequency_unit String string-quasi-encoded-?
civicrm_action_schedule ActionSchedule entity_status String string-quasi-encoded-?
civicrm_action_schedule ActionSchedule entity_value String string-quasi-encoded-?
civicrm_action_schedule ActionSchedule filter_contact_language String string-quasi-encoded-?
civicrm_action_schedule ActionSchedule from_email String string-quasi-encoded-?
civicrm_action_schedule ActionSchedule from_name String string-quasi-encoded-?
civicrm_action_schedule ActionSchedule group_id Int sql-strong-type
civicrm_action_schedule ActionSchedule id Int sql-strong-type
civicrm_action_schedule ActionSchedule is_active Boolean sql-strong-type
civicrm_action_schedule ActionSchedule is_repeat Boolean sql-strong-type
civicrm_action_schedule ActionSchedule limit_to Boolean sql-strong-type
civicrm_action_schedule ActionSchedule mapping_id String string-quasi-encoded-?
civicrm_action_schedule ActionSchedule mode String string-quasi-encoded-?
civicrm_action_schedule ActionSchedule msg_template_id Int sql-strong-type
civicrm_action_schedule ActionSchedule name String string-quasi-encoded-?
civicrm_action_schedule ActionSchedule recipient String string-quasi-encoded-?
civicrm_action_schedule ActionSchedule recipient_listing String string-quasi-encoded-?
civicrm_action_schedule ActionSchedule recipient_manual String string-quasi-encoded-?
civicrm_action_schedule ActionSchedule record_activity Boolean sql-strong-type
civicrm_action_schedule ActionSchedule repetition_frequency_interval Int sql-strong-type
civicrm_action_schedule ActionSchedule repetition_frequency_unit String string-quasi-encoded-?
civicrm_action_schedule ActionSchedule sms_body_text Text string-quasi-encoded-?
civicrm_action_schedule ActionSchedule sms_provider_id Int sql-strong-type
civicrm_action_schedule ActionSchedule sms_template_id Int sql-strong-type
civicrm_action_schedule ActionSchedule start_action_condition String string-quasi-encoded-?
civicrm_action_schedule ActionSchedule start_action_date String string-quasi-encoded-?
civicrm_action_schedule ActionSchedule start_action_offset Int sql-strong-type
civicrm_action_schedule ActionSchedule start_action_unit String string-quasi-encoded-?
civicrm_action_schedule ActionSchedule subject String string-quasi-encoded-?
civicrm_action_schedule ActionSchedule title String string-quasi-encoded-?
civicrm_action_schedule ActionSchedule used_for String string-quasi-encoded-?
civicrm_activity Activity activity_campaign_id Int sql-strong-type
civicrm_activity Activity activity_created_date Timestamp sql-strong-type
civicrm_activity Activity activity_date_time Timestamp sql-strong-type
civicrm_activity Activity activity_details Text string-quasi-encoded-?
civicrm_activity Activity activity_duration Int sql-strong-type
civicrm_activity Activity activity_engagement_level Int sql-strong-type
civicrm_activity Activity activity_id Int sql-strong-type
civicrm_activity Activity activity_is_deleted Boolean sql-strong-type
civicrm_activity Activity activity_is_test Boolean sql-strong-type
civicrm_activity Activity activity_location String string-quasi-encoded-?
civicrm_activity Activity activity_medium_id Int sql-strong-type
civicrm_activity Activity activity_modified_date Timestamp sql-strong-type
civicrm_activity Activity activity_result String string-quasi-encoded-?
civicrm_activity Activity activity_status_id Int sql-strong-type
civicrm_activity Activity activity_subject String string-quasi-encoded-?
civicrm_activity Activity activity_type_id Int sql-strong-type
civicrm_activity Activity is_auto Boolean sql-strong-type
civicrm_activity Activity is_current_revision Boolean sql-strong-type
civicrm_activity Activity is_star Boolean sql-strong-type
civicrm_activity Activity original_id Int sql-strong-type
civicrm_activity Activity parent_id Int sql-strong-type
civicrm_activity Activity phone_id Int sql-strong-type
civicrm_activity Activity phone_number String string-quasi-encoded-?
civicrm_activity Activity priority_id Int sql-strong-type
civicrm_activity Activity relationship_id Int sql-strong-type
civicrm_activity Activity source_record_id Int sql-strong-type
civicrm_activity Activity weight Int sql-strong-type
civicrm_activity_contact ActivityContact activity_id Int sql-strong-type
civicrm_activity_contact ActivityContact contact_id Int sql-strong-type
civicrm_activity_contact ActivityContact id Int sql-strong-type
civicrm_activity_contact ActivityContact record_type_id Int sql-strong-type
civicrm_address Address address_name String string-quasi-encoded-?
civicrm_address Address city String string-quasi-encoded-?
civicrm_address Address contact_id Int sql-strong-type
civicrm_address Address country_id Int sql-strong-type
civicrm_address Address county_id Int sql-strong-type
civicrm_address Address geo_code_1 Float sql-strong-type
civicrm_address Address geo_code_2 Float sql-strong-type
civicrm_address Address id Int sql-strong-type
civicrm_address Address is_billing Boolean sql-strong-type
civicrm_address Address is_primary Boolean sql-strong-type
civicrm_address Address location_type_id Int sql-strong-type
civicrm_address Address manual_geo_code Boolean sql-strong-type
civicrm_address Address master_id Int sql-strong-type
civicrm_address Address postal_code String string-quasi-encoded-?
civicrm_address Address postal_code_suffix String string-quasi-encoded-?
civicrm_address Address state_province_id Int sql-strong-type
civicrm_address Address street_address String string-quasi-encoded-?
civicrm_address Address street_name String string-quasi-encoded-?
civicrm_address Address street_number Int sql-strong-type
civicrm_address Address street_number_postdirectional String string-quasi-encoded-?
civicrm_address Address street_number_predirectional String string-quasi-encoded-?
civicrm_address Address street_number_suffix String string-quasi-encoded-?
civicrm_address Address street_type String string-quasi-encoded-?
civicrm_address Address street_unit String string-quasi-encoded-?
civicrm_address Address supplemental_address_1 String string-quasi-encoded-?
civicrm_address Address supplemental_address_2 String string-quasi-encoded-?
civicrm_address Address supplemental_address_3 String string-quasi-encoded-?
civicrm_address Address timezone String string-quasi-encoded-?
civicrm_address Address usps_adc String string-quasi-encoded-?
civicrm_address_format *NONE* format Text string-quasi-encoded-?
civicrm_address_format *NONE* id Int sql-strong-type
civicrm_batch Batch created_date Timestamp sql-strong-type
civicrm_batch Batch created_id Int sql-strong-type
civicrm_batch Batch data Text string-canonical
civicrm_batch Batch description Text string-canonical
civicrm_batch Batch exported_date Timestamp sql-strong-type
civicrm_batch Batch id Int sql-strong-type
civicrm_batch Batch item_count Int sql-strong-type
civicrm_batch Batch mode_id Int sql-strong-type
civicrm_batch Batch modified_date Timestamp sql-strong-type
civicrm_batch Batch modified_id Int sql-strong-type
civicrm_batch Batch name String string-quasi-encoded-?
civicrm_batch Batch payment_instrument_id Int sql-strong-type
civicrm_batch Batch saved_search_id Int sql-strong-type
civicrm_batch Batch status_id Int sql-strong-type
civicrm_batch Batch title String string-quasi-encoded-?
civicrm_batch Batch total Money sql-strong-type
civicrm_batch Batch type_id Int sql-strong-type
civicrm_cache *NONE* component_id Int sql-strong-type
civicrm_cache *NONE* created_date Timestamp sql-strong-type
civicrm_cache *NONE* data Text string-canonical
civicrm_cache *NONE* expired_date Timestamp sql-strong-type
civicrm_cache *NONE* group_name String string-quasi-encoded-?
civicrm_cache *NONE* id Int sql-strong-type
civicrm_cache *NONE* path String string-quasi-encoded-?
civicrm_campaign Campaign campaign_type_id Int sql-strong-type
civicrm_campaign Campaign created_date Timestamp sql-strong-type
civicrm_campaign Campaign created_id Int sql-strong-type
civicrm_campaign Campaign description Text string-canonical
civicrm_campaign Campaign end_date Timestamp sql-strong-type
civicrm_campaign Campaign external_identifier String string-quasi-encoded-?
civicrm_campaign Campaign goal_general Text string-canonical
civicrm_campaign Campaign goal_revenue Money sql-strong-type
civicrm_campaign Campaign id Int sql-strong-type
civicrm_campaign Campaign is_active Boolean sql-strong-type
civicrm_campaign Campaign last_modified_date Timestamp sql-strong-type
civicrm_campaign Campaign last_modified_id Int sql-strong-type
civicrm_campaign Campaign name String string-quasi-encoded-?
civicrm_campaign Campaign parent_id Int sql-strong-type
civicrm_campaign Campaign start_date Timestamp sql-strong-type
civicrm_campaign Campaign status_id Int sql-strong-type
civicrm_campaign Campaign title String string-quasi-encoded-?
civicrm_campaign_group *NONE* campaign_id Int sql-strong-type
civicrm_campaign_group *NONE* entity_id Int sql-strong-type
civicrm_campaign_group *NONE* entity_table String string-quasi-encoded-?
civicrm_campaign_group *NONE* group_type String string-quasi-encoded-?
civicrm_campaign_group *NONE* id Int sql-strong-type
civicrm_case Case case_created_date Timestamp sql-strong-type
civicrm_case Case case_deleted Boolean sql-strong-type
civicrm_case Case case_end_date Date sql-strong-type
civicrm_case Case case_id Int sql-strong-type
civicrm_case Case case_modified_date Timestamp sql-strong-type
civicrm_case Case case_start_date Date sql-strong-type
civicrm_case Case case_status_id Int sql-strong-type
civicrm_case Case case_subject String string-quasi-encoded-?
civicrm_case Case case_type_id Int sql-strong-type
civicrm_case Case details Text string-canonical
civicrm_case_activity *NONE* activity_id Int sql-strong-type
civicrm_case_activity *NONE* case_id Int sql-strong-type
civicrm_case_activity *NONE* id Int sql-strong-type
civicrm_case_contact CaseContact case_id Int sql-strong-type
civicrm_case_contact CaseContact contact_id Int sql-strong-type
civicrm_case_contact CaseContact id Int sql-strong-type
civicrm_case_type CaseType definition Blob string-quasi-encoded-?
civicrm_case_type CaseType description String string-canonical
civicrm_case_type CaseType id Int sql-strong-type
civicrm_case_type CaseType is_active Boolean sql-strong-type
civicrm_case_type CaseType is_reserved Boolean sql-strong-type
civicrm_case_type CaseType name String string-quasi-encoded-?
civicrm_case_type CaseType title String string-quasi-encoded-?
civicrm_case_type CaseType weight Int sql-strong-type
civicrm_component *NONE* id Int sql-strong-type
civicrm_component *NONE* name String string-quasi-encoded-?
civicrm_component *NONE* namespace String string-quasi-encoded-?
civicrm_contact Contact addressee_custom String string-quasi-encoded-?
civicrm_contact Contact addressee_display String string-quasi-encoded-?
civicrm_contact Contact addressee_id Int sql-strong-type
civicrm_contact Contact api_key String string-quasi-encoded-?
civicrm_contact Contact birth_date Date sql-strong-type
civicrm_contact Contact communication_style_id Int sql-strong-type
civicrm_contact Contact contact_is_deleted Boolean sql-strong-type
civicrm_contact Contact contact_source String string-quasi-encoded-?
civicrm_contact Contact contact_sub_type String string-quasi-encoded-?
civicrm_contact Contact contact_type String string-quasi-encoded-?
civicrm_contact Contact created_date Timestamp sql-strong-type
civicrm_contact Contact current_employer_id Int sql-strong-type
civicrm_contact Contact deceased_date Date sql-strong-type
civicrm_contact Contact display_name String string-quasi-encoded-?
civicrm_contact Contact do_not_email Boolean sql-strong-type
civicrm_contact Contact do_not_mail Boolean sql-strong-type
civicrm_contact Contact do_not_phone Boolean sql-strong-type
civicrm_contact Contact do_not_sms Boolean sql-strong-type
civicrm_contact Contact do_not_trade Boolean sql-strong-type
civicrm_contact Contact email_greeting_custom String string-quasi-encoded-?
civicrm_contact Contact email_greeting_display String string-quasi-encoded-?
civicrm_contact Contact email_greeting_id Int sql-strong-type
civicrm_contact Contact external_identifier String string-quasi-encoded-?
civicrm_contact Contact first_name String string-quasi-encoded-?
civicrm_contact Contact formal_title String string-quasi-encoded-?
civicrm_contact Contact gender_id Int sql-strong-type
civicrm_contact Contact hash String string-quasi-encoded-?
civicrm_contact Contact household_name String string-quasi-encoded-?
civicrm_contact Contact id Int sql-strong-type
civicrm_contact Contact image_URL Text string-quasi-encoded-?
civicrm_contact Contact is_deceased Boolean sql-strong-type
civicrm_contact Contact is_opt_out Boolean sql-strong-type
civicrm_contact Contact job_title String string-quasi-encoded-?
civicrm_contact Contact last_name String string-quasi-encoded-?
civicrm_contact Contact legal_identifier String string-quasi-encoded-?
civicrm_contact Contact legal_name String string-quasi-encoded-?
civicrm_contact Contact middle_name String string-quasi-encoded-?
civicrm_contact Contact modified_date Timestamp sql-strong-type
civicrm_contact Contact nick_name String string-quasi-encoded-?
civicrm_contact Contact organization_name String string-quasi-encoded-?
civicrm_contact Contact postal_greeting_custom String string-quasi-encoded-?
civicrm_contact Contact postal_greeting_display String string-quasi-encoded-?
civicrm_contact Contact postal_greeting_id Int sql-strong-type
civicrm_contact Contact preferred_communication_method String string-quasi-encoded-?
civicrm_contact Contact preferred_language String string-quasi-encoded-?
civicrm_contact Contact preferred_mail_format String string-quasi-encoded-?
civicrm_contact Contact prefix_id Int sql-strong-type
civicrm_contact Contact primary_contact_id Int sql-strong-type
civicrm_contact Contact sic_code String string-quasi-encoded-?
civicrm_contact Contact sort_name String string-quasi-encoded-?
civicrm_contact Contact suffix_id Int sql-strong-type
civicrm_contact Contact user_unique_id String string-quasi-encoded-?
civicrm_contact_type ContactType description Text string-canonical
civicrm_contact_type ContactType id Int sql-strong-type
civicrm_contact_type ContactType image_URL String string-quasi-encoded-?
civicrm_contact_type ContactType is_active Boolean sql-strong-type
civicrm_contact_type ContactType is_reserved Boolean sql-strong-type
civicrm_contact_type ContactType label String string-canonical
civicrm_contact_type ContactType name String string-quasi-encoded-?
civicrm_contact_type ContactType parent_id Int sql-strong-type
civicrm_contribution Contribution amount_level Text string-quasi-encoded-?
civicrm_contribution Contribution cancel_reason Text string-quasi-encoded-?
civicrm_contribution Contribution contribution_address_id Int sql-strong-type
civicrm_contribution Contribution contribution_campaign_id Int sql-strong-type
civicrm_contribution Contribution contribution_cancel_date Timestamp sql-strong-type
civicrm_contribution Contribution contribution_check_number String string-quasi-encoded-?
civicrm_contribution Contribution contribution_contact_id Int sql-strong-type
civicrm_contribution Contribution contribution_id Int sql-strong-type
civicrm_contribution Contribution contribution_page_id Int sql-strong-type
civicrm_contribution Contribution contribution_recur_id Int sql-strong-type
civicrm_contribution Contribution contribution_source String string-quasi-encoded-?
civicrm_contribution Contribution contribution_status_id Int sql-strong-type
civicrm_contribution Contribution creditnote_id String string-quasi-encoded-?
civicrm_contribution Contribution currency String string-quasi-encoded-?
civicrm_contribution Contribution fee_amount Money sql-strong-type
civicrm_contribution Contribution financial_type_id Int sql-strong-type
civicrm_contribution Contribution invoice_id String string-quasi-encoded-?
civicrm_contribution Contribution invoice_number String string-quasi-encoded-?
civicrm_contribution Contribution is_pay_later Boolean sql-strong-type
civicrm_contribution Contribution is_template Boolean sql-strong-type
civicrm_contribution Contribution is_test Boolean sql-strong-type
civicrm_contribution Contribution net_amount Money sql-strong-type
civicrm_contribution Contribution non_deductible_amount Money sql-strong-type
civicrm_contribution Contribution payment_instrument_id Int sql-strong-type
civicrm_contribution Contribution receipt_date Timestamp sql-strong-type
civicrm_contribution Contribution receive_date Timestamp sql-strong-type
civicrm_contribution Contribution revenue_recognition_date Timestamp sql-strong-type
civicrm_contribution Contribution tax_amount Money sql-strong-type
civicrm_contribution Contribution thankyou_date Timestamp sql-strong-type
civicrm_contribution Contribution total_amount Money sql-strong-type
civicrm_contribution Contribution trxn_id String string-quasi-encoded-?
civicrm_contribution_page ContributionPage adjust_recur_start_date Boolean sql-strong-type
civicrm_contribution_page ContributionPage amount_block_is_active Boolean sql-strong-type
civicrm_contribution_page ContributionPage bcc_receipt String string-quasi-encoded-?
civicrm_contribution_page ContributionPage campaign_id Int sql-strong-type
civicrm_contribution_page ContributionPage cc_receipt String string-quasi-encoded-?
civicrm_contribution_page ContributionPage contribution_page_frontend_title String string-quasi-encoded-?
civicrm_contribution_page ContributionPage created_date Timestamp sql-strong-type
civicrm_contribution_page ContributionPage created_id Int sql-strong-type
civicrm_contribution_page ContributionPage currency String string-quasi-encoded-?
civicrm_contribution_page ContributionPage default_amount_id Int sql-strong-type
civicrm_contribution_page ContributionPage end_date Timestamp sql-strong-type
civicrm_contribution_page ContributionPage financial_type_id Int sql-strong-type
civicrm_contribution_page ContributionPage footer_text Text string-canonical
civicrm_contribution_page ContributionPage goal_amount Money sql-strong-type
civicrm_contribution_page ContributionPage id Int sql-strong-type
civicrm_contribution_page ContributionPage initial_amount_help_text Text string-quasi-encoded-?
civicrm_contribution_page ContributionPage initial_amount_label String string-quasi-encoded-?
civicrm_contribution_page ContributionPage intro_text Text string-canonical
civicrm_contribution_page ContributionPage is_active Boolean sql-strong-type
civicrm_contribution_page ContributionPage is_allow_other_amount Boolean sql-strong-type
civicrm_contribution_page ContributionPage is_billing_required Boolean sql-strong-type
civicrm_contribution_page ContributionPage is_confirm_enabled Boolean sql-strong-type
civicrm_contribution_page ContributionPage is_credit_card_only Boolean sql-strong-type
civicrm_contribution_page ContributionPage is_email_receipt Boolean sql-strong-type
civicrm_contribution_page ContributionPage is_monetary Boolean sql-strong-type
civicrm_contribution_page ContributionPage is_partial_payment Boolean sql-strong-type
civicrm_contribution_page ContributionPage is_pay_later Boolean sql-strong-type
civicrm_contribution_page ContributionPage is_recur Boolean sql-strong-type
civicrm_contribution_page ContributionPage is_recur_installments Boolean sql-strong-type
civicrm_contribution_page ContributionPage is_recur_interval Boolean sql-strong-type
civicrm_contribution_page ContributionPage is_share Boolean sql-strong-type
civicrm_contribution_page ContributionPage max_amount Money sql-strong-type
civicrm_contribution_page ContributionPage min_amount Money sql-strong-type
civicrm_contribution_page ContributionPage min_initial_amount Money sql-strong-type
civicrm_contribution_page ContributionPage pay_later_receipt Text string-canonical
civicrm_contribution_page ContributionPage pay_later_text Text string-canonical
civicrm_contribution_page ContributionPage payment_processor String string-quasi-encoded-?
civicrm_contribution_page ContributionPage receipt_from_email String string-quasi-encoded-?
civicrm_contribution_page ContributionPage receipt_from_name String string-quasi-encoded-?
civicrm_contribution_page ContributionPage receipt_text Text string-quasi-encoded-?
civicrm_contribution_page ContributionPage recur_frequency_unit String string-quasi-encoded-?
civicrm_contribution_page ContributionPage start_date Timestamp sql-strong-type
civicrm_contribution_page ContributionPage thankyou_footer Text string-canonical
civicrm_contribution_page ContributionPage thankyou_text Text string-canonical
civicrm_contribution_page ContributionPage thankyou_title String string-quasi-encoded-?
civicrm_contribution_page ContributionPage title String string-quasi-encoded-?
civicrm_contribution_product ContributionProduct comment Text string-quasi-encoded-?
civicrm_contribution_product ContributionProduct contribution_end_date Date sql-strong-type
civicrm_contribution_product ContributionProduct contribution_id Int sql-strong-type
civicrm_contribution_product ContributionProduct contribution_start_date Date sql-strong-type
civicrm_contribution_product ContributionProduct financial_type_id Int sql-strong-type
civicrm_contribution_product ContributionProduct fulfilled_date Date sql-strong-type
civicrm_contribution_product ContributionProduct id Int sql-strong-type
civicrm_contribution_product ContributionProduct product_id Int sql-strong-type
civicrm_contribution_product ContributionProduct product_option String string-quasi-encoded-?
civicrm_contribution_product ContributionProduct quantity Int sql-strong-type
civicrm_contribution_recur ContributionRecur amount Money sql-strong-type
civicrm_contribution_recur ContributionRecur auto_renew Boolean sql-strong-type
civicrm_contribution_recur ContributionRecur contact_id Int sql-strong-type
civicrm_contribution_recur ContributionRecur contribution_campaign_id Int sql-strong-type
civicrm_contribution_recur ContributionRecur contribution_recur_cancel_date Timestamp sql-strong-type
civicrm_contribution_recur ContributionRecur contribution_recur_cancel_reason Text string-quasi-encoded-?
civicrm_contribution_recur ContributionRecur contribution_recur_contribution_status_id Int sql-strong-type
civicrm_contribution_recur ContributionRecur contribution_recur_create_date Timestamp sql-strong-type
civicrm_contribution_recur ContributionRecur contribution_recur_end_date Timestamp sql-strong-type
civicrm_contribution_recur ContributionRecur contribution_recur_failure_retry_date Timestamp sql-strong-type
civicrm_contribution_recur ContributionRecur contribution_recur_id Int sql-strong-type
civicrm_contribution_recur ContributionRecur contribution_recur_modified_date Timestamp sql-strong-type
civicrm_contribution_recur ContributionRecur contribution_recur_next_sched_contribution_date Timestamp sql-strong-type
civicrm_contribution_recur ContributionRecur contribution_recur_payment_processor_id Int sql-strong-type
civicrm_contribution_recur ContributionRecur contribution_recur_processor_id String string-quasi-encoded-?
civicrm_contribution_recur ContributionRecur contribution_recur_start_date Timestamp sql-strong-type
civicrm_contribution_recur ContributionRecur contribution_recur_trxn_id String string-quasi-encoded-?
civicrm_contribution_recur ContributionRecur currency String string-quasi-encoded-?
civicrm_contribution_recur ContributionRecur cycle_day Int sql-strong-type
civicrm_contribution_recur ContributionRecur failure_count Int sql-strong-type
civicrm_contribution_recur ContributionRecur financial_type_id Int sql-strong-type
civicrm_contribution_recur ContributionRecur frequency_interval Int sql-strong-type
civicrm_contribution_recur ContributionRecur frequency_unit String string-quasi-encoded-?
civicrm_contribution_recur ContributionRecur installments Int sql-strong-type
civicrm_contribution_recur ContributionRecur invoice_id String string-quasi-encoded-?
civicrm_contribution_recur ContributionRecur is_email_receipt Boolean sql-strong-type
civicrm_contribution_recur ContributionRecur is_test Boolean sql-strong-type
civicrm_contribution_recur ContributionRecur payment_instrument_id Int sql-strong-type
civicrm_contribution_recur ContributionRecur payment_token_id Int sql-strong-type
civicrm_contribution_soft ContributionSoft amount Money sql-strong-type
civicrm_contribution_soft ContributionSoft contribution_id Int sql-strong-type
civicrm_contribution_soft ContributionSoft contribution_soft_contact_id Int sql-strong-type
civicrm_contribution_soft ContributionSoft contribution_soft_id Int sql-strong-type
civicrm_contribution_soft ContributionSoft currency String string-quasi-encoded-?
civicrm_contribution_soft ContributionSoft pcp_display_in_roll Boolean sql-strong-type
civicrm_contribution_soft ContributionSoft pcp_id Int sql-strong-type
civicrm_contribution_soft ContributionSoft pcp_personal_note String string-quasi-encoded-?
civicrm_contribution_soft ContributionSoft pcp_roll_nickname String string-quasi-encoded-?
civicrm_contribution_soft ContributionSoft soft_credit_type_id Int sql-strong-type
civicrm_contribution_widget *NONE* about Text string-quasi-encoded-?
civicrm_contribution_widget *NONE* button_title String string-quasi-encoded-?
civicrm_contribution_widget *NONE* color_about_link String string-quasi-encoded-?
civicrm_contribution_widget *NONE* color_bar String string-quasi-encoded-?
civicrm_contribution_widget *NONE* color_bg String string-quasi-encoded-?
civicrm_contribution_widget *NONE* color_button String string-quasi-encoded-?
civicrm_contribution_widget *NONE* color_homepage_link String string-quasi-encoded-?
civicrm_contribution_widget *NONE* color_main String string-quasi-encoded-?
civicrm_contribution_widget *NONE* color_main_bg String string-quasi-encoded-?
civicrm_contribution_widget *NONE* color_main_text String string-quasi-encoded-?
civicrm_contribution_widget *NONE* color_title String string-quasi-encoded-?
civicrm_contribution_widget *NONE* contribution_page_id Int sql-strong-type
civicrm_contribution_widget *NONE* id Int sql-strong-type
civicrm_contribution_widget *NONE* is_active Boolean sql-strong-type
civicrm_contribution_widget *NONE* title String string-quasi-encoded-?
civicrm_contribution_widget *NONE* url_homepage String string-quasi-encoded-?
civicrm_contribution_widget *NONE* url_logo String string-quasi-encoded-?
civicrm_country Country address_format_id Int sql-strong-type
civicrm_country Country country_code String string-quasi-encoded-?
civicrm_country Country id Int sql-strong-type
civicrm_country Country idd_prefix String string-quasi-encoded-?
civicrm_country Country is_province_abbreviated Boolean sql-strong-type
civicrm_country Country iso_code String string-quasi-encoded-?
civicrm_country Country name String string-quasi-encoded-?
civicrm_country Country ndd_prefix String string-quasi-encoded-?
civicrm_country Country region_id Int sql-strong-type
civicrm_county *NONE* abbreviation String string-quasi-encoded-?
civicrm_county *NONE* id Int sql-strong-type
civicrm_county *NONE* name String string-quasi-encoded-?
civicrm_county *NONE* state_province_id Int sql-strong-type
civicrm_currency *NONE* full_name String string-quasi-encoded-?
civicrm_currency *NONE* id Int sql-strong-type
civicrm_currency *NONE* name String string-quasi-encoded-?
civicrm_currency *NONE* numeric_code String string-quasi-encoded-?
civicrm_currency *NONE* symbol String string-quasi-encoded-?
civicrm_custom_field CustomField attributes String string-quasi-encoded-?
civicrm_custom_field CustomField column_name String string-quasi-encoded-?
civicrm_custom_field CustomField custom_group_id Int sql-strong-type
civicrm_custom_field CustomField data_type String string-quasi-encoded-?
civicrm_custom_field CustomField date_format String string-quasi-encoded-?
civicrm_custom_field CustomField default_value String string-quasi-encoded-?
civicrm_custom_field CustomField end_date_years Int sql-strong-type
civicrm_custom_field CustomField filter String string-quasi-encoded-?
civicrm_custom_field CustomField help_post Text string-canonical
civicrm_custom_field CustomField help_pre Text string-canonical
civicrm_custom_field CustomField html_type String string-quasi-encoded-?
civicrm_custom_field CustomField id Int sql-strong-type
civicrm_custom_field CustomField in_selector Boolean sql-strong-type
civicrm_custom_field CustomField is_active Boolean sql-strong-type
civicrm_custom_field CustomField is_required Boolean sql-strong-type
civicrm_custom_field CustomField is_search_range Boolean sql-strong-type
civicrm_custom_field CustomField is_searchable Boolean sql-strong-type
civicrm_custom_field CustomField is_view Boolean sql-strong-type
civicrm_custom_field CustomField javascript String string-quasi-encoded-?
civicrm_custom_field CustomField label String string-canonical
civicrm_custom_field CustomField mask String string-quasi-encoded-?
civicrm_custom_field CustomField name String string-quasi-encoded-?
civicrm_custom_field CustomField note_columns Int sql-strong-type
civicrm_custom_field CustomField note_rows Int sql-strong-type
civicrm_custom_field CustomField option_group_id Int sql-strong-type
civicrm_custom_field CustomField options_per_line Int sql-strong-type
civicrm_custom_field CustomField start_date_years Int sql-strong-type
civicrm_custom_field CustomField text_length Int sql-strong-type
civicrm_custom_field CustomField time_format Int sql-strong-type
civicrm_custom_field CustomField weight Int sql-strong-type
civicrm_custom_group CustomGroup collapse_adv_display Int sql-strong-type
civicrm_custom_group CustomGroup collapse_display Int sql-strong-type
civicrm_custom_group CustomGroup created_date Timestamp sql-strong-type
civicrm_custom_group CustomGroup created_id Int sql-strong-type
civicrm_custom_group CustomGroup extends String string-quasi-encoded-?
civicrm_custom_group CustomGroup extends_entity_column_id Int sql-strong-type
civicrm_custom_group CustomGroup extends_entity_column_value String string-quasi-encoded-?
civicrm_custom_group CustomGroup help_post Text string-canonical
civicrm_custom_group CustomGroup help_pre Text string-canonical
civicrm_custom_group CustomGroup id Int sql-strong-type
civicrm_custom_group CustomGroup is_active Boolean sql-strong-type
civicrm_custom_group CustomGroup is_multiple Boolean sql-strong-type
civicrm_custom_group CustomGroup is_public Boolean sql-strong-type
civicrm_custom_group CustomGroup is_reserved Boolean sql-strong-type
civicrm_custom_group CustomGroup max_multiple Int sql-strong-type
civicrm_custom_group CustomGroup min_multiple Int sql-strong-type
civicrm_custom_group CustomGroup name String string-quasi-encoded-?
civicrm_custom_group CustomGroup style String string-quasi-encoded-?
civicrm_custom_group CustomGroup table_name String string-quasi-encoded-?
civicrm_custom_group CustomGroup title String string-quasi-encoded-?
civicrm_custom_group CustomGroup weight Int sql-strong-type
civicrm_cxn Cxn app_guid String string-quasi-encoded-?
civicrm_cxn Cxn app_meta Text string-quasi-encoded-?
civicrm_cxn Cxn created_date Timestamp sql-strong-type
civicrm_cxn Cxn cxn_guid String string-quasi-encoded-?
civicrm_cxn Cxn fetched_date Timestamp sql-strong-type
civicrm_cxn Cxn id Int sql-strong-type
civicrm_cxn Cxn is_active Boolean sql-strong-type
civicrm_cxn Cxn modified_date Timestamp sql-strong-type
civicrm_cxn Cxn options Text string-quasi-encoded-?
civicrm_cxn Cxn perm Text string-quasi-encoded-?
civicrm_cxn Cxn secret Text string-quasi-encoded-?
civicrm_dashboard Dashboard cache_minutes Int sql-strong-type
civicrm_dashboard Dashboard domain_id Int sql-strong-type
civicrm_dashboard Dashboard fullscreen_url String string-quasi-encoded-?
civicrm_dashboard Dashboard id Int sql-strong-type
civicrm_dashboard Dashboard is_active Boolean sql-strong-type
civicrm_dashboard Dashboard is_reserved Boolean sql-strong-type
civicrm_dashboard Dashboard label String string-canonical
civicrm_dashboard Dashboard name String string-quasi-encoded-?
civicrm_dashboard Dashboard permission String string-quasi-encoded-?
civicrm_dashboard Dashboard permission_operator String string-quasi-encoded-?
civicrm_dashboard Dashboard url String string-canonical
civicrm_dashboard_contact DashboardContact column_no Boolean sql-strong-type
civicrm_dashboard_contact DashboardContact contact_id Int sql-strong-type
civicrm_dashboard_contact DashboardContact dashboard_id Int sql-strong-type
civicrm_dashboard_contact DashboardContact id Int sql-strong-type
civicrm_dashboard_contact DashboardContact is_active Boolean sql-strong-type
civicrm_dashboard_contact DashboardContact weight Int sql-strong-type
civicrm_dedupe_exception Exception contact_id1 Int sql-strong-type
civicrm_dedupe_exception Exception contact_id2 Int sql-strong-type
civicrm_dedupe_exception Exception id Int sql-strong-type
civicrm_dedupe_rule Rule dedupe_rule_group_id Int sql-strong-type
civicrm_dedupe_rule Rule id Int sql-strong-type
civicrm_dedupe_rule Rule rule_field String string-quasi-encoded-?
civicrm_dedupe_rule Rule rule_length Int sql-strong-type
civicrm_dedupe_rule Rule rule_table String string-quasi-encoded-?
civicrm_dedupe_rule Rule rule_weight Int sql-strong-type
civicrm_dedupe_rule_group RuleGroup contact_type String string-quasi-encoded-?
civicrm_dedupe_rule_group RuleGroup id Int sql-strong-type
civicrm_dedupe_rule_group RuleGroup is_reserved Boolean sql-strong-type
civicrm_dedupe_rule_group RuleGroup name String string-quasi-encoded-?
civicrm_dedupe_rule_group RuleGroup threshold Int sql-strong-type
civicrm_dedupe_rule_group RuleGroup title String string-quasi-encoded-?
civicrm_dedupe_rule_group RuleGroup used String string-quasi-encoded-?
civicrm_discount *NONE* end_date Date sql-strong-type
civicrm_discount *NONE* entity_id Int sql-strong-type
civicrm_discount *NONE* entity_table String string-quasi-encoded-?
civicrm_discount *NONE* id Int sql-strong-type
civicrm_discount *NONE* participant_discount_name Int sql-strong-type
civicrm_discount *NONE* start_date Date sql-strong-type
civicrm_domain Domain config_backend Text string-quasi-encoded-?
civicrm_domain Domain contact_id Int sql-strong-type
civicrm_domain Domain description String string-canonical
civicrm_domain Domain id Int sql-strong-type
civicrm_domain Domain locale_custom_strings Text string-quasi-encoded-?
civicrm_domain Domain locales Text string-quasi-encoded-?
civicrm_domain Domain name String string-quasi-encoded-?
civicrm_domain Domain version String string-quasi-encoded-?
civicrm_email Email contact_id Int sql-strong-type
civicrm_email Email email String string-quasi-encoded-?
civicrm_email Email hold_date Timestamp sql-strong-type
civicrm_email Email id Int sql-strong-type
civicrm_email Email is_billing Boolean sql-strong-type
civicrm_email Email is_bulkmail Boolean sql-strong-type
civicrm_email Email is_primary Boolean sql-strong-type
civicrm_email Email location_type_id Int sql-strong-type
civicrm_email Email on_hold Int sql-strong-type
civicrm_email Email reset_date Timestamp sql-strong-type
civicrm_email Email signature_html Text string-quasi-encoded-?
civicrm_email Email signature_text Text string-quasi-encoded-?
civicrm_entity_batch EntityBatch batch_id Int sql-strong-type
civicrm_entity_batch EntityBatch entity_id Int sql-strong-type
civicrm_entity_batch EntityBatch entity_table String string-quasi-encoded-?
civicrm_entity_batch EntityBatch id Int sql-strong-type
civicrm_entity_file *NONE* entity_id Int sql-strong-type
civicrm_entity_file *NONE* entity_table String string-quasi-encoded-?
civicrm_entity_file *NONE* file_id Int sql-strong-type
civicrm_entity_file *NONE* id Int sql-strong-type
civicrm_entity_financial_account EntityFinancialAccount account_relationship Int sql-strong-type
civicrm_entity_financial_account EntityFinancialAccount entity_id Int sql-strong-type
civicrm_entity_financial_account EntityFinancialAccount entity_table String string-quasi-encoded-?
civicrm_entity_financial_account EntityFinancialAccount financial_account_id Int sql-strong-type
civicrm_entity_financial_account EntityFinancialAccount id Int sql-strong-type
civicrm_entity_financial_trxn EntityFinancialTrxn amount Money sql-strong-type
civicrm_entity_financial_trxn EntityFinancialTrxn entity_id Int sql-strong-type
civicrm_entity_financial_trxn EntityFinancialTrxn entity_table String string-quasi-encoded-?
civicrm_entity_financial_trxn EntityFinancialTrxn financial_trxn_id Int sql-strong-type
civicrm_entity_financial_trxn EntityFinancialTrxn id Int sql-strong-type
civicrm_entity_tag EntityTag entity_id Int sql-strong-type
civicrm_entity_tag EntityTag entity_table String string-quasi-encoded-?
civicrm_entity_tag EntityTag id Int sql-strong-type
civicrm_entity_tag EntityTag tag_id Int sql-strong-type
civicrm_event Event allow_same_participant_emails Boolean sql-strong-type
civicrm_event Event allow_selfcancelxfer Boolean sql-strong-type
civicrm_event Event approval_req_text Text string-canonical
civicrm_event Event bcc_confirm String string-quasi-encoded-?
civicrm_event Event campaign_id Int sql-strong-type
civicrm_event Event cc_confirm String string-quasi-encoded-?
civicrm_event Event confirm_email_text Text string-canonical
civicrm_event Event confirm_footer_text Text string-canonical
civicrm_event Event confirm_from_email String string-quasi-encoded-?
civicrm_event Event confirm_from_name String string-quasi-encoded-?
civicrm_event Event confirm_text Text string-canonical
civicrm_event Event confirm_title String string-canonical
civicrm_event Event created_date Timestamp sql-strong-type
civicrm_event Event created_id Int sql-strong-type
civicrm_event Event currency String string-quasi-encoded-?
civicrm_event Event dedupe_rule_group_id Int sql-strong-type
civicrm_event Event default_discount_fee_id Int sql-strong-type
civicrm_event Event default_fee_id Int sql-strong-type
civicrm_event Event default_role_id Int sql-strong-type
civicrm_event Event event_description Text string-quasi-encoded-?
civicrm_event Event event_end_date Timestamp sql-strong-type
civicrm_event Event event_full_text Text string-canonical
civicrm_event Event event_start_date Timestamp sql-strong-type
civicrm_event Event event_title String string-quasi-encoded-?
civicrm_event Event event_type_id Int sql-strong-type
civicrm_event Event expiration_time Int sql-strong-type
civicrm_event Event fee_label String string-quasi-encoded-?
civicrm_event Event financial_type_id Int sql-strong-type
civicrm_event Event footer_text Text string-canonical
civicrm_event Event has_waitlist Boolean sql-strong-type
civicrm_event Event id Int sql-strong-type
civicrm_event Event initial_amount_help_text Text string-quasi-encoded-?
civicrm_event Event initial_amount_label String string-quasi-encoded-?
civicrm_event Event intro_text Text string-canonical
civicrm_event Event is_active Boolean sql-strong-type
civicrm_event Event is_billing_required Boolean sql-strong-type
civicrm_event Event is_confirm_enabled Boolean sql-strong-type
civicrm_event Event is_email_confirm Boolean sql-strong-type
civicrm_event Event is_map Boolean sql-strong-type
civicrm_event Event is_monetary Boolean sql-strong-type
civicrm_event Event is_multiple_registrations Boolean sql-strong-type
civicrm_event Event is_online_registration Boolean sql-strong-type
civicrm_event Event is_partial_payment Boolean sql-strong-type
civicrm_event Event is_pay_later Boolean sql-strong-type
civicrm_event Event is_public Boolean sql-strong-type
civicrm_event Event is_share Boolean sql-strong-type
civicrm_event Event is_show_location Boolean sql-strong-type
civicrm_event Event is_template Boolean sql-strong-type
civicrm_event Event loc_block_id Int sql-strong-type
civicrm_event Event max_additional_participants Int sql-strong-type
civicrm_event Event max_participants Int sql-strong-type
civicrm_event Event min_initial_amount Money sql-strong-type
civicrm_event Event parent_event_id Int sql-strong-type
civicrm_event Event participant_listing_id Int sql-strong-type
civicrm_event Event pay_later_receipt Text string-canonical
civicrm_event Event pay_later_text Text string-canonical
civicrm_event Event payment_processor String string-quasi-encoded-?
civicrm_event Event registration_end_date Timestamp sql-strong-type
civicrm_event Event registration_link_text String string-quasi-encoded-?
civicrm_event Event registration_start_date Timestamp sql-strong-type
civicrm_event Event requires_approval Boolean sql-strong-type
civicrm_event Event selfcancelxfer_time Int sql-strong-type
civicrm_event Event slot_label_id Int sql-strong-type
civicrm_event Event summary Text string-quasi-encoded-?
civicrm_event Event template_title String string-quasi-encoded-?
civicrm_event Event thankyou_footer_text Text string-canonical
civicrm_event Event thankyou_text Text string-canonical
civicrm_event Event thankyou_title String string-quasi-encoded-?
civicrm_event Event waitlist_text Text string-canonical
civicrm_event_carts *NONE* cart_id Int sql-strong-type
civicrm_event_carts *NONE* completed Boolean sql-strong-type
civicrm_event_carts *NONE* user_id Int sql-strong-type
civicrm_events_in_carts *NONE* event_cart_id Int sql-strong-type
civicrm_events_in_carts *NONE* event_id Int sql-strong-type
civicrm_events_in_carts *NONE* event_in_cart_id Int sql-strong-type
civicrm_extension Extension file String string-quasi-encoded-?
civicrm_extension Extension full_name String string-quasi-encoded-?
civicrm_extension Extension id Int sql-strong-type
civicrm_extension Extension is_active Boolean sql-strong-type
civicrm_extension Extension label String string-canonical
civicrm_extension Extension name String string-quasi-encoded-?
civicrm_extension Extension schema_version String string-quasi-encoded-?
civicrm_extension Extension type String string-quasi-encoded-?
civicrm_file File created_id Int sql-strong-type
civicrm_file File description String string-canonical
civicrm_file File document Mediumblob string-quasi-encoded-?
civicrm_file File file_type_id Int sql-strong-type
civicrm_file File id Int sql-strong-type
civicrm_file File mime_type String string-quasi-encoded-?
civicrm_file File upload_date Timestamp sql-strong-type
civicrm_file File uri String string-quasi-encoded-?
civicrm_financial_account FinancialAccount account_type_code String string-quasi-encoded-?
civicrm_financial_account FinancialAccount accounting_code String string-quasi-encoded-?
civicrm_financial_account FinancialAccount description String string-canonical
civicrm_financial_account FinancialAccount financial_account_contact_id Int sql-strong-type
civicrm_financial_account FinancialAccount financial_account_type_id Int sql-strong-type
civicrm_financial_account FinancialAccount id Int sql-strong-type
civicrm_financial_account FinancialAccount is_active Boolean sql-strong-type
civicrm_financial_account FinancialAccount is_deductible Boolean sql-strong-type
civicrm_financial_account FinancialAccount is_default Boolean sql-strong-type
civicrm_financial_account FinancialAccount is_header_account Boolean sql-strong-type
civicrm_financial_account FinancialAccount is_reserved Boolean sql-strong-type
civicrm_financial_account FinancialAccount is_tax Boolean sql-strong-type
civicrm_financial_account FinancialAccount name String string-quasi-encoded-?
civicrm_financial_account FinancialAccount parent_id Int sql-strong-type
civicrm_financial_account FinancialAccount tax_rate Money sql-strong-type
civicrm_financial_item FinancialItem amount Money sql-strong-type
civicrm_financial_item FinancialItem contact_id Int sql-strong-type
civicrm_financial_item FinancialItem created_date Timestamp sql-strong-type
civicrm_financial_item FinancialItem currency String string-quasi-encoded-?
civicrm_financial_item FinancialItem description String string-canonical
civicrm_financial_item FinancialItem entity_id Int sql-strong-type
civicrm_financial_item FinancialItem entity_table String string-quasi-encoded-?
civicrm_financial_item FinancialItem financial_account_id Int sql-strong-type
civicrm_financial_item FinancialItem id Int sql-strong-type
civicrm_financial_item FinancialItem status_id Int sql-strong-type
civicrm_financial_item FinancialItem transaction_date Timestamp sql-strong-type
civicrm_financial_trxn FinancialTrxn currency String string-quasi-encoded-?
civicrm_financial_trxn FinancialTrxn fee_amount Money sql-strong-type
civicrm_financial_trxn FinancialTrxn financial_trxn_card_type_id Int sql-strong-type
civicrm_financial_trxn FinancialTrxn financial_trxn_check_number String string-quasi-encoded-?
civicrm_financial_trxn FinancialTrxn financial_trxn_pan_truncation String string-quasi-encoded-?
civicrm_financial_trxn FinancialTrxn financial_trxn_payment_instrument_id Int sql-strong-type
civicrm_financial_trxn FinancialTrxn from_financial_account_id Int sql-strong-type
civicrm_financial_trxn FinancialTrxn id Int sql-strong-type
civicrm_financial_trxn FinancialTrxn is_payment Boolean sql-strong-type
civicrm_financial_trxn FinancialTrxn net_amount Money sql-strong-type
civicrm_financial_trxn FinancialTrxn payment_processor_id Int sql-strong-type
civicrm_financial_trxn FinancialTrxn status_id Int sql-strong-type
civicrm_financial_trxn FinancialTrxn to_financial_account_id Int sql-strong-type
civicrm_financial_trxn FinancialTrxn total_amount Money sql-strong-type
civicrm_financial_trxn FinancialTrxn trxn_date Timestamp sql-strong-type
civicrm_financial_trxn FinancialTrxn trxn_id String string-quasi-encoded-?
civicrm_financial_trxn FinancialTrxn trxn_result_code String string-quasi-encoded-?
civicrm_financial_type FinancialType description String string-canonical
civicrm_financial_type FinancialType financial_type String string-quasi-encoded-?
civicrm_financial_type FinancialType id Int sql-strong-type
civicrm_financial_type FinancialType is_active Boolean sql-strong-type
civicrm_financial_type FinancialType is_deductible Boolean sql-strong-type
civicrm_financial_type FinancialType is_reserved Boolean sql-strong-type
civicrm_grant Grant amount_granted Money sql-strong-type
civicrm_grant Grant amount_requested Money sql-strong-type
civicrm_grant Grant amount_total Money sql-strong-type
civicrm_grant Grant currency String string-quasi-encoded-?
civicrm_grant Grant financial_type_id Int sql-strong-type
civicrm_grant Grant grant_application_received_date Date sql-strong-type
civicrm_grant Grant grant_contact_id Int sql-strong-type
civicrm_grant Grant grant_decision_date Date sql-strong-type
civicrm_grant Grant grant_due_date Date sql-strong-type
civicrm_grant Grant grant_id Int sql-strong-type
civicrm_grant Grant grant_money_transfer_date Date sql-strong-type
civicrm_grant Grant grant_report_received Boolean sql-strong-type
civicrm_grant Grant grant_status_id Int sql-strong-type
civicrm_grant Grant grant_type_id Int sql-strong-type
civicrm_grant Grant rationale Text string-quasi-encoded-?
civicrm_group Group cache_date Timestamp sql-strong-type
civicrm_group Group children Text string-quasi-encoded-?
civicrm_group Group created_id Int sql-strong-type
civicrm_group Group description Text string-canonical
civicrm_group Group group_type String string-quasi-encoded-?
civicrm_group Group id Int sql-strong-type
civicrm_group Group is_active Boolean sql-strong-type
civicrm_group Group is_hidden Boolean sql-strong-type
civicrm_group Group is_reserved Boolean sql-strong-type
civicrm_group Group modified_id Int sql-strong-type
civicrm_group Group name String string-quasi-encoded-?
civicrm_group Group parents Text string-quasi-encoded-?
civicrm_group Group refresh_date Timestamp sql-strong-type
civicrm_group Group saved_search_id Int sql-strong-type
civicrm_group Group select_tables Text string-quasi-encoded-?
civicrm_group Group source String string-quasi-encoded-?
civicrm_group Group title String string-quasi-encoded-?
civicrm_group Group visibility String string-quasi-encoded-?
civicrm_group Group where_clause Text string-quasi-encoded-?
civicrm_group Group where_tables Text string-quasi-encoded-?
civicrm_group_contact GroupContact contact_id Int sql-strong-type
civicrm_group_contact GroupContact email_id Int sql-strong-type
civicrm_group_contact GroupContact group_id Int sql-strong-type
civicrm_group_contact GroupContact id Int sql-strong-type
civicrm_group_contact GroupContact location_id Int sql-strong-type
civicrm_group_contact GroupContact status String string-quasi-encoded-?
civicrm_group_contact_cache *NONE* contact_id Int sql-strong-type
civicrm_group_contact_cache *NONE* group_id Int sql-strong-type
civicrm_group_contact_cache *NONE* id Int sql-strong-type
civicrm_group_nesting GroupNesting child_group_id Int sql-strong-type
civicrm_group_nesting GroupNesting id Int sql-strong-type
civicrm_group_nesting GroupNesting parent_group_id Int sql-strong-type
civicrm_group_organization GroupOrganization group_id Int sql-strong-type
civicrm_group_organization GroupOrganization id Int sql-strong-type
civicrm_group_organization GroupOrganization organization_id Int sql-strong-type
civicrm_im *NONE* contact_id Int sql-strong-type
civicrm_im *NONE* id Int sql-strong-type
civicrm_im *NONE* is_billing Boolean sql-strong-type
civicrm_im *NONE* is_primary Boolean sql-strong-type
civicrm_im *NONE* location_type_id Int sql-strong-type
civicrm_im *NONE* name String string-quasi-encoded-?
civicrm_im *NONE* provider_id Int sql-strong-type
civicrm_job Job api_action String string-quasi-encoded-?
civicrm_job Job api_entity String string-quasi-encoded-?
civicrm_job Job description String string-canonical
civicrm_job Job domain_id Int sql-strong-type
civicrm_job Job id Int sql-strong-type
civicrm_job Job is_active Boolean sql-strong-type
civicrm_job Job last_run Timestamp sql-strong-type
civicrm_job Job name String string-quasi-encoded-?
civicrm_job Job parameters Text string-quasi-encoded-?
civicrm_job Job run_frequency String string-quasi-encoded-?
civicrm_job Job scheduled_run_date Timestamp sql-strong-type
civicrm_job_log JobLog command String string-quasi-encoded-?
civicrm_job_log JobLog data Text string-canonical
civicrm_job_log JobLog description String string-canonical
civicrm_job_log JobLog domain_id Int sql-strong-type
civicrm_job_log JobLog id Int sql-strong-type
civicrm_job_log JobLog job_id Int sql-strong-type
civicrm_job_log JobLog name String string-quasi-encoded-?
civicrm_job_log JobLog run_time Timestamp sql-strong-type
civicrm_line_item LineItem contribution_id Int sql-strong-type
civicrm_line_item LineItem entity_id Int sql-strong-type
civicrm_line_item LineItem entity_table String string-quasi-encoded-?
civicrm_line_item LineItem financial_type_id Int sql-strong-type
civicrm_line_item LineItem id Int sql-strong-type
civicrm_line_item LineItem label String string-canonical
civicrm_line_item LineItem line_total Money sql-strong-type
civicrm_line_item LineItem non_deductible_amount Money sql-strong-type
civicrm_line_item LineItem participant_count Int sql-strong-type
civicrm_line_item LineItem price_field_id Int sql-strong-type
civicrm_line_item LineItem price_field_value_id Int sql-strong-type
civicrm_line_item LineItem qty Money sql-strong-type
civicrm_line_item LineItem tax_amount Money sql-strong-type
civicrm_line_item LineItem unit_price Money sql-strong-type
civicrm_loc_block LocBlock address_2_id Int sql-strong-type
civicrm_loc_block LocBlock address_id Int sql-strong-type
civicrm_loc_block LocBlock email_2_id Int sql-strong-type
civicrm_loc_block LocBlock email_id Int sql-strong-type
civicrm_loc_block LocBlock id Int sql-strong-type
civicrm_loc_block LocBlock im_2_id Int sql-strong-type
civicrm_loc_block LocBlock im_id Int sql-strong-type
civicrm_loc_block LocBlock phone_2_id Int sql-strong-type
civicrm_loc_block LocBlock phone_id Int sql-strong-type
civicrm_location_type LocationType description String string-canonical
civicrm_location_type LocationType display_name String string-quasi-encoded-?
civicrm_location_type LocationType id Int sql-strong-type
civicrm_location_type LocationType is_active Boolean sql-strong-type
civicrm_location_type LocationType is_default Boolean sql-strong-type
civicrm_location_type LocationType is_reserved Boolean sql-strong-type
civicrm_location_type LocationType name String string-quasi-encoded-?
civicrm_location_type LocationType vcard_name String string-quasi-encoded-?
civicrm_log *NONE* data Text string-canonical
civicrm_log *NONE* entity_id Int sql-strong-type
civicrm_log *NONE* entity_table String string-quasi-encoded-?
civicrm_log *NONE* id Int sql-strong-type
civicrm_log *NONE* modified_date Timestamp sql-strong-type
civicrm_log *NONE* modified_id Int sql-strong-type
civicrm_mail_settings MailSettings activity_status String string-quasi-encoded-?
civicrm_mail_settings MailSettings domain String string-quasi-encoded-?
civicrm_mail_settings MailSettings domain_id Int sql-strong-type
civicrm_mail_settings MailSettings id Int sql-strong-type
civicrm_mail_settings MailSettings is_default Boolean sql-strong-type
civicrm_mail_settings MailSettings is_ssl Boolean sql-strong-type
civicrm_mail_settings MailSettings localpart String string-quasi-encoded-?
civicrm_mail_settings MailSettings name String string-quasi-encoded-?
civicrm_mail_settings MailSettings password String string-quasi-encoded-?
civicrm_mail_settings MailSettings port Int sql-strong-type
civicrm_mail_settings MailSettings protocol String string-quasi-encoded-?
civicrm_mail_settings MailSettings return_path String string-quasi-encoded-?
civicrm_mail_settings MailSettings server String string-quasi-encoded-?
civicrm_mail_settings MailSettings source String string-quasi-encoded-?
civicrm_mail_settings MailSettings username String string-quasi-encoded-?
civicrm_mailing Mailing approval_date Timestamp sql-strong-type
civicrm_mailing Mailing approval_note Text string-quasi-encoded-?
civicrm_mailing Mailing approval_status_id Int sql-strong-type
civicrm_mailing Mailing approver_id Int sql-strong-type
civicrm_mailing Mailing auto_responder Boolean sql-strong-type
civicrm_mailing Mailing body_html Text string-canonical
civicrm_mailing Mailing body_text Text string-canonical
civicrm_mailing Mailing campaign_id Int sql-strong-type
civicrm_mailing Mailing created_date Timestamp sql-strong-type
civicrm_mailing Mailing created_id Int sql-strong-type
civicrm_mailing Mailing dedupe_email Boolean sql-strong-type
civicrm_mailing Mailing domain_id Int sql-strong-type
civicrm_mailing Mailing email_selection_method String string-quasi-encoded-?
civicrm_mailing Mailing footer_id Int sql-strong-type
civicrm_mailing Mailing forward_replies Boolean sql-strong-type
civicrm_mailing Mailing from_email String string-quasi-encoded-?
civicrm_mailing Mailing from_name String string-quasi-encoded-?
civicrm_mailing Mailing hash String string-quasi-encoded-?
civicrm_mailing Mailing header_id Int sql-strong-type
civicrm_mailing Mailing id Int sql-strong-type
civicrm_mailing Mailing is_archived Boolean sql-strong-type
civicrm_mailing Mailing is_completed Boolean sql-strong-type
civicrm_mailing Mailing language String string-quasi-encoded-?
civicrm_mailing Mailing location_type_id Int sql-strong-type
civicrm_mailing Mailing mailing_modified_date Timestamp sql-strong-type
civicrm_mailing Mailing mailing_type String string-quasi-encoded-?
civicrm_mailing Mailing msg_template_id Int sql-strong-type
civicrm_mailing Mailing name String string-quasi-encoded-?
civicrm_mailing Mailing open_tracking Boolean sql-strong-type
civicrm_mailing Mailing optout_id Int sql-strong-type
civicrm_mailing Mailing override_verp Boolean sql-strong-type
civicrm_mailing Mailing reply_id Int sql-strong-type
civicrm_mailing Mailing replyto_email String string-canonical
civicrm_mailing Mailing resubscribe_id Int sql-strong-type
civicrm_mailing Mailing scheduled_date Timestamp sql-strong-type
civicrm_mailing Mailing scheduled_id Int sql-strong-type
civicrm_mailing Mailing sms_provider_id Int sql-strong-type
civicrm_mailing Mailing subject String string-quasi-encoded-?
civicrm_mailing Mailing template_options Text string-quasi-encoded-?
civicrm_mailing Mailing template_type String string-quasi-encoded-?
civicrm_mailing Mailing unsubscribe_id Int sql-strong-type
civicrm_mailing Mailing url_tracking Boolean sql-strong-type
civicrm_mailing Mailing visibility String string-quasi-encoded-?
civicrm_mailing_abtest MailingAB created_date Timestamp sql-strong-type
civicrm_mailing_abtest MailingAB created_id Int sql-strong-type
civicrm_mailing_abtest MailingAB declare_winning_time Timestamp sql-strong-type
civicrm_mailing_abtest MailingAB domain_id Int sql-strong-type
civicrm_mailing_abtest MailingAB group_percentage Int sql-strong-type
civicrm_mailing_abtest MailingAB id Int sql-strong-type
civicrm_mailing_abtest MailingAB mailing_id_a Int sql-strong-type
civicrm_mailing_abtest MailingAB mailing_id_b Int sql-strong-type
civicrm_mailing_abtest MailingAB mailing_id_c Int sql-strong-type
civicrm_mailing_abtest MailingAB name String string-quasi-encoded-?
civicrm_mailing_abtest MailingAB specific_url String string-quasi-encoded-?
civicrm_mailing_abtest MailingAB status String string-quasi-encoded-?
civicrm_mailing_abtest MailingAB testing_criteria String string-quasi-encoded-?
civicrm_mailing_abtest MailingAB winner_criteria String string-quasi-encoded-?
civicrm_mailing_bounce_pattern *NONE* bounce_type_id Int sql-strong-type
civicrm_mailing_bounce_pattern *NONE* id Int sql-strong-type
civicrm_mailing_bounce_pattern *NONE* pattern String string-quasi-encoded-?
civicrm_mailing_bounce_type *NONE* description String string-canonical
civicrm_mailing_bounce_type *NONE* hold_threshold Int sql-strong-type
civicrm_mailing_bounce_type *NONE* id Int sql-strong-type
civicrm_mailing_bounce_type *NONE* name String string-quasi-encoded-?
civicrm_mailing_component MailingComponent body_html Text string-canonical
civicrm_mailing_component MailingComponent body_text Text string-canonical
civicrm_mailing_component MailingComponent component_type String string-quasi-encoded-?
civicrm_mailing_component MailingComponent id Int sql-strong-type
civicrm_mailing_component MailingComponent is_active Boolean sql-strong-type
civicrm_mailing_component MailingComponent is_default Boolean sql-strong-type
civicrm_mailing_component MailingComponent name String string-quasi-encoded-?
civicrm_mailing_component MailingComponent subject String string-quasi-encoded-?
civicrm_mailing_event_bounce *NONE* bounce_reason String string-quasi-encoded-?
civicrm_mailing_event_bounce *NONE* bounce_type_id Int sql-strong-type
civicrm_mailing_event_bounce *NONE* event_queue_id Int sql-strong-type
civicrm_mailing_event_bounce *NONE* id Int sql-strong-type
civicrm_mailing_event_bounce *NONE* time_stamp Timestamp sql-strong-type
civicrm_mailing_event_confirm *NONE* event_subscribe_id Int sql-strong-type
civicrm_mailing_event_confirm *NONE* id Int sql-strong-type
civicrm_mailing_event_confirm *NONE* time_stamp Timestamp sql-strong-type
civicrm_mailing_event_delivered *NONE* event_queue_id Int sql-strong-type
civicrm_mailing_event_delivered *NONE* id Int sql-strong-type
civicrm_mailing_event_delivered *NONE* time_stamp Timestamp sql-strong-type
civicrm_mailing_event_forward *NONE* dest_queue_id Int sql-strong-type
civicrm_mailing_event_forward *NONE* event_queue_id Int sql-strong-type
civicrm_mailing_event_forward *NONE* id Int sql-strong-type
civicrm_mailing_event_forward *NONE* time_stamp Timestamp sql-strong-type
civicrm_mailing_event_opened *NONE* event_queue_id Int sql-strong-type
civicrm_mailing_event_opened *NONE* id Int sql-strong-type
civicrm_mailing_event_opened *NONE* time_stamp Timestamp sql-strong-type
civicrm_mailing_event_queue *NONE* contact_id Int sql-strong-type
civicrm_mailing_event_queue *NONE* email_id Int sql-strong-type
civicrm_mailing_event_queue *NONE* hash String string-quasi-encoded-?
civicrm_mailing_event_queue *NONE* id Int sql-strong-type
civicrm_mailing_event_queue *NONE* job_id Int sql-strong-type
civicrm_mailing_event_queue *NONE* phone_id Int sql-strong-type
civicrm_mailing_event_reply *NONE* event_queue_id Int sql-strong-type
civicrm_mailing_event_reply *NONE* id Int sql-strong-type
civicrm_mailing_event_reply *NONE* time_stamp Timestamp sql-strong-type
civicrm_mailing_event_subscribe *NONE* contact_id Int sql-strong-type
civicrm_mailing_event_subscribe *NONE* group_id Int sql-strong-type
civicrm_mailing_event_subscribe *NONE* hash String string-quasi-encoded-?
civicrm_mailing_event_subscribe *NONE* id Int sql-strong-type
civicrm_mailing_event_subscribe *NONE* time_stamp Timestamp sql-strong-type
civicrm_mailing_event_trackable_url_open *NONE* event_queue_id Int sql-strong-type
civicrm_mailing_event_trackable_url_open *NONE* id Int sql-strong-type
civicrm_mailing_event_trackable_url_open *NONE* time_stamp Timestamp sql-strong-type
civicrm_mailing_event_trackable_url_open *NONE* trackable_url_id Int sql-strong-type
civicrm_mailing_event_unsubscribe *NONE* event_queue_id Int sql-strong-type
civicrm_mailing_event_unsubscribe *NONE* id Int sql-strong-type
civicrm_mailing_event_unsubscribe *NONE* org_unsubscribe Boolean sql-strong-type
civicrm_mailing_event_unsubscribe *NONE* time_stamp Timestamp sql-strong-type
civicrm_mailing_group MailingGroup entity_id Int sql-strong-type
civicrm_mailing_group MailingGroup entity_table String string-quasi-encoded-?
civicrm_mailing_group MailingGroup group_type String string-quasi-encoded-?
civicrm_mailing_group MailingGroup id Int sql-strong-type
civicrm_mailing_group MailingGroup mailing_id Int sql-strong-type
civicrm_mailing_group MailingGroup search_args Text string-quasi-encoded-?
civicrm_mailing_group MailingGroup search_id Int sql-strong-type
civicrm_mailing_job MailingJob end_date Timestamp sql-strong-type
civicrm_mailing_job MailingJob id Int sql-strong-type
civicrm_mailing_job MailingJob is_test Boolean sql-strong-type
civicrm_mailing_job MailingJob job_limit Int sql-strong-type
civicrm_mailing_job MailingJob job_offset Int sql-strong-type
civicrm_mailing_job MailingJob job_type String string-quasi-encoded-?
civicrm_mailing_job MailingJob mailing_id Int sql-strong-type
civicrm_mailing_job MailingJob mailing_job_start_date Timestamp sql-strong-type
civicrm_mailing_job MailingJob parent_id Int sql-strong-type
civicrm_mailing_job MailingJob scheduled_date Timestamp sql-strong-type
civicrm_mailing_job MailingJob status String string-quasi-encoded-?
civicrm_mailing_recipients *NONE* contact_id Int sql-strong-type
civicrm_mailing_recipients *NONE* email_id Int sql-strong-type
civicrm_mailing_recipients *NONE* id Int sql-strong-type
civicrm_mailing_recipients *NONE* mailing_id Int sql-strong-type
civicrm_mailing_recipients *NONE* phone_id Int sql-strong-type
civicrm_mailing_spool *NONE* added_at Timestamp sql-strong-type
civicrm_mailing_spool *NONE* body Text string-quasi-encoded-?
civicrm_mailing_spool *NONE* headers Text string-quasi-encoded-?
civicrm_mailing_spool *NONE* id Int sql-strong-type
civicrm_mailing_spool *NONE* job_id Int sql-strong-type
civicrm_mailing_spool *NONE* recipient_email Text string-quasi-encoded-?
civicrm_mailing_spool *NONE* removed_at Timestamp sql-strong-type
civicrm_mailing_trackable_url *NONE* id Int sql-strong-type
civicrm_mailing_trackable_url *NONE* mailing_id Int sql-strong-type
civicrm_mailing_trackable_url *NONE* url Text string-canonical
civicrm_managed *NONE* cleanup String string-quasi-encoded-?
civicrm_managed *NONE* entity_id Int sql-strong-type
civicrm_managed *NONE* entity_type String string-quasi-encoded-?
civicrm_managed *NONE* id Int sql-strong-type
civicrm_managed *NONE* module String string-quasi-encoded-?
civicrm_managed *NONE* name String string-quasi-encoded-?
civicrm_mapping Mapping description String string-canonical
civicrm_mapping Mapping id Int sql-strong-type
civicrm_mapping Mapping mapping_type_id Int sql-strong-type
civicrm_mapping Mapping name String string-quasi-encoded-?
civicrm_mapping_field MappingField column_number Int sql-strong-type
civicrm_mapping_field MappingField contact_type String string-quasi-encoded-?
civicrm_mapping_field MappingField grouping Int sql-strong-type
civicrm_mapping_field MappingField id Int sql-strong-type
civicrm_mapping_field MappingField im_provider_id Int sql-strong-type
civicrm_mapping_field MappingField location_type_id Int sql-strong-type
civicrm_mapping_field MappingField mapping_id Int sql-strong-type
civicrm_mapping_field MappingField name String string-quasi-encoded-?
civicrm_mapping_field MappingField operator String string-canonical
civicrm_mapping_field MappingField phone_type_id Int sql-strong-type
civicrm_mapping_field MappingField relationship_direction String string-quasi-encoded-?
civicrm_mapping_field MappingField relationship_type_id Int sql-strong-type
civicrm_mapping_field MappingField value String string-quasi-encoded-?
civicrm_mapping_field MappingField website_type_id Int sql-strong-type
civicrm_membership Membership max_related Int sql-strong-type
civicrm_membership Membership member_campaign_id Int sql-strong-type
civicrm_membership Membership member_is_override Boolean sql-strong-type
civicrm_membership Membership member_is_pay_later Boolean sql-strong-type
civicrm_membership Membership member_is_test Boolean sql-strong-type
civicrm_membership Membership membership_contact_id Int sql-strong-type
civicrm_membership Membership membership_end_date Date sql-strong-type
civicrm_membership Membership membership_id Int sql-strong-type
civicrm_membership Membership membership_join_date Date sql-strong-type
civicrm_membership Membership membership_recur_id Int sql-strong-type
civicrm_membership Membership membership_source String string-quasi-encoded-?
civicrm_membership Membership membership_start_date Date sql-strong-type
civicrm_membership Membership membership_type_id Int sql-strong-type
civicrm_membership Membership owner_membership_id Int sql-strong-type
civicrm_membership Membership status_id Int sql-strong-type
civicrm_membership Membership status_override_end_date Date sql-strong-type
civicrm_membership_block MembershipBlock display_min_fee Boolean sql-strong-type
civicrm_membership_block MembershipBlock entity_id Int sql-strong-type
civicrm_membership_block MembershipBlock entity_table String string-quasi-encoded-?
civicrm_membership_block MembershipBlock id Int sql-strong-type
civicrm_membership_block MembershipBlock is_active Boolean sql-strong-type
civicrm_membership_block MembershipBlock is_required Boolean sql-strong-type
civicrm_membership_block MembershipBlock is_separate_payment Boolean sql-strong-type
civicrm_membership_block MembershipBlock membership_type_default Int sql-strong-type
civicrm_membership_block MembershipBlock membership_types String string-quasi-encoded-?
civicrm_membership_block MembershipBlock new_text Text string-canonical
civicrm_membership_block MembershipBlock new_title String string-quasi-encoded-?
civicrm_membership_block MembershipBlock renewal_text Text string-canonical
civicrm_membership_block MembershipBlock renewal_title String string-quasi-encoded-?
civicrm_membership_log MembershipLog end_date Date sql-strong-type
civicrm_membership_log MembershipLog id Int sql-strong-type
civicrm_membership_log MembershipLog max_related Int sql-strong-type
civicrm_membership_log MembershipLog membership_id Int sql-strong-type
civicrm_membership_log MembershipLog membership_type_id Int sql-strong-type
civicrm_membership_log MembershipLog modified_date Date sql-strong-type
civicrm_membership_log MembershipLog modified_id Int sql-strong-type
civicrm_membership_log MembershipLog start_date Date sql-strong-type
civicrm_membership_log MembershipLog status_id Int sql-strong-type
civicrm_membership_payment MembershipPayment contribution_id Int sql-strong-type
civicrm_membership_payment MembershipPayment id Int sql-strong-type
civicrm_membership_payment MembershipPayment membership_id Int sql-strong-type
civicrm_membership_status MembershipStatus end_event String string-quasi-encoded-?
civicrm_membership_status MembershipStatus end_event_adjust_interval Int sql-strong-type
civicrm_membership_status MembershipStatus end_event_adjust_unit String string-quasi-encoded-?
civicrm_membership_status MembershipStatus id Int sql-strong-type
civicrm_membership_status MembershipStatus is_active Boolean sql-strong-type
civicrm_membership_status MembershipStatus is_admin Boolean sql-strong-type
civicrm_membership_status MembershipStatus is_current_member Boolean sql-strong-type
civicrm_membership_status MembershipStatus is_default Boolean sql-strong-type
civicrm_membership_status MembershipStatus is_reserved Boolean sql-strong-type
civicrm_membership_status MembershipStatus label String string-canonical
civicrm_membership_status MembershipStatus membership_status String string-quasi-encoded-?
civicrm_membership_status MembershipStatus start_event String string-quasi-encoded-?
civicrm_membership_status MembershipStatus start_event_adjust_interval Int sql-strong-type
civicrm_membership_status MembershipStatus start_event_adjust_unit String string-quasi-encoded-?
civicrm_membership_status MembershipStatus weight Int sql-strong-type
civicrm_membership_type MembershipType auto_renew Boolean sql-strong-type
civicrm_membership_type MembershipType description String string-canonical
civicrm_membership_type MembershipType domain_id Int sql-strong-type
civicrm_membership_type MembershipType duration_interval Int sql-strong-type
civicrm_membership_type MembershipType duration_unit String string-quasi-encoded-?
civicrm_membership_type MembershipType financial_type_id Int sql-strong-type
civicrm_membership_type MembershipType fixed_period_rollover_day Int sql-strong-type
civicrm_membership_type MembershipType fixed_period_start_day Int sql-strong-type
civicrm_membership_type MembershipType id Int sql-strong-type
civicrm_membership_type MembershipType is_active Boolean sql-strong-type
civicrm_membership_type MembershipType max_related Int sql-strong-type
civicrm_membership_type MembershipType member_of_contact_id Int sql-strong-type
civicrm_membership_type MembershipType membership_type String string-quasi-encoded-?
civicrm_membership_type MembershipType minimum_fee Money sql-strong-type
civicrm_membership_type MembershipType period_type String string-quasi-encoded-?
civicrm_membership_type MembershipType receipt_text_renewal String string-quasi-encoded-?
civicrm_membership_type MembershipType receipt_text_signup String string-quasi-encoded-?
civicrm_membership_type MembershipType relationship_direction String string-quasi-encoded-?
civicrm_membership_type MembershipType relationship_type_id String string-quasi-encoded-?
civicrm_membership_type MembershipType visibility String string-quasi-encoded-?
civicrm_membership_type MembershipType weight Int sql-strong-type
civicrm_menu *NONE* access_arguments Text string-quasi-encoded-?
civicrm_menu *NONE* access_callback String string-quasi-encoded-?
civicrm_menu *NONE* breadcrumb Text string-quasi-encoded-?
civicrm_menu *NONE* component_id Int sql-strong-type
civicrm_menu *NONE* domain_id Int sql-strong-type
civicrm_menu *NONE* id Int sql-strong-type
civicrm_menu *NONE* is_active Boolean sql-strong-type
civicrm_menu *NONE* is_exposed Boolean sql-strong-type
civicrm_menu *NONE* is_public Boolean sql-strong-type
civicrm_menu *NONE* is_ssl Boolean sql-strong-type
civicrm_menu *NONE* module_data Text string-quasi-encoded-?
civicrm_menu *NONE* page_arguments Text string-quasi-encoded-?
civicrm_menu *NONE* page_callback String string-quasi-encoded-?
civicrm_menu *NONE* page_type Int sql-strong-type
civicrm_menu *NONE* path String string-quasi-encoded-?
civicrm_menu *NONE* path_arguments Text string-quasi-encoded-?
civicrm_menu *NONE* return_url String string-quasi-encoded-?
civicrm_menu *NONE* return_url_args String string-quasi-encoded-?
civicrm_menu *NONE* skipBreadcrumb Boolean sql-strong-type
civicrm_menu *NONE* title String string-quasi-encoded-?
civicrm_menu *NONE* type Int sql-strong-type
civicrm_menu *NONE* weight Int sql-strong-type
civicrm_mosaico_template MosaicoTemplate base String string-quasi-encoded-?
civicrm_mosaico_template MosaicoTemplate content Text string-canonical
civicrm_mosaico_template MosaicoTemplate html Text string-quasi-encoded-?
civicrm_mosaico_template MosaicoTemplate id Int sql-strong-type
civicrm_mosaico_template MosaicoTemplate metadata Text string-quasi-encoded-?
civicrm_mosaico_template MosaicoTemplate msg_tpl_id Int sql-strong-type
civicrm_mosaico_template MosaicoTemplate title String string-quasi-encoded-?
civicrm_msg_template MessageTemplate id Int sql-strong-type
civicrm_msg_template MessageTemplate is_active Boolean sql-strong-type
civicrm_msg_template MessageTemplate is_default Boolean sql-strong-type
civicrm_msg_template MessageTemplate is_reserved Boolean sql-strong-type
civicrm_msg_template MessageTemplate is_sms Boolean sql-strong-type
civicrm_msg_template MessageTemplate msg_html Text string-canonical
civicrm_msg_template MessageTemplate msg_subject Text string-quasi-encoded-?
civicrm_msg_template MessageTemplate msg_text Text string-canonical
civicrm_msg_template MessageTemplate msg_title String string-quasi-encoded-?
civicrm_msg_template MessageTemplate pdf_format_id Int sql-strong-type
civicrm_msg_template MessageTemplate workflow_id Int sql-strong-type
civicrm_navigation Navigation domain_id Int sql-strong-type
civicrm_navigation Navigation has_separator Boolean sql-strong-type
civicrm_navigation Navigation icon String string-quasi-encoded-?
civicrm_navigation Navigation id Int sql-strong-type
civicrm_navigation Navigation is_active Boolean sql-strong-type
civicrm_navigation Navigation label String string-canonical
civicrm_navigation Navigation name String string-quasi-encoded-?
civicrm_navigation Navigation parent_id Int sql-strong-type
civicrm_navigation Navigation permission String string-quasi-encoded-?
civicrm_navigation Navigation permission_operator String string-quasi-encoded-?
civicrm_navigation Navigation url String string-canonical
civicrm_navigation Navigation weight Int sql-strong-type
civicrm_note Note contact_id Int sql-strong-type
civicrm_note Note entity_id Int sql-strong-type
civicrm_note Note entity_table String string-quasi-encoded-?
civicrm_note Note id Int sql-strong-type
civicrm_note Note modified_date Date sql-strong-type
civicrm_note Note note Text string-quasi-encoded-?
civicrm_note Note privacy String string-quasi-encoded-?
civicrm_note Note subject String string-quasi-encoded-?
civicrm_openid OpenID allowed_to_login Boolean sql-strong-type
civicrm_openid OpenID contact_id Int sql-strong-type
civicrm_openid OpenID id Int sql-strong-type
civicrm_openid OpenID is_primary Boolean sql-strong-type
civicrm_openid OpenID location_type_id Int sql-strong-type
civicrm_openid OpenID openid String string-quasi-encoded-?
civicrm_option_group OptionGroup data_type String string-quasi-encoded-?
civicrm_option_group OptionGroup description String string-canonical
civicrm_option_group OptionGroup id Int sql-strong-type
civicrm_option_group OptionGroup is_active Boolean sql-strong-type
civicrm_option_group OptionGroup is_locked Boolean sql-strong-type
civicrm_option_group OptionGroup is_reserved Boolean sql-strong-type
civicrm_option_group OptionGroup name String string-quasi-encoded-?
civicrm_option_group OptionGroup title String string-quasi-encoded-?
civicrm_option_value OptionValue color String string-quasi-encoded-?
civicrm_option_value OptionValue component_id Int sql-strong-type
civicrm_option_value OptionValue description Text string-canonical
civicrm_option_value OptionValue domain_id Int sql-strong-type
civicrm_option_value OptionValue filter Int sql-strong-type
civicrm_option_value OptionValue grouping String string-quasi-encoded-?
civicrm_option_value OptionValue icon String string-quasi-encoded-?
civicrm_option_value OptionValue id Int sql-strong-type
civicrm_option_value OptionValue is_active Boolean sql-strong-type
civicrm_option_value OptionValue is_default Boolean sql-strong-type
civicrm_option_value OptionValue is_optgroup Boolean sql-strong-type
civicrm_option_value OptionValue is_reserved Boolean sql-strong-type
civicrm_option_value OptionValue label String string-canonical
civicrm_option_value OptionValue name String string-quasi-encoded-?
civicrm_option_value OptionValue option_group_id Int sql-strong-type
civicrm_option_value OptionValue value String string-quasi-encoded-?
civicrm_option_value OptionValue visibility_id Int sql-strong-type
civicrm_option_value OptionValue weight Int sql-strong-type
civicrm_participant Participant cart_id Int sql-strong-type
civicrm_participant Participant discount_amount Int sql-strong-type
civicrm_participant Participant event_id Int sql-strong-type
civicrm_participant Participant must_wait Int sql-strong-type
civicrm_participant Participant participant_campaign_id Int sql-strong-type
civicrm_participant Participant participant_contact_id Int sql-strong-type
civicrm_participant Participant participant_discount_id Int sql-strong-type
civicrm_participant Participant participant_fee_amount Money sql-strong-type
civicrm_participant Participant participant_fee_currency String string-quasi-encoded-?
civicrm_participant Participant participant_fee_level Text string-quasi-encoded-?
civicrm_participant Participant participant_id Int sql-strong-type
civicrm_participant Participant participant_is_pay_later Boolean sql-strong-type
civicrm_participant Participant participant_is_test Boolean sql-strong-type
civicrm_participant Participant participant_register_date Timestamp sql-strong-type
civicrm_participant Participant participant_registered_by_id Int sql-strong-type
civicrm_participant Participant participant_role_id String string-quasi-encoded-?
civicrm_participant Participant participant_source String string-quasi-encoded-?
civicrm_participant Participant participant_status_id Int sql-strong-type
civicrm_participant Participant transferred_to_contact_id Int sql-strong-type
civicrm_participant_payment ParticipantPayment contribution_id Int sql-strong-type
civicrm_participant_payment ParticipantPayment id Int sql-strong-type
civicrm_participant_payment ParticipantPayment participant_id Int sql-strong-type
civicrm_participant_status_type ParticipantStatusType class String string-quasi-encoded-?
civicrm_participant_status_type ParticipantStatusType id Int sql-strong-type
civicrm_participant_status_type ParticipantStatusType is_active Boolean sql-strong-type
civicrm_participant_status_type ParticipantStatusType is_counted Boolean sql-strong-type
civicrm_participant_status_type ParticipantStatusType is_reserved Boolean sql-strong-type
civicrm_participant_status_type ParticipantStatusType label String string-canonical
civicrm_participant_status_type ParticipantStatusType participant_status String string-quasi-encoded-?
civicrm_participant_status_type ParticipantStatusType visibility_id Int sql-strong-type
civicrm_participant_status_type ParticipantStatusType weight Int sql-strong-type
civicrm_payment_processor PaymentProcessor accepted_credit_cards Text string-quasi-encoded-?
civicrm_payment_processor PaymentProcessor billing_mode Int sql-strong-type
civicrm_payment_processor PaymentProcessor class_name String string-quasi-encoded-?
civicrm_payment_processor PaymentProcessor description String string-canonical
civicrm_payment_processor PaymentProcessor domain_id Int sql-strong-type
civicrm_payment_processor PaymentProcessor id Int sql-strong-type
civicrm_payment_processor PaymentProcessor is_active Boolean sql-strong-type
civicrm_payment_processor PaymentProcessor is_default Boolean sql-strong-type
civicrm_payment_processor PaymentProcessor is_recur Boolean sql-strong-type
civicrm_payment_processor PaymentProcessor is_test Boolean sql-strong-type
civicrm_payment_processor PaymentProcessor name String string-quasi-encoded-?
civicrm_payment_processor PaymentProcessor password String string-quasi-encoded-?
civicrm_payment_processor PaymentProcessor payment_instrument_id Int sql-strong-type
civicrm_payment_processor PaymentProcessor payment_processor_type_id Int sql-strong-type
civicrm_payment_processor PaymentProcessor payment_type Int sql-strong-type
civicrm_payment_processor PaymentProcessor signature Text string-quasi-encoded-?
civicrm_payment_processor PaymentProcessor subject String string-quasi-encoded-?
civicrm_payment_processor PaymentProcessor title String string-quasi-encoded-?
civicrm_payment_processor PaymentProcessor url_api String string-quasi-encoded-?
civicrm_payment_processor PaymentProcessor url_button String string-quasi-encoded-?
civicrm_payment_processor PaymentProcessor url_recur String string-quasi-encoded-?
civicrm_payment_processor PaymentProcessor url_site String string-quasi-encoded-?
civicrm_payment_processor PaymentProcessor user_name String string-quasi-encoded-?
civicrm_payment_processor_type PaymentProcessorType billing_mode Int sql-strong-type
civicrm_payment_processor_type PaymentProcessorType class_name String string-quasi-encoded-?
civicrm_payment_processor_type PaymentProcessorType description String string-canonical
civicrm_payment_processor_type PaymentProcessorType id Int sql-strong-type
civicrm_payment_processor_type PaymentProcessorType is_active Boolean sql-strong-type
civicrm_payment_processor_type PaymentProcessorType is_default Boolean sql-strong-type
civicrm_payment_processor_type PaymentProcessorType is_recur Boolean sql-strong-type
civicrm_payment_processor_type PaymentProcessorType name String string-quasi-encoded-?
civicrm_payment_processor_type PaymentProcessorType password_label String string-quasi-encoded-?
civicrm_payment_processor_type PaymentProcessorType payment_instrument_id Int sql-strong-type
civicrm_payment_processor_type PaymentProcessorType payment_type Int sql-strong-type
civicrm_payment_processor_type PaymentProcessorType signature_label String string-quasi-encoded-?
civicrm_payment_processor_type PaymentProcessorType subject_label String string-quasi-encoded-?
civicrm_payment_processor_type PaymentProcessorType title String string-quasi-encoded-?
civicrm_payment_processor_type PaymentProcessorType url_api_default String string-quasi-encoded-?
civicrm_payment_processor_type PaymentProcessorType url_api_test_default String string-quasi-encoded-?
civicrm_payment_processor_type PaymentProcessorType url_button_default String string-quasi-encoded-?
civicrm_payment_processor_type PaymentProcessorType url_button_test_default String string-quasi-encoded-?
civicrm_payment_processor_type PaymentProcessorType url_recur_default String string-quasi-encoded-?
civicrm_payment_processor_type PaymentProcessorType url_recur_test_default String string-quasi-encoded-?
civicrm_payment_processor_type PaymentProcessorType url_site_default String string-quasi-encoded-?
civicrm_payment_processor_type PaymentProcessorType url_site_test_default String string-quasi-encoded-?
civicrm_payment_processor_type PaymentProcessorType user_name_label String string-quasi-encoded-?
civicrm_payment_token PaymentToken billing_first_name String string-quasi-encoded-?
civicrm_payment_token PaymentToken billing_last_name String string-quasi-encoded-?
civicrm_payment_token PaymentToken billing_middle_name String string-quasi-encoded-?
civicrm_payment_token PaymentToken contact_id Int sql-strong-type
civicrm_payment_token PaymentToken created_date Timestamp sql-strong-type
civicrm_payment_token PaymentToken created_id Int sql-strong-type
civicrm_payment_token PaymentToken email String string-quasi-encoded-?
civicrm_payment_token PaymentToken expiry_date Timestamp sql-strong-type
civicrm_payment_token PaymentToken ip_address String string-quasi-encoded-?
civicrm_payment_token PaymentToken masked_account_number String string-quasi-encoded-?
civicrm_payment_token PaymentToken payment_processor_id Int sql-strong-type
civicrm_payment_token PaymentToken payment_token_id Int sql-strong-type
civicrm_payment_token PaymentToken token String string-quasi-encoded-?
civicrm_pcp *NONE* currency String string-quasi-encoded-?
civicrm_pcp *NONE* donate_link_text String string-quasi-encoded-?
civicrm_pcp *NONE* goal_amount Money sql-strong-type
civicrm_pcp *NONE* intro_text Text string-canonical
civicrm_pcp *NONE* is_active Boolean sql-strong-type
civicrm_pcp *NONE* is_honor_roll Int sql-strong-type
civicrm_pcp *NONE* is_notify Boolean sql-strong-type
civicrm_pcp *NONE* is_thermometer Int sql-strong-type
civicrm_pcp *NONE* page_id Int sql-strong-type
civicrm_pcp *NONE* page_text Text string-canonical
civicrm_pcp *NONE* page_type String string-quasi-encoded-?
civicrm_pcp *NONE* pcp_block_id Int sql-strong-type
civicrm_pcp *NONE* pcp_contact_id Int sql-strong-type
civicrm_pcp *NONE* pcp_id Int sql-strong-type
civicrm_pcp *NONE* status_id Int sql-strong-type
civicrm_pcp *NONE* title String string-quasi-encoded-?
civicrm_pcp_block *NONE* entity_id Int sql-strong-type
civicrm_pcp_block *NONE* entity_table String string-quasi-encoded-?
civicrm_pcp_block *NONE* id Int sql-strong-type
civicrm_pcp_block *NONE* is_active Boolean sql-strong-type
civicrm_pcp_block *NONE* is_approval_needed Boolean sql-strong-type
civicrm_pcp_block *NONE* is_tellfriend_enabled Boolean sql-strong-type
civicrm_pcp_block *NONE* link_text String string-quasi-encoded-?
civicrm_pcp_block *NONE* notify_email String string-quasi-encoded-?
civicrm_pcp_block *NONE* owner_notify_id Int sql-strong-type
civicrm_pcp_block *NONE* supporter_profile_id Int sql-strong-type
civicrm_pcp_block *NONE* target_entity_id Int sql-strong-type
civicrm_pcp_block *NONE* target_entity_type String string-quasi-encoded-?
civicrm_pcp_block *NONE* tellfriend_limit Int sql-strong-type
civicrm_persistent *NONE* context String string-quasi-encoded-?
civicrm_persistent *NONE* data Text string-canonical
civicrm_persistent *NONE* id Int sql-strong-type
civicrm_persistent *NONE* is_config Boolean sql-strong-type
civicrm_persistent *NONE* name String string-quasi-encoded-?
civicrm_phone Phone contact_id Int sql-strong-type
civicrm_phone Phone id Int sql-strong-type
civicrm_phone Phone is_billing Boolean sql-strong-type
civicrm_phone Phone is_primary Boolean sql-strong-type
civicrm_phone Phone location_type_id Int sql-strong-type
civicrm_phone Phone mobile_provider_id Int sql-strong-type
civicrm_phone Phone phone String string-quasi-encoded-?
civicrm_phone Phone phone_ext String string-quasi-encoded-?
civicrm_phone Phone phone_numeric String string-quasi-encoded-?
civicrm_phone Phone phone_type_id Int sql-strong-type
civicrm_pledge Pledge acknowledge_date Timestamp sql-strong-type
civicrm_pledge Pledge additional_reminder_day Int sql-strong-type
civicrm_pledge Pledge cancel_date Timestamp sql-strong-type
civicrm_pledge Pledge currency String string-quasi-encoded-?
civicrm_pledge Pledge frequency_day Int sql-strong-type
civicrm_pledge Pledge initial_reminder_day Int sql-strong-type
civicrm_pledge Pledge installments Int sql-strong-type
civicrm_pledge Pledge max_reminders Int sql-strong-type
civicrm_pledge Pledge modified_date Timestamp sql-strong-type
civicrm_pledge Pledge pledge_amount Money sql-strong-type
civicrm_pledge Pledge pledge_campaign_id Int sql-strong-type
civicrm_pledge Pledge pledge_contact_id Int sql-strong-type
civicrm_pledge Pledge pledge_contribution_page_id Int sql-strong-type
civicrm_pledge Pledge pledge_create_date Timestamp sql-strong-type
civicrm_pledge Pledge pledge_end_date Timestamp sql-strong-type
civicrm_pledge Pledge pledge_financial_type_id Int sql-strong-type
civicrm_pledge Pledge pledge_frequency_interval Int sql-strong-type
civicrm_pledge Pledge pledge_frequency_unit String string-quasi-encoded-?
civicrm_pledge Pledge pledge_id Int sql-strong-type
civicrm_pledge Pledge pledge_is_test Boolean sql-strong-type
civicrm_pledge Pledge pledge_original_installment_amount Money sql-strong-type
civicrm_pledge Pledge pledge_start_date Timestamp sql-strong-type
civicrm_pledge Pledge pledge_status_id Int sql-strong-type
civicrm_pledge_block *NONE* additional_reminder_day Int sql-strong-type
civicrm_pledge_block *NONE* entity_id Int sql-strong-type
civicrm_pledge_block *NONE* entity_table String string-quasi-encoded-?
civicrm_pledge_block *NONE* id Int sql-strong-type
civicrm_pledge_block *NONE* initial_reminder_day Int sql-strong-type
civicrm_pledge_block *NONE* is_pledge_interval Boolean sql-strong-type
civicrm_pledge_block *NONE* is_pledge_start_date_editable Boolean sql-strong-type
civicrm_pledge_block *NONE* is_pledge_start_date_visible Boolean sql-strong-type
civicrm_pledge_block *NONE* max_reminders Int sql-strong-type
civicrm_pledge_block *NONE* pledge_frequency_unit String string-quasi-encoded-?
civicrm_pledge_block *NONE* pledge_start_date String string-quasi-encoded-?
civicrm_pledge_payment PledgePayment contribution_id Int sql-strong-type
civicrm_pledge_payment PledgePayment currency String string-quasi-encoded-?
civicrm_pledge_payment PledgePayment pledge_id Int sql-strong-type
civicrm_pledge_payment PledgePayment pledge_payment_actual_amount Money sql-strong-type
civicrm_pledge_payment PledgePayment pledge_payment_id Int sql-strong-type
civicrm_pledge_payment PledgePayment pledge_payment_reminder_count Int sql-strong-type
civicrm_pledge_payment PledgePayment pledge_payment_reminder_date Timestamp sql-strong-type
civicrm_pledge_payment PledgePayment pledge_payment_scheduled_amount Money sql-strong-type
civicrm_pledge_payment PledgePayment pledge_payment_scheduled_date Timestamp sql-strong-type
civicrm_pledge_payment PledgePayment pledge_payment_status_id Int sql-strong-type
civicrm_preferences_date *NONE* date_format String string-quasi-encoded-?
civicrm_preferences_date *NONE* description String string-canonical
civicrm_preferences_date *NONE* end Int sql-strong-type
civicrm_preferences_date *NONE* id Int sql-strong-type
civicrm_preferences_date *NONE* name String string-quasi-encoded-?
civicrm_preferences_date *NONE* start Int sql-strong-type
civicrm_preferences_date *NONE* time_format String string-quasi-encoded-?
civicrm_premiums Premium entity_id Int sql-strong-type
civicrm_premiums Premium entity_table String string-quasi-encoded-?
civicrm_premiums Premium id Int sql-strong-type
civicrm_premiums Premium premiums_active Boolean sql-strong-type
civicrm_premiums Premium premiums_contact_email String string-quasi-encoded-?
civicrm_premiums Premium premiums_contact_phone String string-quasi-encoded-?
civicrm_premiums Premium premiums_display_min_contribution Boolean sql-strong-type
civicrm_premiums Premium premiums_intro_text Text string-canonical
civicrm_premiums Premium premiums_intro_title String string-quasi-encoded-?
civicrm_premiums Premium premiums_nothankyou_label String string-quasi-encoded-?
civicrm_premiums Premium premiums_nothankyou_position Int sql-strong-type
civicrm_premiums_product *NONE* financial_type_id Int sql-strong-type
civicrm_premiums_product *NONE* id Int sql-strong-type
civicrm_premiums_product *NONE* premiums_id Int sql-strong-type
civicrm_premiums_product *NONE* product_id Int sql-strong-type
civicrm_premiums_product *NONE* weight Int sql-strong-type
civicrm_prevnext_cache *NONE* cachekey String string-quasi-encoded-?
civicrm_prevnext_cache *NONE* data Text string-canonical
civicrm_prevnext_cache *NONE* entity_id1 Int sql-strong-type
civicrm_prevnext_cache *NONE* entity_id2 Int sql-strong-type
civicrm_prevnext_cache *NONE* entity_table String string-quasi-encoded-?
civicrm_prevnext_cache *NONE* id Int sql-strong-type
civicrm_prevnext_cache *NONE* is_selected Boolean sql-strong-type
civicrm_price_field PriceField active_on Timestamp sql-strong-type
civicrm_price_field PriceField expire_on Timestamp sql-strong-type
civicrm_price_field PriceField help_post Text string-canonical
civicrm_price_field PriceField help_pre Text string-canonical
civicrm_price_field PriceField html_type String string-quasi-encoded-?
civicrm_price_field PriceField id Int sql-strong-type
civicrm_price_field PriceField is_active Boolean sql-strong-type
civicrm_price_field PriceField is_display_amounts Boolean sql-strong-type
civicrm_price_field PriceField is_enter_qty Boolean sql-strong-type
civicrm_price_field PriceField is_required Boolean sql-strong-type
civicrm_price_field PriceField javascript String string-quasi-encoded-?
civicrm_price_field PriceField label String string-canonical
civicrm_price_field PriceField name String string-quasi-encoded-?
civicrm_price_field PriceField options_per_line Int sql-strong-type
civicrm_price_field PriceField price_set_id Int sql-strong-type
civicrm_price_field PriceField visibility_id Int sql-strong-type
civicrm_price_field PriceField weight Int sql-strong-type
civicrm_price_field_value PriceFieldValue amount Money sql-strong-type
civicrm_price_field_value PriceFieldValue count Int sql-strong-type
civicrm_price_field_value PriceFieldValue description Text string-canonical
civicrm_price_field_value PriceFieldValue financial_type_id Int sql-strong-type
civicrm_price_field_value PriceFieldValue help_post Text string-canonical
civicrm_price_field_value PriceFieldValue help_pre Text string-canonical
civicrm_price_field_value PriceFieldValue id Int sql-strong-type
civicrm_price_field_value PriceFieldValue is_active Boolean sql-strong-type
civicrm_price_field_value PriceFieldValue is_default Boolean sql-strong-type
civicrm_price_field_value PriceFieldValue label String string-canonical
civicrm_price_field_value PriceFieldValue max_value Int sql-strong-type
civicrm_price_field_value PriceFieldValue membership_num_terms Int sql-strong-type
civicrm_price_field_value PriceFieldValue membership_type_id Int sql-strong-type
civicrm_price_field_value PriceFieldValue name String string-quasi-encoded-?
civicrm_price_field_value PriceFieldValue non_deductible_amount Money sql-strong-type
civicrm_price_field_value PriceFieldValue price_field_id Int sql-strong-type
civicrm_price_field_value PriceFieldValue visibility_id Int sql-strong-type
civicrm_price_field_value PriceFieldValue weight Int sql-strong-type
civicrm_price_set PriceSet domain_id Int sql-strong-type
civicrm_price_set PriceSet extends String string-quasi-encoded-?
civicrm_price_set PriceSet financial_type_id Int sql-strong-type
civicrm_price_set PriceSet help_post Text string-canonical
civicrm_price_set PriceSet help_pre Text string-canonical
civicrm_price_set PriceSet id Int sql-strong-type
civicrm_price_set PriceSet is_active Boolean sql-strong-type
civicrm_price_set PriceSet is_quick_config Boolean sql-strong-type
civicrm_price_set PriceSet is_reserved Boolean sql-strong-type
civicrm_price_set PriceSet javascript String string-quasi-encoded-?
civicrm_price_set PriceSet min_amount Int sql-strong-type
civicrm_price_set PriceSet name String string-quasi-encoded-?
civicrm_price_set PriceSet title String string-quasi-encoded-?
civicrm_price_set_entity *NONE* entity_id Int sql-strong-type
civicrm_price_set_entity *NONE* entity_table String string-quasi-encoded-?
civicrm_price_set_entity *NONE* id Int sql-strong-type
civicrm_price_set_entity *NONE* price_set_id Int sql-strong-type
civicrm_print_label PrintLabel created_id Int sql-strong-type
civicrm_print_label PrintLabel data Text string-canonical
civicrm_print_label PrintLabel description Text string-canonical
civicrm_print_label PrintLabel id Int sql-strong-type
civicrm_print_label PrintLabel is_active Boolean sql-strong-type
civicrm_print_label PrintLabel is_default Boolean sql-strong-type
civicrm_print_label PrintLabel is_reserved Boolean sql-strong-type
civicrm_print_label PrintLabel label_format_name String string-quasi-encoded-?
civicrm_print_label PrintLabel label_type_id Int sql-strong-type
civicrm_print_label PrintLabel name String string-quasi-encoded-?
civicrm_print_label PrintLabel title String string-quasi-encoded-?
civicrm_product Product cost Money sql-strong-type
civicrm_product Product currency String string-quasi-encoded-?
civicrm_product Product description Text string-canonical
civicrm_product Product duration_interval Int sql-strong-type
civicrm_product Product duration_unit String string-quasi-encoded-?
civicrm_product Product financial_type_id Int sql-strong-type
civicrm_product Product fixed_period_start_day Int sql-strong-type
civicrm_product Product frequency_interval Int sql-strong-type
civicrm_product Product frequency_unit String string-quasi-encoded-?
civicrm_product Product id Int sql-strong-type
civicrm_product Product image String string-quasi-encoded-?
civicrm_product Product is_active Boolean sql-strong-type
civicrm_product Product min_contribution Money sql-strong-type
civicrm_product Product options Text string-quasi-encoded-?
civicrm_product Product period_type String string-quasi-encoded-?
civicrm_product Product price Money sql-strong-type
civicrm_product Product product_name String string-quasi-encoded-?
civicrm_product Product sku String string-quasi-encoded-?
civicrm_product Product thumbnail String string-quasi-encoded-?
civicrm_queue_item *NONE* data Text string-canonical
civicrm_queue_item *NONE* id Int sql-strong-type
civicrm_queue_item *NONE* queue_name String string-quasi-encoded-?
civicrm_queue_item *NONE* release_time Timestamp sql-strong-type
civicrm_queue_item *NONE* submit_time Timestamp sql-strong-type
civicrm_queue_item *NONE* weight Int sql-strong-type
civicrm_recurring_entity RecurringEntity entity_id Int sql-strong-type
civicrm_recurring_entity RecurringEntity entity_table String string-quasi-encoded-?
civicrm_recurring_entity RecurringEntity id Int sql-strong-type
civicrm_recurring_entity RecurringEntity mode Boolean sql-strong-type
civicrm_recurring_entity RecurringEntity parent_id Int sql-strong-type
civicrm_relationship Relationship case_id Int sql-strong-type
civicrm_relationship Relationship contact_id_a Int sql-strong-type
civicrm_relationship Relationship contact_id_b Int sql-strong-type
civicrm_relationship Relationship description String string-canonical
civicrm_relationship Relationship end_date Date sql-strong-type
civicrm_relationship Relationship id Int sql-strong-type
civicrm_relationship Relationship is_active Boolean sql-strong-type
civicrm_relationship Relationship is_permission_a_b Int sql-strong-type
civicrm_relationship Relationship is_permission_b_a Int sql-strong-type
civicrm_relationship Relationship relationship_type_id Int sql-strong-type
civicrm_relationship Relationship start_date Date sql-strong-type
civicrm_relationship_type RelationshipType contact_sub_type_a String string-quasi-encoded-?
civicrm_relationship_type RelationshipType contact_sub_type_b String string-quasi-encoded-?
civicrm_relationship_type RelationshipType contact_type_a String string-quasi-encoded-?
civicrm_relationship_type RelationshipType contact_type_b String string-quasi-encoded-?
civicrm_relationship_type RelationshipType description String string-canonical
civicrm_relationship_type RelationshipType id Int sql-strong-type
civicrm_relationship_type RelationshipType is_active Boolean sql-strong-type
civicrm_relationship_type RelationshipType is_reserved Boolean sql-strong-type
civicrm_relationship_type RelationshipType label_a_b String string-quasi-encoded-?
civicrm_relationship_type RelationshipType label_b_a String string-quasi-encoded-?
civicrm_relationship_type RelationshipType name_a_b String string-quasi-encoded-?
civicrm_relationship_type RelationshipType name_b_a String string-quasi-encoded-?
civicrm_report_instance ReportInstance args String string-quasi-encoded-?
civicrm_report_instance ReportInstance created_id Int sql-strong-type
civicrm_report_instance ReportInstance description String string-canonical
civicrm_report_instance ReportInstance domain_id Int sql-strong-type
civicrm_report_instance ReportInstance drilldown_id Int sql-strong-type
civicrm_report_instance ReportInstance email_cc Text string-quasi-encoded-?
civicrm_report_instance ReportInstance email_subject String string-quasi-encoded-?
civicrm_report_instance ReportInstance email_to Text string-quasi-encoded-?
civicrm_report_instance ReportInstance footer Text string-quasi-encoded-?
civicrm_report_instance ReportInstance form_values Text string-quasi-encoded-?
civicrm_report_instance ReportInstance grouprole String string-quasi-encoded-?
civicrm_report_instance ReportInstance header Text string-quasi-encoded-?
civicrm_report_instance ReportInstance id Int sql-strong-type
civicrm_report_instance ReportInstance is_active Boolean sql-strong-type
civicrm_report_instance ReportInstance is_reserved Boolean sql-strong-type
civicrm_report_instance ReportInstance name String string-quasi-encoded-?
civicrm_report_instance ReportInstance navigation_id Int sql-strong-type
civicrm_report_instance ReportInstance owner_id Int sql-strong-type
civicrm_report_instance ReportInstance permission String string-quasi-encoded-?
civicrm_report_instance ReportInstance report_id String string-quasi-encoded-?
civicrm_report_instance ReportInstance title String string-quasi-encoded-?
civicrm_saved_search SavedSearch form_values Text string-quasi-encoded-?
civicrm_saved_search SavedSearch id Int sql-strong-type
civicrm_saved_search SavedSearch mapping_id Int sql-strong-type
civicrm_saved_search SavedSearch search_custom_id Int sql-strong-type
civicrm_saved_search SavedSearch select_tables Text string-quasi-encoded-?
civicrm_saved_search SavedSearch where_clause Text string-quasi-encoded-?
civicrm_saved_search SavedSearch where_tables Text string-quasi-encoded-?
civicrm_setting Setting component_id Int sql-strong-type
civicrm_setting Setting contact_id Int sql-strong-type
civicrm_setting Setting created_date Timestamp sql-strong-type
civicrm_setting Setting created_id Int sql-strong-type
civicrm_setting Setting domain_id Int sql-strong-type
civicrm_setting Setting id Int sql-strong-type
civicrm_setting Setting is_domain Boolean sql-strong-type
civicrm_setting Setting name String string-quasi-encoded-?
civicrm_setting Setting value Text string-quasi-encoded-?
civicrm_sms_provider *NONE* api_params Text string-quasi-encoded-?
civicrm_sms_provider *NONE* api_type Int sql-strong-type
civicrm_sms_provider *NONE* api_url String string-quasi-encoded-?
civicrm_sms_provider *NONE* domain_id Int sql-strong-type
civicrm_sms_provider *NONE* id Int sql-strong-type
civicrm_sms_provider *NONE* is_active Boolean sql-strong-type
civicrm_sms_provider *NONE* is_default Boolean sql-strong-type
civicrm_sms_provider *NONE* name String string-quasi-encoded-?
civicrm_sms_provider *NONE* password String string-quasi-encoded-?
civicrm_sms_provider *NONE* title String string-quasi-encoded-?
civicrm_sms_provider *NONE* username String string-quasi-encoded-?
civicrm_state_province StateProvince abbreviation String string-quasi-encoded-?
civicrm_state_province StateProvince country_id Int sql-strong-type
civicrm_state_province StateProvince id Int sql-strong-type
civicrm_state_province StateProvince name String string-quasi-encoded-?
civicrm_status_pref StatusPreference check_info String string-quasi-encoded-?
civicrm_status_pref StatusPreference domain_id Int sql-strong-type
civicrm_status_pref StatusPreference hush_until Date sql-strong-type
civicrm_status_pref StatusPreference id Int sql-strong-type
civicrm_status_pref StatusPreference ignore_severity Int sql-strong-type
civicrm_status_pref StatusPreference is_active Boolean sql-strong-type
civicrm_status_pref StatusPreference name String string-quasi-encoded-?
civicrm_status_pref StatusPreference prefs String string-quasi-encoded-?
civicrm_subscription_history *NONE* contact_id Int sql-strong-type
civicrm_subscription_history *NONE* date Timestamp sql-strong-type
civicrm_subscription_history *NONE* group_id Int sql-strong-type
civicrm_subscription_history *NONE* id Int sql-strong-type
civicrm_subscription_history *NONE* method String string-quasi-encoded-?
civicrm_subscription_history *NONE* status String string-quasi-encoded-?
civicrm_subscription_history *NONE* tracking String string-quasi-encoded-?
civicrm_survey Survey activity_type_id Int sql-strong-type
civicrm_survey Survey bypass_confirm Boolean sql-strong-type
civicrm_survey Survey campaign_id Int sql-strong-type
civicrm_survey Survey created_date Timestamp sql-strong-type
civicrm_survey Survey created_id Int sql-strong-type
civicrm_survey Survey default_number_of_contacts Int sql-strong-type
civicrm_survey Survey id Int sql-strong-type
civicrm_survey Survey instructions Text string-quasi-encoded-?
civicrm_survey Survey is_active Boolean sql-strong-type
civicrm_survey Survey is_default Boolean sql-strong-type
civicrm_survey Survey is_share Boolean sql-strong-type
civicrm_survey Survey last_modified_date Timestamp sql-strong-type
civicrm_survey Survey last_modified_id Int sql-strong-type
civicrm_survey Survey max_number_of_contacts Int sql-strong-type
civicrm_survey Survey recontact_interval Text string-quasi-encoded-?
civicrm_survey Survey release_frequency Int sql-strong-type
civicrm_survey Survey result_id Int sql-strong-type
civicrm_survey Survey thankyou_text Text string-canonical
civicrm_survey Survey thankyou_title String string-quasi-encoded-?
civicrm_survey Survey title String string-quasi-encoded-?
civicrm_system_log SystemLog contact_id Int sql-strong-type
civicrm_system_log SystemLog context Text string-quasi-encoded-?
civicrm_system_log SystemLog hostname String string-quasi-encoded-?
civicrm_system_log SystemLog id Int sql-strong-type
civicrm_system_log SystemLog level String string-quasi-encoded-?
civicrm_system_log SystemLog message String string-quasi-encoded-?
civicrm_system_log SystemLog timestamp Timestamp sql-strong-type
civicrm_tag Tag color String string-quasi-encoded-?
civicrm_tag Tag created_date Timestamp sql-strong-type
civicrm_tag Tag created_id Int sql-strong-type
civicrm_tag Tag description String string-canonical
civicrm_tag Tag id Int sql-strong-type
civicrm_tag Tag is_reserved Boolean sql-strong-type
civicrm_tag Tag is_selectable Boolean sql-strong-type
civicrm_tag Tag is_tagset Boolean sql-strong-type
civicrm_tag Tag name String string-quasi-encoded-?
civicrm_tag Tag parent_id Int sql-strong-type
civicrm_tag Tag used_for String string-quasi-encoded-?
civicrm_tell_friend *NONE* entity_id Int sql-strong-type
civicrm_tell_friend *NONE* entity_table String string-quasi-encoded-?
civicrm_tell_friend *NONE* general_link String string-quasi-encoded-?
civicrm_tell_friend *NONE* id Int sql-strong-type
civicrm_tell_friend *NONE* intro Text string-canonical
civicrm_tell_friend *NONE* is_active Boolean sql-strong-type
civicrm_tell_friend *NONE* suggested_message Text string-quasi-encoded-?
civicrm_tell_friend *NONE* thankyou_text Text string-canonical
civicrm_tell_friend *NONE* thankyou_title String string-quasi-encoded-?
civicrm_tell_friend *NONE* title String string-quasi-encoded-?
civicrm_timezone *NONE* abbreviation String string-quasi-encoded-?
civicrm_timezone *NONE* country_id Int sql-strong-type
civicrm_timezone *NONE* gmt String string-quasi-encoded-?
civicrm_timezone *NONE* id Int sql-strong-type
civicrm_timezone *NONE* name String string-quasi-encoded-?
civicrm_timezone *NONE* offset Int sql-strong-type
civicrm_uf_field UFField field_name String string-quasi-encoded-?
civicrm_uf_field UFField field_type String string-quasi-encoded-?
civicrm_uf_field UFField help_post Text string-canonical
civicrm_uf_field UFField help_pre Text string-canonical
civicrm_uf_field UFField id Int sql-strong-type
civicrm_uf_field UFField in_selector Boolean sql-strong-type
civicrm_uf_field UFField is_active Boolean sql-strong-type
civicrm_uf_field UFField is_multi_summary Boolean sql-strong-type
civicrm_uf_field UFField is_required Boolean sql-strong-type
civicrm_uf_field UFField is_reserved Boolean sql-strong-type
civicrm_uf_field UFField is_searchable Boolean sql-strong-type
civicrm_uf_field UFField is_view Boolean sql-strong-type
civicrm_uf_field UFField label String string-canonical
civicrm_uf_field UFField location_type_id Int sql-strong-type
civicrm_uf_field UFField phone_type_id Int sql-strong-type
civicrm_uf_field UFField uf_group_id Int sql-strong-type
civicrm_uf_field UFField visibility String string-quasi-encoded-?
civicrm_uf_field UFField website_type_id Int sql-strong-type
civicrm_uf_field UFField weight Int sql-strong-type
civicrm_uf_group UFGroup add_cancel_button Boolean sql-strong-type
civicrm_uf_group UFGroup add_captcha Boolean sql-strong-type
civicrm_uf_group UFGroup add_to_group_id Int sql-strong-type
civicrm_uf_group UFGroup cancel_URL String string-quasi-encoded-?
civicrm_uf_group UFGroup cancel_button_text String string-quasi-encoded-?
civicrm_uf_group UFGroup created_date Timestamp sql-strong-type
civicrm_uf_group UFGroup created_id Int sql-strong-type
civicrm_uf_group UFGroup description Text string-canonical
civicrm_uf_group UFGroup frontend_title String string-quasi-encoded-?
civicrm_uf_group UFGroup group_type String string-quasi-encoded-?
civicrm_uf_group UFGroup help_post Text string-canonical
civicrm_uf_group UFGroup help_pre Text string-canonical
civicrm_uf_group UFGroup id Int sql-strong-type
civicrm_uf_group UFGroup is_active Boolean sql-strong-type
civicrm_uf_group UFGroup is_cms_user Boolean sql-strong-type
civicrm_uf_group UFGroup is_edit_link Boolean sql-strong-type
civicrm_uf_group UFGroup is_map Boolean sql-strong-type
civicrm_uf_group UFGroup is_proximity_search Boolean sql-strong-type
civicrm_uf_group UFGroup is_reserved Boolean sql-strong-type
civicrm_uf_group UFGroup is_uf_link Boolean sql-strong-type
civicrm_uf_group UFGroup is_update_dupe Boolean sql-strong-type
civicrm_uf_group UFGroup limit_listings_group_id Int sql-strong-type
civicrm_uf_group UFGroup name String string-quasi-encoded-?
civicrm_uf_group UFGroup notify Text string-quasi-encoded-?
civicrm_uf_group UFGroup post_URL String string-quasi-encoded-?
civicrm_uf_group UFGroup submit_button_text String string-quasi-encoded-?
civicrm_uf_group UFGroup title String string-quasi-encoded-?
civicrm_uf_join UFJoin entity_id Int sql-strong-type
civicrm_uf_join UFJoin entity_table String string-quasi-encoded-?
civicrm_uf_join UFJoin id Int sql-strong-type
civicrm_uf_join UFJoin is_active Boolean sql-strong-type
civicrm_uf_join UFJoin module String string-quasi-encoded-?
civicrm_uf_join UFJoin module_data Text string-quasi-encoded-?
civicrm_uf_join UFJoin uf_group_id Int sql-strong-type
civicrm_uf_join UFJoin weight Int sql-strong-type
civicrm_uf_match UFMatch contact_id Int sql-strong-type
civicrm_uf_match UFMatch domain_id Int sql-strong-type
civicrm_uf_match UFMatch id Int sql-strong-type
civicrm_uf_match UFMatch language String string-quasi-encoded-?
civicrm_uf_match UFMatch uf_id Int sql-strong-type
civicrm_uf_match UFMatch uf_name String string-quasi-encoded-?
civicrm_volunteer_need VolunteerNeed created Timestamp sql-strong-type
civicrm_volunteer_need VolunteerNeed duration Int sql-strong-type
civicrm_volunteer_need VolunteerNeed end_time Timestamp sql-strong-type
civicrm_volunteer_need VolunteerNeed id Int sql-strong-type
civicrm_volunteer_need VolunteerNeed is_active Boolean sql-strong-type
civicrm_volunteer_need VolunteerNeed is_flexible Boolean sql-strong-type
civicrm_volunteer_need VolunteerNeed last_updated Timestamp sql-strong-type
civicrm_volunteer_need VolunteerNeed project_id Int sql-strong-type
civicrm_volunteer_need VolunteerNeed quantity Int sql-strong-type
civicrm_volunteer_need VolunteerNeed role_id Int sql-strong-type
civicrm_volunteer_need VolunteerNeed start_time Timestamp sql-strong-type
civicrm_volunteer_need VolunteerNeed visibility_id Int sql-strong-type
civicrm_volunteer_project VolunteerProject campaign_id Int sql-strong-type
civicrm_volunteer_project VolunteerProject description Text string-canonical
civicrm_volunteer_project VolunteerProject entity_id Int sql-strong-type
civicrm_volunteer_project VolunteerProject entity_table String string-quasi-encoded-?
civicrm_volunteer_project VolunteerProject id Int sql-strong-type
civicrm_volunteer_project VolunteerProject is_active Boolean sql-strong-type
civicrm_volunteer_project VolunteerProject loc_block_id Int sql-strong-type
civicrm_volunteer_project VolunteerProject title String string-quasi-encoded-?
civicrm_volunteer_project_contact VolunteerProjectContact contact_id Int sql-strong-type
civicrm_volunteer_project_contact VolunteerProjectContact id Int sql-strong-type
civicrm_volunteer_project_contact VolunteerProjectContact project_id Int sql-strong-type
civicrm_volunteer_project_contact VolunteerProjectContact relationship_type_id Int sql-strong-type
civicrm_website Website contact_id Int sql-strong-type
civicrm_website Website id Int sql-strong-type
civicrm_website Website url String string-canonical
civicrm_website Website website_type_id Int sql-strong-type
civicrm_word_replacement WordReplacement domain_id Int sql-strong-type
civicrm_word_replacement WordReplacement find_word String string-quasi-encoded-?
civicrm_word_replacement WordReplacement id Int sql-strong-type
civicrm_word_replacement WordReplacement is_active Boolean sql-strong-type
civicrm_word_replacement WordReplacement match_type String string-quasi-encoded-?
civicrm_word_replacement WordReplacement replace_word String string-quasi-encoded-?
civicrm_worldregion *NONE* id Int sql-strong-type
civicrm_worldregion *NONE* world_region String string-quasi-encoded-?
cividiscount_item DiscountCode active_on Timestamp sql-strong-type
cividiscount_item DiscountCode amount String string-quasi-encoded-?
cividiscount_item DiscountCode amount_type String string-quasi-encoded-?
cividiscount_item DiscountCode autodiscount Text string-quasi-encoded-?
cividiscount_item DiscountCode code String string-quasi-encoded-?
cividiscount_item DiscountCode count_max Int sql-strong-type
cividiscount_item DiscountCode count_use Int sql-strong-type
cividiscount_item DiscountCode description String string-canonical
cividiscount_item DiscountCode discount_msg String string-quasi-encoded-?
cividiscount_item DiscountCode discount_msg_enabled Boolean sql-strong-type
cividiscount_item DiscountCode events Text string-quasi-encoded-?
cividiscount_item DiscountCode expire_on Timestamp sql-strong-type
cividiscount_item DiscountCode filters String string-quasi-encoded-?
cividiscount_item DiscountCode id Int sql-strong-type
cividiscount_item DiscountCode is_active Boolean sql-strong-type
cividiscount_item DiscountCode memberships Text string-quasi-encoded-?
cividiscount_item DiscountCode organization_id Int sql-strong-type
cividiscount_item DiscountCode pricesets Text string-quasi-encoded-?
cividiscount_track DiscountTrack contact_id Int sql-strong-type
cividiscount_track DiscountTrack contribution_id Int sql-strong-type
cividiscount_track DiscountTrack description Text string-canonical
cividiscount_track DiscountTrack entity_id Int sql-strong-type
cividiscount_track DiscountTrack entity_table String string-quasi-encoded-?
cividiscount_track DiscountTrack id Int sql-strong-type
cividiscount_track DiscountTrack item_id Int sql-strong-type
cividiscount_track DiscountTrack used_date Timestamp sql-strong-type
civirule_action CiviRuleAction class_name String string-quasi-encoded-?
civirule_action CiviRuleAction created_date Date sql-strong-type
civirule_action CiviRuleAction created_user_id Int sql-strong-type
civirule_action CiviRuleAction id Int sql-strong-type
civirule_action CiviRuleAction is_active Int sql-strong-type
civirule_action CiviRuleAction label String string-canonical
civirule_action CiviRuleAction modified_date Date sql-strong-type
civirule_action CiviRuleAction modified_user_id Int sql-strong-type
civirule_action CiviRuleAction name String string-quasi-encoded-?
civirule_condition CiviRuleCondition class_name String string-quasi-encoded-?
civirule_condition CiviRuleCondition created_date Date sql-strong-type
civirule_condition CiviRuleCondition created_user_id Int sql-strong-type
civirule_condition CiviRuleCondition id Int sql-strong-type
civirule_condition CiviRuleCondition is_active Int sql-strong-type
civirule_condition CiviRuleCondition label String string-canonical
civirule_condition CiviRuleCondition modified_date Date sql-strong-type
civirule_condition CiviRuleCondition modified_user_id Int sql-strong-type
civirule_condition CiviRuleCondition name String string-quasi-encoded-?
civirule_rule CiviRuleRule created_date Date sql-strong-type
civirule_rule CiviRuleRule created_user_id Int sql-strong-type
civirule_rule CiviRuleRule description String string-canonical
civirule_rule CiviRuleRule help_text Text string-quasi-encoded-?
civirule_rule CiviRuleRule id Int sql-strong-type
civirule_rule CiviRuleRule is_active Int sql-strong-type
civirule_rule CiviRuleRule label String string-canonical
civirule_rule CiviRuleRule modified_date Date sql-strong-type
civirule_rule CiviRuleRule modified_user_id Int sql-strong-type
civirule_rule CiviRuleRule name String string-quasi-encoded-?
civirule_rule CiviRuleRule rule_tag_id Int sql-strong-type
civirule_rule CiviRuleRule trigger_id Int sql-strong-type
civirule_rule CiviRuleRule trigger_params Text string-quasi-encoded-?
civirule_trigger CiviRuleTrigger class_name String string-quasi-encoded-?
civirule_trigger CiviRuleTrigger created_date Date sql-strong-type
civirule_trigger CiviRuleTrigger created_user_id Int sql-strong-type
civirule_trigger CiviRuleTrigger cron Int sql-strong-type
civirule_trigger CiviRuleTrigger id Int sql-strong-type
civirule_trigger CiviRuleTrigger is_active Int sql-strong-type
civirule_trigger CiviRuleTrigger label String string-canonical
civirule_trigger CiviRuleTrigger modified_date Date sql-strong-type
civirule_trigger CiviRuleTrigger modified_user_id Int sql-strong-type
civirule_trigger CiviRuleTrigger name String string-quasi-encoded-?
civirule_trigger CiviRuleTrigger object_name String string-quasi-encoded-?
civirule_trigger CiviRuleTrigger op String string-quasi-encoded-?
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.