quality_profiles
Purpose
Section titled “Purpose”Quality profiles define complete media acquisition strategies including upgrade limits, minimum custom format scores, and upgrade-until thresholds. The profile name is the stable FK target for all profile-scoped junction tables.
Columns
Section titled “Columns”| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
id |
INTEGER | Yes | — | — |
name |
VARCHAR(100) | No | — | — |
description |
TEXT | Yes | — | — |
upgrades_allowed |
INTEGER | No | 1 | — |
minimum_custom_format_score |
INTEGER | No | 0 | — |
upgrade_until_score |
INTEGER | No | 0 | — |
upgrade_score_increment |
INTEGER | No | 1 | — |
created_at |
TEXT | No | CURRENT_TIMESTAMP | — |
updated_at |
TEXT | No | CURRENT_TIMESTAMP | — |
Relationships
Section titled “Relationships”Referenced by:
- quality_groups
- quality_profile_tags
- quality_profile_languages
- quality_group_members
- quality_profile_qualities
- quality_profile_custom_formats
Constraints
Section titled “Constraints”- Primary key: (id)
- Unique: UNIQUE (name)
- CHECK: upgrade_score_increment: CHECK (upgrade_score_increment > 0)