Images¶
One stored picture of an artist, an album or a video, kept in the library.
This page is the dictionary for the table. It holds the definition and purpose of every field, and it is where a field is changed.
Fields¶
| Field | Key | Type | Required | Allowed values or link | Definition | Purpose | Notes |
|---|---|---|---|---|---|---|---|
Kind |
IMAGES.KIND |
One value from a list | Yes | Artist photo, Album cover, Video thumbnail | What the picture shows. | Decides where the portal uses it. | |
Artist |
IMAGES.ARTIST |
Link to one row | Row of Artists | The artist an artist photo shows. | Ties a photo to its artist. | ||
Album |
IMAGES.ALBUM |
Link to one row | Row of Albums | The album an album cover belongs to. | Ties a cover to its album. | ||
Video |
IMAGES.VIDEO |
Link to one row | Row of Videos | The video a thumbnail belongs to. | Ties a thumbnail to its video. | ||
File_Path |
IMAGES.FILE_PATH |
Text | Yes | The path of the image file counted from the VeeJay folder. | Finds the picture on disk. | ||
Image_Source |
IMAGES.IMAGE_SOURCE |
One value from a list | Yes | Lidarr, Wikidata, Cover Art Archive, YouTube, Owner | Where the picture came from. | Traces a picture back to its source. | |
Width_Pixels |
IMAGES.WIDTH_PIXELS |
Whole number | The picture's width in pixels. | Picks the better picture when two collide. | |||
Height_Pixels |
IMAGES.HEIGHT_PIXELS |
Whole number | The picture's height in pixels. | Picks the better picture when two collide. | |||
File_Hash_SHA256 |
IMAGES.FILE_HASH_SHA256 |
Text | The SHA-256 fingerprint of the file: 64 lowercase hexadecimal characters. | Proves two copies are identical. | |||
Fetched_Time |
IMAGES.FETCHED_TIME |
Date and time (UTC) | Yes | The moment the picture was stored. | Shows how old a picture is. |
Constraints¶
What the database enforces on each field, beyond its type. A field that is not listed has no default, no uniqueness, no range and no reference. Every field marked Required is NOT NULL.
| Field | Default | Unique | Range or pattern | Refers to |
|---|---|---|---|---|
Kind |
ref_Image_Kinds | |||
Artist |
core_Artists | |||
Album |
core_Albums | |||
Video |
core_Videos | |||
File_Path |
Yes | a path counted from the VeeJay folder | ||
Image_Source |
ref_Image_Sources | |||
Width_Pixels |
more than 0 | |||
Height_Pixels |
more than 0 | |||
File_Hash_SHA256 |
64 lowercase hexadecimal characters | |||
Fetched_Time |
a real instant, YYYY-MM-DDTHH:MM:SSZ |
Rules across fields:
- Exactly one of Artist, Album and Video is filled, and it matches the Kind.
- An artist, an album or a video has at most one image of each kind: a partial unique index on each of Artist, Album and Video. A better picture replaces the old one.
The table is core_Images. Every link refuses a missing target and refuses the deletion of a row that another row still points to.
Choice values¶
Kind¶
| Value | Meaning | Purpose |
|---|---|---|
| Artist photo | A picture of an artist. | |
| Album cover | The cover of an album. | |
| Video thumbnail | The still picture that stands for a video. |
Image_Source¶
| Value | Meaning | Purpose |
|---|---|---|
| Lidarr | Stored locally by Lidarr. | |
| Wikidata | The image that Wikidata lists for a verified artist. | |
| Cover Art Archive | The cover held by the Cover Art Archive for a MusicBrainz release group. | |
| YouTube | The thumbnail that YouTube gives for a video. | |
| Owner | A picture you supplied. |