전종설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