전종설2 3주차

테이블 (13)

ActivityLog

  • id — UUID
  • userId — TEXT — NOT NULL
  • type — activity_type — NOT NULL
  • gradeId — TEXT — NOT NULL
  • subjectId — TEXT — NOT NULL
  • subjectName — TEXT — NOT NULL
  • materialId — TEXT — NOT NULL
  • materialTitle — TEXT — NOT NULL
  • page — INTEGER
  • title — TEXT — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • updatedAt — TIMESTAMP — NOT NULL

Grade

  • id — TEXT
  • year — INTEGER — NOT NULL
  • term — INTEGER — NOT NULL
  • userId — TEXT — 외래 키 → User.id — NOT NULL
  • isCurrent — BOOLEAN — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL

Job

  • id — TEXT
  • type — TEXT — NOT NULL
  • status — TEXT — NOT NULL
  • priority — INTEGER — NOT NULL
  • materialId — TEXT
  • page — INTEGER
  • payload — JSONB
  • attempts — INTEGER — NOT NULL
  • maxAttempts — INTEGER — NOT NULL
  • lockedAt — TIMESTAMP
  • lockedBy — TEXT
  • lastError — TEXT
  • createdAt — TIMESTAMP — NOT NULL
  • updatedAt — TIMESTAMP — NOT NULL

Material

  • id — TEXT
  • subjectId — TEXT — 외래 키 → Subject.id — NOT NULL
  • week — INTEGER — NOT NULL
  • title — TEXT — NOT NULL
  • storagePath — TEXT — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL

MaterialPageText

  • id — TEXT
  • materialId — TEXT — 외래 키 → Material.id — NOT NULL
  • page — INTEGER — NOT NULL
  • text — TEXT — NOT NULL
  • charCount — INTEGER — NOT NULL
  • method — TEXT
  • status — TEXT — NOT NULL
  • error — TEXT
  • extractedAt — TIMESTAMP — NOT NULL
  • updatedAt — TIMESTAMP — NOT NULL

MaterialSummary

  • id — TEXT
  • materialId — TEXT — 외래 키 → Material.id — NOT NULL
  • sourceHash — TEXT — NOT NULL
  • content — TEXT — NOT NULL
  • provider — TEXT
  • model — TEXT
  • promptVersion — TEXT
  • createdAt — TIMESTAMP — NOT NULL
  • updatedAt — TIMESTAMP — NOT NULL

Note

  • id — TEXT
  • materialId — TEXT — 외래 키 → Material.id — NOT NULL
  • page — INTEGER — NOT NULL
  • content — TEXT — NOT NULL
  • updatedAt — TIMESTAMP — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL

QuizAnswer

  • id — TEXT
  • attemptId — TEXT — 외래 키 → QuizAttempt.id — NOT NULL
  • quizItemId — TEXT — 외래 키 → QuizItem.id — NOT NULL
  • response — JSONB — NOT NULL
  • isCorrect — BOOLEAN
  • earned — INTEGER
  • feedback — TEXT
  • createdAt — TIMESTAMP — NOT NULL
  • updatedAt — TIMESTAMP — NOT NULL

QuizAttempt

  • id — TEXT
  • userId — TEXT — NOT NULL
  • quizSetId — TEXT — 외래 키 → QuizSet.id — NOT NULL
  • status — TEXT — NOT NULL
  • score — INTEGER
  • maxScore — INTEGER
  • startedAt — TIMESTAMP — NOT NULL
  • submittedAt — TIMESTAMP
  • gradedAt — TIMESTAMP

QuizItem

  • id — TEXT
  • quizSetId — TEXT — 외래 키 → QuizSet.id — NOT NULL
  • order — INTEGER — NOT NULL
  • type — TEXT — NOT NULL
  • question — TEXT — NOT NULL
  • choices — JSONB
  • answerKey — JSONB — NOT NULL
  • explanation — TEXT
  • points — INTEGER — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL

QuizSet

  • id — TEXT
  • materialId — TEXT — 외래 키 → Material.id — NOT NULL
  • summaryId — TEXT
  • sourceHash — TEXT — NOT NULL
  • title — TEXT
  • provider — TEXT
  • model — TEXT
  • promptVersion — TEXT
  • createdAt — TIMESTAMP — NOT NULL

Subject

  • id — TEXT
  • name — TEXT — NOT NULL
  • gradeId — TEXT — 외래 키 → Grade.id — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • isCurrent — BOOLEAN — NOT NULL

User

  • id — TEXT
  • email — TEXT — NOT NULL
  • password — TEXT — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL