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