civicrm_batch

0 rows


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_idC

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_idN

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_idN

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_idN

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

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

Close relationships within degrees of separation