assessmentTest
Tables (7)
AssessmentTest (Untitled3)
- id (Key) — BIGINT — Primary key — NOT NULL
- assessment_test_group_id (Key2) — BIGINT — Foreign key → AssessmentTestGroup.id — NOT NULL
- entity_key (UUID KEY 설정) — VARCHAR(36)
- type (단어/문법/독해) — VARCHAR(10)
- created_at (생성일) — DATETIME
- updated_at (변경일) — DATETIME
AssessmentTestDetail (Untitled4)
- id (Key) — BIGINT — Primary key — NOT NULL
- assessment_test_id (Key2) — BIGINT — Foreign key → AssessmentTest.id — NOT NULL
- entity_key (UUID KEY 설정) — VARCHAR(36)
- question_number (문제번호) — BIGINT
- level (레벨) — BIGINT
- question (문제) — TEXT
- answer (학생답안) — VARCHAR(255)
- reason (근거) — TEXT
- created_at (생성일) — DATETIME
- updated_at (변경일) — DATETIME
AssessmentTestGroup (Untitled2)
- id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key2) — VARCHAR(36) — Foreign key → User.id — NOT NULL
- entity_key (UUID KEY 설정) — VARCHAR(36)
- test_date (진단고사 실시 날짜) — DATE
- subject (과목) — VARCHAR(10)
- created_at (생성일) — DATETIME
- updated_at (변경일) — DATETIME
AssessmentTestReport (Untitled6)
- id (Key) — BIGINT — Primary key — NOT NULL
- entity_key (UUID KEY 설정) — VARCHAR(36)
- name (이름) — VARCHAR(10)
- grade (학년) — VARCHAR(10)
- level (레벨) — INT
- overall_assessment (종합소견) — TEXT
- created_at (생성일) — DATETIME
- updated_at (변경일) — DATETIME
QuestionBank (Untitled5)
- id (Key) — BIGINT — Primary key — NOT NULL
- entity_key (UUID KEY 설정) — VARCHAR(36)
- subject (과목) — VARCHAR(10)
- type (타입) — VARCHAR(20)
- question (문제) — VARCHAR(255)
- level (수준) — INT
- created_at (생성일) — DATETIME
- updated_at (변경일) — DATETIME
StudentPrediction (Untitled7)
- id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → User.id — NOT NULL
- entity_key (UUID KEY 설정) — VARCHAR(36)
- level (레벨) — INT
- subject (과목) — VARCHAR(10)
- type (단어/문법/독해) — VARCHAR(10)
- question (문제) — VARCHAR(255)
- answer (학생답안) — VARCHAR(255)
- metacognition (메타인지) — INT
- expected_answer (답변 예상) — TINYINT(1)
- answer_reliability (답변 신뢰도) — INT
- result (결과) — TINYINT(1)
- reason (근거) — TEXT
- created_at (생성일) — DATETIME
- updated_at (변경일) — DATETIME
User (Untitled)
- id (Key) — BIGINT — Primary key — NOT NULL
- entity_key (UUID KEY 설정) — VARCHAR(36)
- name (이름) — VARCHAR(10)
- created_at (생성일) — DATETIME
- updated_at (변경일) — DATETIME