civicrm_batch


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
civicrm_entity_batch.batch_id FK_civicrm_entity_batch_batch_id C

Unique Address ID

name VARCHAR 64 null

Variable name/programmatic handle for this batch.

created_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_batch_created_id N

FK to Contact ID

created_date DATETIME 19 null

When was this item created

modified_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_batch_modified_id N

FK to Contact ID

modified_date DATETIME 19 null

When was this item created

saved_search_id INT UNSIGNED 10 null
civicrm_saved_search.id FK_civicrm_batch_saved_search_id N

FK to Saved Search ID

status_id INT UNSIGNED 10 null

fk to Batch Status options in civicrm_option_values

type_id INT UNSIGNED 10 null

fk to Batch Type options in civicrm_option_values

mode_id INT UNSIGNED 10 null

fk to Batch mode options in civicrm_option_values

total DECIMAL 20,2 null

Total amount for this batch.

item_count INT UNSIGNED 10 null

Number of items in a batch.

payment_instrument_id INT UNSIGNED 10 null

fk to Payment Instrument options in civicrm_option_values

exported_date DATETIME 19 null
data LONGTEXT 2147483647 null

cache entered data

title_en_US VARCHAR 255 null
description_en_US TEXT 65535 null
title_fr_CA VARCHAR 255 null
description_fr_CA TEXT 65535 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_batch_created_id Performance Asc created_id
FK_civicrm_batch_modified_id Performance Asc modified_id
FK_civicrm_batch_saved_search_id Performance Asc saved_search_id
UI_name Must be unique Asc name

Relationships