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