AI_EduBank

Tables (4)

evaluations

  • evaluation_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id
  • eval_type — TEXT — NOT NULL
  • total_score — FLOAT
  • concept_breakdown — JSONB
  • ai_diagnostic_comment — TEXT

logs

  • log_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id
  • question_id — TEXT — Foreign key → questions.question_id
  • is_correct — BOOLEAN — NOT NULL
  • time_spent — INT — NOT NULL
  • pattern_class — INT — NOT NULL
  • recommended_by_peer_count — INT
  • recommendation_score — FLOAT

questions

  • question_id — TEXT — Primary key — NOT NULL
  • subject — TEXT — NOT NULL
  • topic — TEXT — NOT NULL
  • concept_tag — TEXT — NOT NULL
  • difficulty_level — TEXT
  • is_essential — BOOLEAN
  • essential_weight — FLOAT
  • discrimination_idx — FLOAT
  • difficulty — FLOAT
  • content — TEXT — NOT NULL
  • answer — TEXT — NOT NULL
  • remedial_content_id — TEXT

users

  • user_id — BIGINT — Primary key — NOT NULL
  • name — TEXT — NOT NULL
  • ai_literacy_level — INT
  • learning_tendency — TEXT
  • pattern_vector — JSONB
  • theta — FLOAT
  • level — INT