ERD

Tables (13)

AI_VOCAL_ANALYSIS (Untitled6)

  • id — bigint — Primary key — NOT NULL
  • analysis_engine — varchar
  • pitch_score — int
  • rhythm_score — int
  • vocal_grade — varchar
  • summary — varchar
  • analyzed_at — timestamptz
  • id (user_vocal_recording_id) — bigint — Foreign key → USER_VOCAL_RECORDING.id — NOT NULL

CATALOG_SONG (Untitled2)

  • catalog_song_id — varchar — Primary key — NOT NULL
  • title — varchar
  • artist — varchar
  • bpm — int
  • song_key — varchar
  • range_label — varchar
  • mr_track_name — varchar
  • mr_description — varchar

INSTRUMENT_EVALUATIONS (Untitled8)

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamptz
  • id (user_id) — bigint — Foreign key → USER.id — NOT NULL

INSTRUMENT_RECORDING (Untitled9)

  • id — bigint — Primary key — NOT NULL
  • instrument_id — varchar
  • file_name — varchar
  • duration_sec — int
  • recorded_at — timestamptz
  • id (user_id) — bigint — Foreign key → USER.id — NOT NULL
  • id (instrument_evaluation_id) — bigint — Foreign key → INSTRUMENT_EVALUATIONS.id — NOT NULL

INSTRUMENT_TUNING_ANALYSIS (Untitled10)

  • id — bigint — Primary key — NOT NULL
  • analysis_engine — varchar
  • tuning_accuracy — int
  • pitch_deviation_cents — int
  • summary — varchar
  • string_readings — json
  • analyzed_at — timestamptz
  • id (instrument_recording_id) — bigint — Foreign key → INSTRUMENT_RECORDING.id — NOT NULL

RECOMMENDATIONS (Untitled7)

  • id — bigint — Primary key — NOT NULL
  • vocalization_pattern — varchar
  • recommended_genres — json
  • recommended_songs — json
  • created_at — timestamptz
  • id (sing_evaluation_id) — bigint — Foreign key → SING_EVALUATIONS.id — NOT NULL
  • id (ai_vocal_analysis_id) — bigint — Foreign key → AI_VOCAL_ANALYSIS.id — NOT NULL

SING_EVALUATIONS (Untitled4)

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamptz
  • id (user_id) — bigint — Foreign key → USER.id — NOT NULL

SONG_MR (Untitled3)

  • id — bigint — Primary key — NOT NULL
  • search_query — varchar
  • title — varchar
  • artist — varchar
  • bpm — int
  • song_key — varchar
  • range_label — varchar
  • mr_track_name — varchar
  • mr_description — varchar
  • created_at — timestamptz
  • catalog_song_id — varchar — Foreign key → CATALOG_SONG.catalog_song_id — NOT NULL

SPEECH_EVALUATIONS (Untitled11)

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamptz
  • id (user_id) — bigint — Foreign key → USER.id — NOT NULL

SPEECH_FEEDBACK_ANALYSIS (Untitled13)

  • id — bigint — Primary key — NOT NULL
  • analysis_engine — varchar
  • clarity_score — int
  • pace_score — int
  • tone_score — int
  • summary — varchar
  • feedback_points — json
  • analyzed_at — timestamptz
  • id (speech_recording_id) — bigint — Foreign key → SPEECH_RECORDING.id — NOT NULL

SPEECH_RECORDING (Untitled12)

  • id — bigint — Primary key — NOT NULL
  • topic_id — varchar
  • file_name — varchar
  • duration_sec — int
  • recorded_at — timestamptz
  • id (speech_evaluation_id) — bigint — Foreign key → SPEECH_EVALUATIONS.id — NOT NULL
  • id (user_id) — bigint — Foreign key → USER.id — NOT NULL

USER (Untitled)

  • id — bigint — Primary key — NOT NULL
  • username — varchar
  • nickname — varchar
  • email — varchar
  • role — varchar

USER_VOCAL_RECORDING (Untitled5)

  • id — bigint — Primary key — NOT NULL
  • input_source — varchar
  • file_name — varchar
  • duration_sec — int
  • content_type — varchar
  • storage_uri — varchar
  • recorded_at — timestamptz
  • id (user_id) — bigint — Foreign key → USER.id — NOT NULL
  • catalog_song_id — varchar — Foreign key → CATALOG_SONG.catalog_song_id — NOT NULL
  • id (mr_search_list_id) — bigint — Foreign key → SONG_MR.id — NOT NULL
  • id (sing_evaluation_id) — bigint — Foreign key → SING_EVALUATIONS.id — NOT NULL