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