Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
Unique Status Preference ID |
|||
| domain_id | INT UNSIGNED | 10 | null |
|
|
Which Domain is this Status Preference for |
||||
| name | VARCHAR | 255 | null |
|
|
Name of the status check this preference references. |
||||
| hush_until | DATE | 10 | √ | null |
|
|
expires ignore_severity. NULL never hushes. |
|||
| ignore_severity | INT UNSIGNED | 10 | √ | 1 |
|
|
Hush messages up to and including this severity. |
|||
| prefs | VARCHAR | 255 | √ | null |
|
|
These settings are per-check, and can’t be compared across checks. |
|||
| check_info | VARCHAR | 255 | √ | null |
|
|
These values are per-check, and can’t be compared across checks. |
|||
| is_active | TINYINT | 3 | √ | 1 |
|
|
Is this status check active |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| FK_civicrm_status_pref_domain_id | Performance | Asc | domain_id |
| UI_status_pref_name | Performance | Asc | name |
Relationships
Close relationships within degrees of separation
