These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- Video Streaming Platform
- Data model and import order
The tables behind Video Streaming Platform
Video Streaming Platform ships with 19 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 19
- Features
- 7, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Asset pipeline:
Video assets, with Organizations, People and subscription plans. Status runs Uploaded, Processing, Reviewed, Published, Retired, with a Revision.
Publication review:
Review decisions, evidence documents. Decision Pending, Approved, Returned or Rejected against a source revision; evidence carries Verified and verified by.
Playback and subscriptions:
Playback sessions, subscription plans. Sessions carry Outcome Pending, Accepted or Rejected, watched minutes, errors and entitlement reference.
Metrics and analytics:
Metric definitions, metric observations, metric results. Definitions are Draft, Approved or Retired; results are Calculated, Suppressed or Invalid.
Source data:
Source snapshots, source mappings. Snapshots carry coverage, record count and freshness status Fresh, Stale or Failed.
Reconciliation and follow-up:
External reconciliations, follow up actions, exchange rates. Reconciliations are Pending, Matched, Difference or Reversed; actions are Open, in progress, Completed or Cancelled.
Runs and corrections:
Operation runs, operation steps, state history. Runs are Queued, Running, Succeeded, Failed or reconciliation required; steps are Pending, Running, Succeeded, Failed or Unknown.
Configuration:
Organizations, People, Users.
Every table, by feature
- Asset pipeline5
- Publication review4
- Playback and subscriptions3
- Metrics and analytics5
- Source data3
- Reconciliation and follow-up5
- Runs and corrections4
- Shared and settings1
- Video assets
Video assets moving through upload, transcode, review and publication
Linked to Organizations, People, Subscription plans - Subscription plans
Subscription plan definitions and entitlement policies
Linked to Organizations - People
Operators, reviewers and analysts working in the platform
Linked to Organizations - Organizations
Streaming service organizations and business units
- State history
Immutable status transition history written by workflows
Linked to Video assets, People
- Review decisions
Independent reviewer decisions recorded against an exact source revision
Linked to Video assets, People - Evidence documents
Supporting evidence documents attached to a source asset
Linked to Video assets, People - Video assets
Video assets moving through upload, transcode, review and publication
Linked to Organizations, People, Subscription plans - People
Operators, reviewers and analysts working in the platform
Linked to Organizations
- Playback sessions
Authorized playback session detail rows with observed intervals and errors
Linked to Video assets - Subscription plans
Subscription plan definitions and entitlement policies
Linked to Organizations - Video assets
Video assets moving through upload, transcode, review and publication
Linked to Organizations, People, Subscription plans
- Metric definitions
Approved metric definitions with grain, expressions and aggregation method
Linked to Subscription plans, People - Metric observations
Observed metric values captured per source period and unit
Linked to Video assets, Source snapshots - Metric results
Calculated metric results per period, dimension and unit
Linked to Video assets, Metric definitions, Operation runs - Source snapshots
Captured source-system snapshots with coverage and freshness evidence
- Operation runs
Workflow-maintained execution runs with frozen revision and input hash
Linked to Video assets
- Source snapshots
Captured source-system snapshots with coverage and freshness evidence
- Source mappings
Reviewed field mappings from source systems into platform fields
Linked to Subscription plans - Metric observations
Observed metric values captured per source period and unit
Linked to Video assets, Source snapshots
- External reconciliations
External delivery and payment reconciliations against expected values
Linked to Video assets - Follow up actions
Assigned follow-up work arising from review or playback exceptions
Linked to Video assets, People - Exchange rates
Read-only effective exchange rates for this app.
- Video assets
Video assets moving through upload, transcode, review and publication
Linked to Organizations, People, Subscription plans - People
Operators, reviewers and analysts working in the platform
Linked to Organizations
- Operation runs
Workflow-maintained execution runs with frozen revision and input hash
Linked to Video assets - Operation steps
Numbered execution steps with persisted input and output identities
Linked to Operation runs - State history
Immutable status transition history written by workflows
Linked to Video assets, People - Video assets
Video assets moving through upload, transcode, review and publication
Linked to Organizations, People, Subscription plans
Keys and references
A video asset references its organization, owner and subscription plan. Review decisions, evidence documents, playback sessions, reconciliations, follow-up actions, state history and metric observations each reference one asset as Source or Parent. Runs reference an asset; steps reference a run; metric results reference a metric definition and a run; observations reference a snapshot. Metric definitions and source mappings reference a subscription plan.
Import assets by Number, people and organizations by Code, and playback sessions by source record id. Keep revisions and operation keys as they were recorded.
Migration order
- Load Organizations, then Users and People linked to their organization.
- Load subscription plans with effective dates and policy references.
- Load video assets with owner, plan and current Revision, then evidence documents and existing review decisions.
- Load source mappings and source snapshots, then approved metric definitions.
- Load playback sessions by source record id and open external reconciliations and follow up actions.
- Reconcile published titles, watched minutes and settled amounts with the source, test permissions and replay the exception cases before the next release week.
Set up Video Streaming Platform your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.