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