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