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