test
Tables (10)
scenario_categories
- id — bigint — Primary key — NOT NULL
- category_name — varchar
scenario_sequences
- id — bigint — Primary key — NOT NULL
- scenario_id — bigint — NOT NULL
- seq_no — int
- question — varchar
- is_deleted — tinyint
- created_at — timestamp
- updated_at — timestamp
scenario_sessions
- id — bigint — Primary key — NOT NULL
- student_id — bigint — NOT NULL
- scenario_id — bigint — NOT NULL
- session_status — ENUM
- is_deleted — tinyint
- created_at — timestamp
- updated_at — timestamp
scenarios
- id — bigint — Primary key — NOT NULL
- category_id — bigint — NOT NULL
- title — varchar(100)
- summary — varchar(255)
- thumbnail_s3_key — varchar
- background_s3_key — varchar
- total_sequences — int
- difficulty_level — ENUM
- is_deleted — tinyint
- created_at — timestamp
- updated_at — timestamp
schools
- id — bigint — Primary key — NOT NULL
- school_name — varchar(100)
- created_at — timestamp
- updated_at — timestamp
seq_options
- id — bigint — Primary key — NOT NULL
- seq_id — bigint — NOT NULL
- option_no — int
- option_text — varchar
- option_s3_key — varchar
- is_answer — tinyint
- is_deleted — tinyint
- created_at — timestamp
- updated_at — timestamp
session_answers
- id — bigint — Primary key — NOT NULL
- session_id — bigint — NOT NULL
- seq_id — bigint — NOT NULL
- is_correct — tinyint
- attempt_no — int
- created_at — timestamp
- updated_at — timestamp
session_stt_answers
- id — bigint — Primary key — NOT NULL
- session_id — bigint — NOT NULL
- seq_id — bigint — NOT NULL
- audio_s3_key — varchar
- transcribed_text — varchar
- answer__text — varchar
- similarity_score — BigDecimal
- is_correct — Boolean
- attempt_no — int
- created_at — timestamp
- updated_at — timestamp
students
- id — bigint — Primary key — NOT NULL
- school_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
- name — varchar(50)
- is_deleted — tinyint
- created_at — timestamp
- updated_at — timestamp
users
- id — bigint — Primary key — NOT NULL
- school_id — bigint — NOT NULL
- username — varchar(50)
- password — varchar(255)
- name — varchar(50)
- email — varchar(200)
- role — enum
- is_deleted — tinyint
- created_at — timestamp
- updated_at — timestamp