Staging playlist items¶
One item of a playlist, exactly as YouTube returned it, before it is identified.
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 |
STAGING_PLAYLIST_ITEMS.PLATFORM |
Link to one row | Yes | Row of Platforms | The platform the playlist was read from. | Says where the item came from. | |
Platform_Playlist_ID |
STAGING_PLAYLIST_ITEMS.PLATFORM_PLAYLIST_ID |
Text | Yes | The platform's identifier of the playlist that was read. | Says which playlist the item came from. | ||
Position |
STAGING_PLAYLIST_ITEMS.POSITION |
Whole number | Yes | The place of the item in the playlist as read. | Keeps the order that was read. | ||
YouTube_Video_ID |
STAGING_PLAYLIST_ITEMS.YOUTUBE_VIDEO_ID |
Text | Yes | The 11-character YouTube video ID of the item. | Finds the video's details. | ||
Raw_Answer |
STAGING_PLAYLIST_ITEMS.RAW_ANSWER |
Text | Yes | What the platform returned for the item, unchanged. | Keeps the evidence that every later step starts from. | ||
Read_Time |
STAGING_PLAYLIST_ITEMS.READ_TIME |
Date and time (UTC) | Yes | The moment the playlist was read. | Shows how old the answer 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 |
|---|---|---|---|---|
Platform |
ref_Platforms | |||
Position |
1 or more | |||
Read_Time |
a real instant, YYYY-MM-DDTHH:MM:SSZ |
Rules across fields:
- Staging is loose by design: nothing here counts as a fact until the promotion step moves it to the core.
The table is staging_Playlist_Items. Every link refuses a missing target and refuses the deletion of a row that another row still points to.