sonarr_quality_definitions
Purpose
Section titled “Purpose”Sonarr-specific quality size limits keyed by configuration name and canonical quality_name. Used when syncing quality definitions to Sonarr instances.
Columns
Section titled “Columns”| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
name |
VARCHAR(100) | No | — | — |
quality_name |
VARCHAR(100) | No | — | — |
min_size |
INTEGER | No | 0 | — |
max_size |
INTEGER | No | — | — |
preferred_size |
INTEGER | No | — | — |
created_at |
TEXT | No | CURRENT_TIMESTAMP | — |
updated_at |
TEXT | No | CURRENT_TIMESTAMP | — |
Relationships
Section titled “Relationships”References:
-
qualities — qualities (quality_name)
-
FOREIGN KEY (quality_name) REFERENCES qualities(name) ON DELETE CASCADE ON UPDATE CASCADE
Constraints
Section titled “Constraints”- Primary key: (name, quality_name)
- Arr-type note: Sonarr-only table. Radarr and Lidarr use sibling tables with the same shape but separate rows.