qualities
Purpose
Section titled “Purpose”Individual quality definitions such as 1080p Bluray or 2160p REMUX. Contains video qualities from Radarr/Sonarr and audio qualities from Lidarr. The canonical name is the stable FK reference across all tables.
Columns
Section titled “Columns”| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
id |
INTEGER | Yes | — | — |
name |
VARCHAR(100) | No | — | — |
created_at |
TEXT | No | CURRENT_TIMESTAMP | — |
updated_at |
TEXT | No | CURRENT_TIMESTAMP | — |
Relationships
Section titled “Relationships”Referenced by:
- quality_api_mappings
- quality_group_members
- quality_profile_qualities
- radarr_quality_definitions
- sonarr_quality_definitions
- lidarr_quality_definitions
Constraints
Section titled “Constraints”- Primary key: (id)
- Unique: UNIQUE (name)