Playlist copies¶
One platform's copy of the playlist called VeeJay. There is one playlist, and each platform holds one copy of it.
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 |
|---|---|---|---|---|---|---|---|
Platform |
PLAYLIST_COPIES.PLATFORM |
Link to one row | Yes | Row of Platforms | The platform that holds the copy. | Says where the copy lives and what it can do. | |
Platform_Playlist_ID |
PLAYLIST_COPIES.PLATFORM_PLAYLIST_ID |
Text | Yes | The identifier that the platform gives to the playlist called VeeJay. | Lets VeeJay read and change the playlist on that platform without searching for it. | ||
Is_Audio_Only |
PLAYLIST_COPIES.IS_AUDIO_ONLY |
Yes or no | Yes | Yes when this platform's copy holds the audio track of each song, even though the platform could hold videos. | Lets one platform keep audio tracks while another keeps music videos. | ||
Last_Synchronized_Time |
PLAYLIST_COPIES.LAST_SYNCHRONIZED_TIME |
Date and time (UTC) | The moment of the last synchronization of this copy. Blank until the first one. | Marks the state against which the next synchronization compares the copy. |
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 |
|---|---|---|---|---|
Platform |
Yes | ref_Platforms | ||
Platform_Playlist_ID |
Yes, with Platform | |||
Is_Audio_Only |
0 (No) | |||
Last_Synchronized_Time |
a real instant, YYYY-MM-DDTHH:MM:SSZ |
Rules across fields:
- A platform has one copy: Platform is unique.
- The pair Platform and Platform_Playlist_ID is unique.
The table is core_Playlist_Copies. Every link refuses a missing target and refuses the deletion of a row that another row still points to.