Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
id | INT UNSIGNED | 10 | √ | null |
|
|
Saved search ID |
|||||
form_values | TEXT | 65535 | √ | null |
|
|
Submitted form values for this search |
|||||
mapping_id | INT UNSIGNED | 10 | √ | null |
|
|
Foreign key to civicrm_mapping used for saved search-builder searches. |
|||||
search_custom_id | INT UNSIGNED | 10 | √ | null |
|
|
Foreign key to civicrm_option value table used for saved custom searches. |
|||||
where_clause | TEXT | 65535 | √ | null |
|
|
the sql where clause if a saved search acl |
|||||
select_tables | TEXT | 65535 | √ | null |
|
|
the tables to be included in a select data |
|||||
where_tables | TEXT | 65535 | √ | null |
|
|
the tables to be included in the count statement |
Showing 1 to 7 of 7 entries