Skip to content

Attention items

One event that only you can decide, and that VeeJay remembers until you do.

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 ATTENTION_ITEMS.KIND One value from a list Yes Sync conflict, Removal to make by hand, Doubtful match What kind of event this is. Decides how the item is shown and what answering it does.
Playlist_Copy ATTENTION_ITEMS.PLAYLIST_COPY Link to one row Row of Playlist_Copies The copy that the event is about. Filled for a sync conflict and a removal to make by hand. Says on which platform the event happened.
Song ATTENTION_ITEMS.SONG Link to one row Row of Songs The song that the event is about. Blank only for a doubtful match that has no candidate song. Says which song needs the decision.
Platform_Item_ID ATTENTION_ITEMS.PLATFORM_ITEM_ID Text The platform's identifier of an item that matched no song. Filled for a doubtful match with no candidate song. Lets you see which item on the platform could not be matched.
Detail ATTENTION_ITEMS.DETAIL Text Yes What happened, in words, with both sides shown. Lets you decide without looking anything up.
Item_Status ATTENTION_ITEMS.ITEM_STATUS One value from a list Yes Open, Decided, Applied Where the item stands. Open items wait for you, and Applied items are kept as a record.
Owner_Decision ATTENTION_ITEMS.OWNER_DECISION One value from a list Keep the song, Remove the song, Accept the match, Reject the match, Done by hand What you decided. The answer that VeeJay carries out.
Decided_Date ATTENTION_ITEMS.DECIDED_DATE Date The date you decided. History.

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_Attention_Kinds
Playlist_Copy core_Playlist_Copies
Song core_Songs
Item_Status ref_Attention_Statuses
Owner_Decision ref_Attention_Decisions
Decided_Date a real day, YYYY-MM-DD

Rules across fields:

  • A sync conflict and a removal to make by hand have a Playlist_Copy and a Song.
  • A doubtful match has a Song or a Platform_Item_ID.
  • A decided or applied item has an Owner_Decision and a Decided_Date.

The table is core_Attention_Items. 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
Sync conflict A song was added on one platform and removed on another, and the times cannot settle which wins.
Removal to make by hand A song must be removed on a platform that lets an application add but not remove, so you remove it there.
Doubtful match VeeJay found an item on a platform but could not be sure which recording it is.

Item_Status

Value Meaning Purpose
Open Waiting for you.
Decided You have answered, and the answer is not yet carried out.
Applied The answer has been carried out.

Owner_Decision

Value Meaning Purpose
Keep the song The song stays in the playlist.
Remove the song The song is removed from the playlist.
Accept the match The item on the platform is that song.
Reject the match The item on the platform is not that song.
Done by hand You made the change yourself on the platform.