lingcast
Tables (8)
interests
- interest_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
news
- news_id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(500) — NOT NULL
- source — VARCHAR(100) — NOT NULL
- original_url — VARCHAR(1000) — NOT NULL
- category — VARCHAR(50) — NOT NULL
- summary — TEXT
- published_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
podcast_news
- podcast_news_id — BIGINT — Primary key — NOT NULL
- podcast_id — BIGINT — Foreign key → podcasts.podcast_id — NOT NULL
- news_id — BIGINT — Foreign key → news.news_id — NOT NULL
- display_order — INT — NOT NULL
podcasts
- podcast_id — BIGINT — Primary key — NOT NULL
- category — VARCHAR(50) — NOT NULL
- topic — VARCHAR(100)
- title — VARCHAR(255) — NOT NULL
- english_level — VARCHAR(20) — NOT NULL
- script — LONGTEXT — NOT NULL
- status — VARCHAR(30) — NOT NULL
- published_date — DATE — NOT NULL
- created_at — DATETIME — NOT NULL
saved_podcasts
- saved_podcast_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- podcast_id — BIGINT — Foreign key → podcasts.podcast_id — NOT NULL
- saved_at — DATETIME — NOT NULL
user_interests
- user_interest_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- interest_id — BIGINT — Foreign key → interests.interest_id — NOT NULL
user_podcast_history
- history_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- podcast_id — BIGINT — Foreign key → podcasts.podcast_id — NOT NULL
- last_position_seconds — INT — NOT NULL
- listened_seconds — INT — NOT NULL
- is_completed — BOOLEAN — NOT NULL
- last_listened_at — DATETIME
users
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50)
- english_level — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL