maestro
Tables (10)
AUDIO_FEATURES (Untitled2)
- id (Key) — uuid — Primary key — NOT NULL
- id — bigint — Foreign key → STUDIO_WORKSPACES.id — NOT NULL
- id (id2) — bigint — Foreign key → STUDIO_WORKSPACES.id — NOT NULL
- id (id3) — bigint — Foreign key → USERS.id — NOT NULL
- user_id (Field) — bigint
- workspace_id (Field2) — bigint
- bpm (Field3) — float
- energy (Field4) — float
- valence (Field5) — float
- danceability (Field6) — float
- spectral_centroid (Field7) — float
- loudness (Field8) — float
- key (Field9) — int
- mode (Field10) — int
- genre_primary (Field11) — varchar
- genre_secondary (Field12) — varchar
- mood_tags (Field13) — varchar_array
- source (Field14) — varchar
- source_url (Field15) — text
- duration_sec (Field16) — float
- created_at (Field17) — timestamptz
FAQ_ENTRIES (FAQ_ENTIRES)
- id — bigint — Primary key — NOT NULL
- id (id2) — bigint — Foreign key → USERS.id — NOT NULL
- bigint (created_by_admin_id) — bigint — NOT NULL
- varchar (category) — varchar
- text (question) — text — NOT NULL
- text (answer) — text — NOT NULL
- timestamptz (created_at) — timestamptz — NOT NULL
GALLERY_ITEMS (Untitled)
- id (Key) — bigint — Primary key — NOT NULL
- id — bigint — Foreign key → USERS.id — NOT NULL
- admin_user_id (Field) — bigint
- work_title (Field2) — varchar
- artist (Field3) — varchar
- genre_tags (Field4) — varchar
- media_url (Field5) — text
- created_at (Field6) — timestamptz
GENERATION_LOGS (Untitled4)
- id (Key) — uuid — Primary key — NOT NULL
- id — bigint — Foreign key → STUDIO_WORKSPACES.id — NOT NULL
- id (id2) — bigint — Foreign key → STUDIO_WORKSPACES.id — NOT NULL
- id (Key2) — uuid — Foreign key → AUDIO_FEATURES.id — NOT NULL
- id (id3) — bigint — Foreign key → AUDIO_FEATURES.id — NOT NULL
- id (id22) — bigint — Foreign key → AUDIO_FEATURES.id — NOT NULL
- id (id32) — bigint — Foreign key → AUDIO_FEATURES.id — NOT NULL
- user_id (Field) — bigint
- workspace_id (Field2) — bigint
- audio_feature_id (Field3) — uuid
- prompt_params (Field4) — jsonb
- model_version (Field5) — varchar
- pipeline_version (Field6) — varchar
- output_assert_url (Field7) — text
- render_ms (Field8) — int
- quality_score (Field9) — float
- style_vector (Field10) — float_array
- status (Field11) — varchar
- error_message (Field12) — text
- created_at (Field13) — timestamptz
- completed_at (Field14) — timestamptz
MAGAZINE_ARTICLES (Untitled7)
- id (Key) — bigint — Primary key — NOT NULL
- id — bigint — Foreign key → USERS.id — NOT NULL
- author_admin_id (Field) — bigint
- article_title (Field2) — varchar
- author (Field3) — varchar
- excerpt (Field4) — text
- body (Field5) — text
- created_at (Field6) — timestamptz
STUDIO_ANALYTICS (Untitled5)
- id (Key) — bigint — Primary key — NOT NULL
- id — bigint — Foreign key → STUDIO_WORKSPACES.id — NOT NULL
- id (id2) — bigint — Foreign key → STUDIO_WORKSPACES.id — NOT NULL
- workspace_id (Field) — bigint
- track_title (Field2) — varchar
- bpm (Field3) — int
- mood (Field4) — varchar
- genre (Field5) — varchar
- created_at (Field6) — timestamptz
STUDIO_WORKSPACES (..)
- id — bigint — Primary key — NOT NULL
- id (id2) — bigint — Foreign key → USERS.id — NOT NULL
- user_id — bigint
- workspace_name — varchar
- glitch_intensity — int
- notes — text
- created_at — timestamptz
USERS
- id — bigint — Primary key — NOT NULL
- username — varchar
- nickname — varchar
- password_hash — varchar
- role — varchar
- email — varchar
- Field2 (created_at) — timestamptz
USER_EVENTS (Untitled6)
- id (Key) — uuid — Primary key — NOT NULL
- id — bigint — Foreign key → USERS.id — NOT NULL
- user_id (Field) — bigint
- session_id (Field2) — varchar
- event_type (Field3) — varchar
- target_id (Field4) — uuid
- target_type (Field5) — varchar
- dwell_ms (Field6) — int
- payload (Field7) — jsonb
- created_at (Field8) — timestamptz
VISUAL_RATINGS (Untitled3)
- id (Key) — uuid — Primary key — NOT NULL
- generation_id (Field) — uuid
- rater_id (Field2) — bigint
- aesthetic_score (Field3) — int
- genre_match_score (Field4) — int
- mood_match_score (Field5) — int
- ab_test_id (Field6) — varchar
- ab_winner (Field7) — boolean
- flag (Field8) — varchar
- flag_reason (Field9) — text
- rater_type (Field10) — varchar
- created_at (Field11) — timestamptz