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