Staging video details¶
The details of one video, exactly as YouTube returned them, 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 |
|---|---|---|---|---|---|---|---|
YouTube_Video_ID |
STAGING_VIDEO_DETAILS.YOUTUBE_VIDEO_ID |
Text | Yes | The 11-character YouTube video ID. | Says which video the details are about. | ||
Raw_Answer |
STAGING_VIDEO_DETAILS.RAW_ANSWER |
Text | Yes | What YouTube returned for the video: title, description, channel, views, length and publish date, unchanged. | Keeps the evidence that every later step starts from. | ||
Read_Time |
STAGING_VIDEO_DETAILS.READ_TIME |
Date and time (UTC) | Yes | The moment the details were 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 |
|---|---|---|---|---|
YouTube_Video_ID |
Yes | exactly 11 letters, digits, - or _ (V-05) | ||
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_Video_Details. Every link refuses a missing target and refuses the deletion of a row that another row still points to.