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