Online courses
A course is a tree: modules in order, lessons in order within them. Enrollment is the relationship between a learner and a course and holds completion; progress is per lesson so a dashboard can show where someone stopped. Quizzes belong to a lesson, attempts record the answers given, and a certificate is issued once per enrollment.
Comienza un proyecto con este esquema
$ npx vela create my-app --schema courses- id* text
- password* password
- tokenKey* text
- email* email
- emailVisibility bool
- verified bool
- name text
- avatar file
- created autodate
- updated autodate
- id* text
- title* text
- slug* text
- summary text
- description editor
- instructor* users
- cover file
- level select
- price number
- published bool
- created autodate
- updated autodate
- id* text
- course* courses
- title* text
- sort* number
- created autodate
- updated autodate
- id* text
- module* modules
- title* text
- content editor
- video_url url
- duration_minutes number
- sort* number
- free_preview bool
- created autodate
- updated autodate
- id* text
- learner* users
- course* courses
- enrolled_at* date
- completed_at date
- progress_percent number
- created autodate
- updated autodate
- id* text
- enrollment* enrollments
- lesson* lessons
- completed bool
- seconds_watched number
- last_viewed_at date
- created autodate
- updated autodate
- id* text
- lesson* lessons
- title* text
- questions* json
- pass_percent number
- created autodate
- updated autodate
- id* text
- quiz* quizzes
- enrollment* enrollments
- answers* json
- score_percent number
- passed bool
- created autodate
- updated autodate
- id* text
- enrollment* enrollments
- number* text
- issued_at* date
- pdf file
- created autodate
- updated autodate
Cada colección, campo y relación de arriba se convierte en una migración de PocketBase en el nuevo proyecto. Cambia lo que quieras después con vela generate migration --ai, que abre este mismo diagrama como editor.