Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | 0 |
|
|
Unique Address ID |
||
| name | VARCHAR | 64 | √ | null |
|
|
Variable name/programmatic handle for this batch. |
|
| created_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to Contact ID |
|
| created_date | DATETIME | 19 | √ | null |
|
|
When was this item created |
|
| modified_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to Contact ID |
|
| modified_date | DATETIME | 19 | √ | null |
|
|
When was this item created |
|
| saved_search_id | INT UNSIGNED | 10 | √ | null |
|
|
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 | VARCHAR | 255 | √ | null |
|
|
||
| description | TEXT | 65535 | √ | null |
|
|