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.
- EdTech Content Platform
- Data model
The tables behind EdTech Content Platform
EdTech Content Platform ships with 14 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
- 14
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Course context
Organizations, People and course catalog establish who owns a program and which definition an item uses. Source mappings record field mapping versions for course-linked source data.
Content and interaction
Learning content is the operating item; content interactions are child observations under it.
Evidence and review
Evidence documents and review decisions point to the content item. Follow up actions assign corrections, while state history retains status transitions.
Delivery trace
Execution attempts and operation runs point to content; operation steps belong to a run. Users carries account identity and role values.
Every table, by feature
- Course catalog4
- Content workspace5
- Interaction review3
- Evidence and decisions5
- Delivery operations4
- Follow-up control5
- Shared and settings1
- Course catalog
Course catalog of published learning programmes and entitlements offered by an organization.
Linked to Organizations - Organizations
Agencies, departments and service organizations that own public services and cases.
- Source mappings
Reviewed field mappings and transform rules between source payloads and target fields.
Linked to Course catalog - Learning content
Learning content items, video and interactive course records created and published from the course catalog.
Linked to Organizations, People, Course catalog
- Learning content
Learning content items, video and interactive course records created and published from the course catalog.
Linked to Organizations, People, Course catalog - Course catalog
Course catalog of published learning programmes and entitlements offered by an organization.
Linked to Organizations - State history
Immutable workflow-written status transition history for each case.
Linked to Learning content, People - Review decisions
Independent reviewer decisions recorded against an exact source revision.
Linked to Learning content, People - Content interactions
Observation-level interaction, playback and quiz detail captured against a learning content item.
Linked to Learning content
- Content interactions
Observation-level interaction, playback and quiz detail captured against a learning content item.
Linked to Learning content - Learning content
Learning content items, video and interactive course records created and published from the course catalog.
Linked to Organizations, People, Course catalog - Source mappings
Reviewed field mappings and transform rules between source payloads and target fields.
Linked to Course catalog
- Evidence documents
Uploaded and verified supporting documents and source evidence.
Linked to Learning content, People - Review decisions
Independent reviewer decisions recorded against an exact source revision.
Linked to Learning content, People - Learning content
Learning content items, video and interactive course records created and published from the course catalog.
Linked to Organizations, People, Course catalog - People
Staff, officers, reviewers and assigned team members.
Linked to Organizations - Follow up actions
Assigned outstanding actions, corrections and outstanding requests for a case.
Linked to Learning content, People
- Learning content
Learning content items, video and interactive course records created and published from the course catalog.
Linked to Organizations, People, Course catalog - Execution attempts
Each recorded attempt to execute an approved action for a service application.
Linked to Learning content - Operation runs
Workflow-maintained execution runs with operation key, input hash and persisted result reference.
Linked to Learning content - Operation steps
Ordered steps inside an operation run with input, output and external receipt state.
Linked to Operation runs
- Follow up actions
Assigned outstanding actions, corrections and outstanding requests for a case.
Linked to Learning content, People - Learning content
Learning content items, video and interactive course records created and published from the course catalog.
Linked to Organizations, People, Course catalog - Review decisions
Independent reviewer decisions recorded against an exact source revision.
Linked to Learning content, People - State history
Immutable workflow-written status transition history for each case.
Linked to Learning content, People - Operation runs
Workflow-maintained execution runs with operation key, input hash and persisted result reference.
Linked to Learning content
Keys and references
A learning content item links to Organizations, People and course catalog through Organization, Owner and Definition. Content interactions links through Parent. Evidence documents, review decisions, follow up actions, execution attempts, operation runs and state history use Source to identify the content item. Operation steps uses Run. The decision’s source revision and the run’s source revision let the team compare review and delivery with the item revision.
Migration order
- Load Organizations and People, then course catalog and any source mappings.
- Load learning content with its organization, owner and definition references.
- Load content interactions and evidence documents under the matching content item.
- Load review decisions and follow up actions with the correct source revision or assignee.
- Reconcile state history, execution attempts, operation runs and operation steps against the item and external receipts.
Set up EdTech Content Platform your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.