Table d47civi_0z3xa.civicrm_status_pref 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  √  Unique Status Preference ID
domain_id int unsigned 10
civicrm_domain.id FK_civicrm_status_pref_domain_id R
Which Domain is this Status Preference for
name varchar 255 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.

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
domain_id Performance Asc FK_civicrm_status_pref_domain_id
name Performance Asc UI_status_pref_name

Close relationships  within of separation: