| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
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_en_US | VARCHAR | 255 | √ | null |
|
|
||||
| description_en_US | TEXT | 65535 | √ | null |
|
|
||||
| title_fr_CA | VARCHAR | 255 | √ | null |
|
|
||||
| description_fr_CA | TEXT | 65535 | √ | null |
|
|
Showing 1 to 19 of 19 entries
