Table d47civi_0z3xa.civicrm_batch Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √ 
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.
title varchar 64  √  null Friendly Name.
description text 65535  √  null Description of this batch set.
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 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

Table contained 0 rows at mer. avr. 13 16:52 EDT 2016

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc PRIMARY  
created_id Performance Asc FK_civicrm_batch_created_id  
modified_id Performance Asc FK_civicrm_batch_modified_id  
saved_search_id Performance Asc FK_civicrm_batch_saved_search_id  
name Must be unique Asc UI_name This unique column is also nullable

Close relationships  within of separation: