yoyakjung

Tables (5)

RecommendedAudiobooks

  • id — UUID — Primary key — NOT NULL
  • audiobookId — UUID — Primary key — NOT NULL
  • referenceMonth — DATE
  • createdAt — TIMESTAMP — NOT NULL

Summaries

  • summaryId — UUID — Primary key — NOT NULL
  • userId — UUID — Foreign key → Users.userId — NOT NULL
  • title — VARCHAR — NOT NULL
  • originalSize — INTEGER
  • summarySize — INTEGER
  • status — VARCHAR — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL

SummaryContents

  • summaryId — UUID — Foreign key → Summaries.summaryId — NOT NULL
  • originalContent — TEXT
  • summaryContent — TEXT
  • keyPoints — TEXT

Top10Audiobooks

  • id — UUID — Primary key — NOT NULL
  • audiobookId — UUID — Primary key — NOT NULL
  • rank — INTEGER — NOT NULL
  • referenceMonth — DATE — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL

Users

  • userId — UUID — Primary key — NOT NULL
  • email — VARCHAR — NOT NULL
  • passwordHash — TEXT — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL