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