tutor_ai
Tables (14)
AuditLog
- id — TEXT — Primary key — NOT NULL
- eventId — TEXT — NOT NULL
- eventType — TEXT — NOT NULL
- occurredAt — TIMESTAMP(3) — NOT NULL
- payload — JSONB — NOT NULL
- recordedAt — TIMESTAMP(3) — NOT NULL
Badge
- id — TEXT — Primary key — NOT NULL
- userId — TEXT — NOT NULL
- code — TEXT — NOT NULL
- awardedAt — TIMESTAMP(3) — NOT NULL
ConversationSession
- id — TEXT — Primary key — NOT NULL
- userId — TEXT — NOT NULL
- startedAt — TIMESTAMP(3) — NOT NULL
- endedAt — TIMESTAMP(3)
ConversationTurn
- id — TEXT — Primary key — NOT NULL
- sessionId — TEXT — Foreign key → ConversationSession.id — NOT NULL
- seq — INTEGER — NOT NULL
- role — "TurnRole" — NOT NULL
- text — TEXT — NOT NULL
- createdAt — TIMESTAMP(3) — NOT NULL
DailyLearningStat
- id — TEXT — Primary key — NOT NULL
- userId — TEXT — NOT NULL
- date — DATE — NOT NULL
- speakingSeconds — INTEGER — NOT NULL
- turnCount — INTEGER — NOT NULL
- exerciseCount — INTEGER — NOT NULL
- updatedAt — TIMESTAMP(3) — NOT NULL
ExerciseAttempt
- id — TEXT — Primary key — NOT NULL
- userId — TEXT — NOT NULL
- type — "ExerciseType" — NOT NULL
- isCorrect — BOOLEAN
- completedAt — TIMESTAMP(3) — NOT NULL
LevelReport
- id — TEXT — Primary key — NOT NULL
- userId — TEXT — NOT NULL
- sessionId — TEXT — NOT NULL
- status — "AnalysisStatus" — NOT NULL
- level — TEXT
- summary — TEXT
- createdAt — TIMESTAMP(3) — NOT NULL
- completedAt — TIMESTAMP(3)
Membership
- id — TEXT — Primary key — NOT NULL
- userId — TEXT — Foreign key → User.id — NOT NULL
- plan — "MembershipPlan" — NOT NULL
- status — "MembershipStatus" — NOT NULL
- startedAt — TIMESTAMP(3) — NOT NULL
- expiresAt — TIMESTAMP(3)
- createdAt — TIMESTAMP(3) — NOT NULL
Notification
- id — TEXT — Primary key — NOT NULL
- userId — TEXT — NOT NULL
- type — TEXT — NOT NULL
- payload — JSONB — NOT NULL
- readAt — TIMESTAMP(3)
- createdAt — TIMESTAMP(3) — NOT NULL
OutboxEvent
- id — TEXT — Primary key — NOT NULL
- eventId — TEXT — NOT NULL
- eventType — TEXT — NOT NULL
- version — INTEGER — NOT NULL
- payload — JSONB — NOT NULL
- occurredAt — TIMESTAMP(3) — NOT NULL
- publishedAt — TIMESTAMP(3)
Payment
- id — TEXT — Primary key — NOT NULL
- userId — TEXT — Foreign key → User.id — NOT NULL
- plan — "MembershipPlan" — NOT NULL
- amountKrw — INTEGER — NOT NULL
- status — "PaymentStatus" — NOT NULL
- pgTransactionId — TEXT
- createdAt — TIMESTAMP(3) — NOT NULL
- updatedAt — TIMESTAMP(3) — NOT NULL
ProcessedEvent
- id — TEXT — Primary key — NOT NULL
- eventId — TEXT — NOT NULL
- consumer — TEXT — NOT NULL
- processedAt — TIMESTAMP(3) — NOT NULL
Streak
- userId — TEXT — Primary key — NOT NULL
- currentDays — INTEGER — NOT NULL
- lastStudiedOn — DATE
- updatedAt — TIMESTAMP(3) — NOT NULL
User
- id — TEXT — Primary key — NOT NULL
- email — TEXT — NOT NULL
- nickname — TEXT — NOT NULL
- createdAt — TIMESTAMP(3) — NOT NULL