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