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