goodprompt

Tables (31)

admins

  • id — UUID — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • last_login_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

ai_tasks

  • id — UUID — Primary key — NOT NULL
  • course_version_id — UUID — Foreign key → course_versions.id — NOT NULL
  • task_code — VARCHAR(50) — NOT NULL
  • purpose — TEXT
  • provider — VARCHAR(50)
  • model_role — VARCHAR(50)
  • instruction — TEXT
  • input_schema_json — JSONB
  • output_schema_json — JSONB
  • fallback — TEXT
  • settings_json — JSONB

assets

  • id — UUID — Primary key — NOT NULL
  • asset_code — VARCHAR(80) — NOT NULL
  • asset_type — VARCHAR(40) — NOT NULL
  • storage_provider — VARCHAR(40) — NOT NULL
  • storage_key — TEXT — NOT NULL
  • mime_type — VARCHAR(100)
  • file_size — BIGINT
  • width — INTEGER
  • height — INTEGER
  • duration_seconds — INTEGER
  • locale — VARCHAR(10)
  • status — VARCHAR(20) — NOT NULL
  • checksum — VARCHAR(128)
  • created_at — TIMESTAMPTZ — NOT NULL

avatar_profiles

  • id — UUID — Primary key — NOT NULL
  • avatar_code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • role — VARCHAR(150)
  • voice_id — VARCHAR(100)
  • speech_rate — NUMERIC(3,2) — NOT NULL
  • default_action — VARCHAR(50)
  • system_prompt — TEXT
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

certificates

  • id — UUID — Primary key — NOT NULL
  • enrollment_id — UUID — Foreign key → enrollments.id — NOT NULL
  • certificate_number — VARCHAR(50) — NOT NULL
  • pdf_url — TEXT
  • issued_at — TIMESTAMPTZ — NOT NULL

class_courses

  • id — UUID — Primary key — NOT NULL
  • class_id — UUID — Foreign key → classes.id — NOT NULL
  • course_release_id — UUID — Foreign key → course_releases.id — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • required — BOOLEAN — NOT NULL

class_guests

  • id — UUID — Primary key — NOT NULL
  • class_id — UUID — Foreign key → classes.id — NOT NULL
  • display_name — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • last_seen_at — TIMESTAMPTZ — NOT NULL

classes

  • id — UUID — Primary key — NOT NULL
  • class_code — VARCHAR(40) — NOT NULL
  • entry_code — VARCHAR(40) — NOT NULL
  • recommended_class_id — UUID — Foreign key → recommended_classes.id
  • title — VARCHAR(200) — NOT NULL
  • start_at — TIMESTAMPTZ
  • end_at — TIMESTAMPTZ
  • capacity — INTEGER
  • status — VARCHAR(20) — NOT NULL
  • created_by — UUID — Foreign key → admins.id
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

course_ai_configs

  • id — UUID — Primary key — NOT NULL
  • course_version_id — UUID — Foreign key → course_versions.id — NOT NULL
  • avatar_profile_id — UUID — Foreign key → avatar_profiles.id
  • course_role — TEXT
  • course_instruction — TEXT
  • conversation_config_json — JSONB
  • fallback_config_json — JSONB
  • safety_config_json — JSONB

course_attempts

  • id — UUID — Primary key — NOT NULL
  • learner_course_progress_id — UUID — Foreign key → learner_course_progress.id — NOT NULL
  • attempt_no — INTEGER — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • meta_json — JSONB
  • started_at — TIMESTAMPTZ — NOT NULL
  • completed_at — TIMESTAMPTZ

course_deliverables

  • id — UUID — Primary key — NOT NULL
  • course_version_id — UUID — Foreign key → course_versions.id — NOT NULL
  • deliverable_code — VARCHAR(50) — NOT NULL
  • label — VARCHAR(200) — NOT NULL
  • output_type — VARCHAR(20) — NOT NULL
  • required — BOOLEAN — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • config_json — JSONB

course_objectives

  • id — UUID — Primary key — NOT NULL
  • course_version_id — UUID — Foreign key → course_versions.id — NOT NULL
  • objective — TEXT — NOT NULL
  • sort_order — INTEGER — NOT NULL

course_releases

  • id — UUID — Primary key — NOT NULL
  • course_version_id — UUID — Foreign key → course_versions.id — NOT NULL
  • release_status — VARCHAR(20) — NOT NULL
  • schema_valid — BOOLEAN — NOT NULL
  • flow_valid — BOOLEAN — NOT NULL
  • assets_valid — BOOLEAN — NOT NULL
  • accessibility_valid — BOOLEAN — NOT NULL
  • approved_by — UUID — Foreign key → admins.id
  • approved_at — TIMESTAMPTZ
  • published_at — TIMESTAMPTZ
  • release_notes — TEXT
  • runtime_snapshot_json — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL

course_step_assets

  • id — UUID — Primary key — NOT NULL
  • course_step_id — UUID — Foreign key → course_steps.id — NOT NULL
  • asset_id — UUID — Foreign key → assets.id — NOT NULL
  • asset_role — VARCHAR(40) — NOT NULL
  • sort_order — INTEGER — NOT NULL

course_steps

  • id — UUID — Primary key — NOT NULL
  • course_version_id — UUID — Foreign key → course_versions.id — NOT NULL
  • step_code — VARCHAR(50) — NOT NULL
  • step_type — VARCHAR(30) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • goal — TEXT
  • instruction — TEXT
  • estimated_minutes — INTEGER
  • sort_order — INTEGER — NOT NULL
  • completion_rule — VARCHAR(40) — NOT NULL
  • next_step_code — VARCHAR(50)
  • activity_type — VARCHAR(40)
  • activity_config_json — JSONB

course_types

  • id — SERIAL — Primary key — NOT NULL
  • type_code — VARCHAR(30) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • sort_order — INTEGER — NOT NULL

course_versions

  • id — UUID — Primary key — NOT NULL
  • course_id — UUID — Foreign key → courses.id — NOT NULL
  • version — VARCHAR(20) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • subtitle — VARCHAR(300)
  • summary — TEXT
  • language — VARCHAR(10) — NOT NULL
  • difficulty — VARCHAR(20)
  • recommended_minutes — INTEGER
  • audience_label — VARCHAR(100)
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • published_at — TIMESTAMPTZ

courses

  • id — UUID — Primary key — NOT NULL
  • course_code — VARCHAR(40) — NOT NULL
  • primary_type_id — INTEGER — Foreign key → course_types.id — NOT NULL
  • template_name — VARCHAR(200)
  • created_by — UUID — Foreign key → admins.id
  • is_system — BOOLEAN — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

enrollments

  • id — UUID — Primary key — NOT NULL
  • class_id — UUID — Foreign key → classes.id — NOT NULL
  • user_id — UUID — Foreign key → users.id
  • class_guest_id — UUID — Foreign key → class_guests.id
  • entry_method — VARCHAR(20) — NOT NULL
  • ticket_id — UUID — Foreign key → tickets.id
  • status — VARCHAR(20) — NOT NULL
  • enrolled_at — TIMESTAMPTZ — NOT NULL
  • completed_at — TIMESTAMPTZ

learner_artifacts

  • id — UUID — Primary key — NOT NULL
  • learner_course_progress_id — UUID — Foreign key → learner_course_progress.id — NOT NULL
  • deliverable_code — VARCHAR(50)
  • artifact_type — VARCHAR(40) — NOT NULL
  • storage_provider — VARCHAR(40)
  • storage_key — TEXT
  • mime_type — VARCHAR(100)
  • meta_json — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL

learner_course_progress

  • id — UUID — Primary key — NOT NULL
  • enrollment_id — UUID — Foreign key → enrollments.id — NOT NULL
  • class_course_id — UUID — Foreign key → class_courses.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • progress_percent — NUMERIC(5,2) — NOT NULL
  • current_step_code — VARCHAR(50)
  • started_at — TIMESTAMPTZ
  • completed_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ — NOT NULL

learner_inputs

  • id — UUID — Primary key — NOT NULL
  • learner_step_progress_id — UUID — Foreign key → learner_step_progress.id — NOT NULL
  • field_id — VARCHAR(80) — NOT NULL
  • input_type — VARCHAR(40) — NOT NULL
  • value_json — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL

learner_outputs

  • id — UUID — Primary key — NOT NULL
  • learner_step_progress_id — UUID — Foreign key → learner_step_progress.id — NOT NULL
  • ai_task_code — VARCHAR(50)
  • output_type — VARCHAR(40) — NOT NULL
  • value_json — JSONB
  • model — VARCHAR(100)
  • prompt_tokens — INTEGER
  • completion_tokens — INTEGER
  • total_tokens — INTEGER
  • created_at — TIMESTAMPTZ — NOT NULL

learner_step_progress

  • id — UUID — Primary key — NOT NULL
  • course_attempt_id — UUID — Foreign key → course_attempts.id — NOT NULL
  • step_code — VARCHAR(50) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • attempt_count — INTEGER — NOT NULL
  • started_at — TIMESTAMPTZ
  • completed_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ — NOT NULL

oauth_accounts

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • provider_user_id — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255)
  • created_at — TIMESTAMPTZ — NOT NULL

recommended_class_courses

  • id — UUID — Primary key — NOT NULL
  • recommended_class_id — UUID — Foreign key → recommended_classes.id — NOT NULL
  • course_id — UUID — Foreign key → courses.id — NOT NULL
  • course_version_id — UUID — Foreign key → course_versions.id — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • required — BOOLEAN — NOT NULL
  • completion_weight — NUMERIC(5,2) — NOT NULL

recommended_classes

  • id — UUID — Primary key — NOT NULL
  • class_template_code — VARCHAR(40) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • summary — TEXT
  • target — VARCHAR(100)
  • recommended_days — INTEGER
  • thumbnail_asset_id — UUID — Foreign key → assets.id
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

step_transitions

  • id — UUID — Primary key — NOT NULL
  • from_step_id — UUID — Foreign key → course_steps.id — NOT NULL
  • to_step_id — UUID — Foreign key → course_steps.id — NOT NULL
  • condition_json — JSONB
  • sort_order — INTEGER — NOT NULL

ticket_batches

  • id — UUID — Primary key — NOT NULL
  • class_id — UUID — Foreign key → classes.id — NOT NULL
  • label — VARCHAR(100)
  • quantity — INTEGER — NOT NULL
  • created_by — UUID — Foreign key → admins.id
  • created_at — TIMESTAMPTZ — NOT NULL

tickets

  • id — UUID — Primary key — NOT NULL
  • batch_id — UUID — Foreign key → ticket_batches.id — NOT NULL
  • class_id — UUID — Foreign key → classes.id — NOT NULL
  • code — VARCHAR(40) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • redeemed_at — TIMESTAMPTZ
  • enrollment_id — UUID — Foreign key → enrollments.id
  • created_at — TIMESTAMPTZ — NOT NULL

users

  • id — UUID — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255)
  • name — VARCHAR(100) — NOT NULL
  • profile_image_url — TEXT
  • status — VARCHAR(20) — NOT NULL
  • last_login_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL