new

Tables (7)

lyrics_segment

  • segment_id — VARCHAR — Primary key
  • track_id — VARCHAR — Foreign key → track.track_id
  • start_ms — INTEGER — NOT NULL
  • end_ms — INTEGER — NOT NULL
  • text — TEXT — NOT NULL
  • embedding — BYTEA
  • emotion_label — VARCHAR
  • created_time — TIMESTAMP — NOT NULL
  • updated_time — TIMESTAMP — NOT NULL

media_clip

  • clip_id — BIGSERIAL — Primary key — NOT NULL
  • track_id — VARCHAR — Foreign key → track.track_id
  • platform — Enum — NOT NULL
  • url — VARCHAR — NOT NULL
  • title — VARCHAR
  • created_time — TIMESTAMP — NOT NULL

segment_shortform_map

  • map_id — BIGSERIAL — Primary key
  • segment_id — VARCHAR — Foreign key → lyrics_segment.segment_id
  • sound_id — VARCHAR — Foreign key → shortform_sound.sound_id
  • clip_start_ms — INTEGER
  • clip_end_ms — INTEGER
  • confidence — INTEGER — NOT NULL
  • evidence_count — INTEGER — NOT NULL
  • last_verified_at — TIMESTAMP

segment_stats

  • segment_id — VARCHAR — Primary key
  • segment_id (segment_id2) — VARCHAR — Foreign key → lyrics_segment.segment_id
  • weekly_highlights — INTEGER — NOT NULL
  • weekly_saves — INTEGER — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

shortform_sound

  • sound_id — VARCHAR — Primary key
  • origin_track_id — VARCHAR — Foreign key → track.track_id
  • platform — platform_enum — NOT NULL
  • title — VARCHAR
  • created_time — TIMESTAMP — NOT NULL

track

  • track_id — VARCHAR — Primary key
  • title — VARCHAR — NOT NULL
  • artist_main — VARCHAR — NOT NULL
  • release_date — DATE
  • genre_primary — VARCHAR
  • mood_primary — VARCHAR
  • created_time — TIMESTAMP — NOT NULL
  • updated_time — TIMESTAMP — NOT NULL

track_credit

  • credit_id — BIGSERIAL — Primary key
  • track_id — VARCHAR — Foreign key → track.track_id
  • person_name — VARCHAR — NOT NULL
  • role — Enum — NOT NULL
  • notes — VARCHAR
  • created_time — TIMESTAMP — NOT NULL