sub
Tables (12)
auth_provider
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- provider — VARCHAR(50) — NOT NULL
- provider_user_id — VARCHAR(255) — NOT NULL
- provider_email — VARCHAR(255)
- linked_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
export_job
- id — BIGINT
- lesson_id — BIGINT — Foreign key → lesson.id — NOT NULL
- requested_by — BIGINT — Foreign key → users.id — NOT NULL
- export_type — VARCHAR(50) — NOT NULL
- status — VARCHAR(50) — NOT NULL
- file_resource_id — BIGINT — Foreign key → file_resource.id
- error_message — TEXT
- started_at — DATETIME
- finished_at — DATETIME
- created_at — DATETIME — NOT NULL
file_resource
- id — BIGINT
- organization_id — BIGINT — Foreign key → organization.id — NOT NULL
- lesson_id — BIGINT — Foreign key → lesson.id
- uploaded_by — BIGINT — Foreign key → users.id — NOT NULL
- file_type — VARCHAR(50) — NOT NULL
- original_name — VARCHAR(255) — NOT NULL
- storage_key — VARCHAR(500) — NOT NULL
- file_size — BIGINT — NOT NULL
- content_type — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
generation_job
- id — BIGINT
- lesson_id — BIGINT — Foreign key → lesson.id — NOT NULL
- requested_by — BIGINT — Foreign key → users.id — NOT NULL
- job_type — VARCHAR(50) — NOT NULL
- target_section_id — BIGINT — Foreign key → lesson_section.id
- prompt_version — VARCHAR(50) — NOT NULL
- input_payload — JSON
- output_payload — JSON
- status — VARCHAR(50) — NOT NULL
- token_usage — INT
- error_message — TEXT
- started_at — DATETIME
- finished_at — DATETIME
- created_at — DATETIME — NOT NULL
lesson
- id — BIGINT
- organization_id — BIGINT — Foreign key → organization.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- template_id — BIGINT — Foreign key → lesson_template.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- topic — VARCHAR(255) — NOT NULL
- subject — VARCHAR(100) — NOT NULL
- age_group — VARCHAR(100) — NOT NULL
- difficulty — VARCHAR(100) — NOT NULL
- total_duration_min — INT — NOT NULL
- status — VARCHAR(50) — NOT NULL
- version — INT — NOT NULL
- confirmed_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
lesson_activity
- id — BIGINT
- lesson_section_id — BIGINT — Foreign key → lesson_section.id — NOT NULL
- sequence_no — INT — NOT NULL
- activity_type — VARCHAR(100) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- instruction — TEXT
- expected_answer — TEXT
- material — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
lesson_section
- id — BIGINT
- lesson_id — BIGINT — Foreign key → lesson.id — NOT NULL
- template_section_id — BIGINT — Foreign key → lesson_template_section.id
- sequence_no — INT — NOT NULL
- section_type — VARCHAR(100) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- objective — TEXT
- content — TEXT
- teacher_guide — TEXT
- duration_min — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
lesson_template
- id — BIGINT
- organization_id — BIGINT — Foreign key → organization.id — NOT NULL
- created_by — BIGINT — Foreign key → users.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- subject — VARCHAR(100) — NOT NULL
- age_group — VARCHAR(100) — NOT NULL
- difficulty — VARCHAR(100) — NOT NULL
- visibility — VARCHAR(50) — NOT NULL
- version — INT — NOT NULL
- status — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
lesson_template_section
- id — BIGINT
- template_id — BIGINT — Foreign key → lesson_template.id — NOT NULL
- sequence_no — INT — NOT NULL
- section_type — VARCHAR(100) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- duration_min — INT — NOT NULL
- activity_type — VARCHAR(100)
- slide_count — INT — NOT NULL
- worksheet_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
notification
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- type — VARCHAR(100) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- message — VARCHAR(2000) — NOT NULL
- target_type — VARCHAR(100)
- target_id — BIGINT
- is_read — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
organization
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
- code — VARCHAR(100) — NOT NULL
- domain — VARCHAR(255)
- status — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
users
- id — BIGINT
- organization_id — BIGINT — Foreign key → organization.id — NOT NULL
- email — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- role — VARCHAR(50) — NOT NULL
- status — VARCHAR(50) — NOT NULL
- last_login_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL