ody_table

Tables (19)

artwork

  • id — int8 — Primary key — NOT NULL
  • round_id — int8 — Foreign key → artwork_round.id — NOT NULL
  • email — varchar(255) — NOT NULL
  • playlist_id — int8
  • title — varchar(100) — NOT NULL
  • layout_version — varchar(50) — NOT NULL
  • status — varchar(20) — NOT NULL
  • score — int4
  • ai_comment — text
  • model — varchar(100)
  • attempt_cnt — int4 — NOT NULL
  • fail_reason — varchar(200)
  • like_cnt — int4 — NOT NULL
  • evaluated_at — timestamptz
  • created_at — timestamptz — NOT NULL
  • is_anchor — bool — NOT NULL
  • closed — bool — NOT NULL

artwork_like

  • email — varchar(255) — Primary key — NOT NULL
  • artwork_id — int8 — Foreign key → artwork.id — NOT NULL
  • created_at — timestamptz — NOT NULL

artwork_point

  • position — int4 — Primary key — NOT NULL
  • artwork_id — int8 — Foreign key → artwork.id — NOT NULL
  • music_id — int8 — NOT NULL
  • x — float8 — NOT NULL
  • y — float8 — NOT NULL

artwork_round

  • id — int8 — Primary key — NOT NULL
  • theme — varchar(50) — NOT NULL
  • theme_prompt — text — NOT NULL
  • starts_at — timestamptz — NOT NULL
  • ends_at — timestamptz — NOT NULL
  • created_at — timestamptz — NOT NULL
  • vote_limit — int4 — NOT NULL
  • ai_weight — numeric — NOT NULL

explore_feedback

  • id — bigserial — Primary key — NOT NULL
  • session_id — uuid — NOT NULL
  • mode — text — NOT NULL
  • rank — int2 — NOT NULL
  • anchor_music_id — int8 — NOT NULL
  • target_music_id — int8
  • prev_music_id — int8
  • music_id — int8 — NOT NULL
  • verdict — bool
  • reason — text
  • listened_sec — int2
  • skipped — bool — NOT NULL
  • user_email — varchar(255)
  • bundle — text — NOT NULL
  • rules — text — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • anonymous_id — uuid

follow

  • id — int8 — Primary key — NOT NULL
  • follower_email — varchar(255) — NOT NULL
  • followee_email — varchar(255) — NOT NULL
  • created_at — timestamptz — NOT NULL

map_sample

  • layer — int2 — Primary key — NOT NULL
  • gx — int2 — Primary key — NOT NULL
  • gy — int2 — Primary key — NOT NULL
  • music_id — int8 — Primary key — NOT NULL
  • x — float4 — NOT NULL
  • y — float4 — NOT NULL
  • title — varchar(200)
  • artist — varchar(500)
  • cnt — int4 — NOT NULL

meeting

  • user1 — varchar(255) — Foreign key → user.email — NOT NULL
  • user2 — varchar(255) — Foreign key → user.email — NOT NULL
  • cnt — int4 — NOT NULL

music

  • id — int8 — Primary key — NOT NULL
  • mbid — varchar(64) — NOT NULL
  • title — varchar(200) — NOT NULL
  • artist — varchar(500)
  • release_year — int2
  • bpm — numeric(5, 1)
  • duration — int4
  • album — varchar(200)
  • youtube_url — text
  • location — public.vector
  • play_cnt — int4 — NOT NULL
  • youtube_cnt — int4 — NOT NULL
  • album_mbid — varchar(36)
  • acoustic_cnt — int4
  • video_id — varchar(11)
  • is_unplayable — bool — NOT NULL

music_discovery

  • music_id — int8 — Primary key — NOT NULL
  • email — varchar(255) — NOT NULL
  • discovered_at — timestamptz — NOT NULL

music_like

  • music_id — int8 — Primary key — NOT NULL
  • email — varchar(255) — Foreign key → user.email — NOT NULL
  • created_at — timestamptz — NOT NULL

music_report

  • report_id — bigserial — Primary key — NOT NULL
  • music_id — int8 — NOT NULL
  • user_email — varchar(255) — Foreign key → user.email
  • reason — varchar(16) — NOT NULL
  • created_at — timestamptz — NOT NULL
  • detail_reason — text

play_history

  • id — bigserial — Primary key — NOT NULL
  • music_id — int8 — NOT NULL
  • email — varchar(255)
  • source — varchar(20) — NOT NULL
  • played_ms — int4 — NOT NULL
  • played_at — timestamptz — NOT NULL

playlist

  • id — int8 — Primary key — NOT NULL
  • email — varchar(255) — NOT NULL
  • playlist_name — varchar(200) — NOT NULL
  • like_cnt — int4 — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

playlist_item

  • music_id — int8 — Primary key — NOT NULL
  • playlist_id — int8 — Foreign key → playlist.id — NOT NULL
  • added_at — timestamptz — NOT NULL
  • position — int4 — NOT NULL

playlist_like

  • email — varchar(255) — Primary key — NOT NULL
  • playlist_id — int8 — Foreign key → playlist.id — NOT NULL
  • created_at — timestamptz — NOT NULL

refresh_token

  • id — int8 — Primary key — NOT NULL
  • email — varchar(255) — NOT NULL
  • token_hash — bpchar(64) — NOT NULL
  • device_id — varchar(100) — NOT NULL
  • expires_at — timestamptz — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

taste_analysis

  • analysis_date — date — Primary key — NOT NULL
  • email — varchar(255) — Foreign key → user.email — NOT NULL
  • status — varchar(16) — NOT NULL
  • requested_at — timestamptz — NOT NULL
  • lease_expires_at — timestamptz
  • completed_at — timestamptz
  • liked_set_hash — bpchar(64)
  • valid_music_count — int4
  • report_level — varchar(16)
  • analysis_version — varchar(128)
  • model — varchar(128)
  • axis_stats — jsonb
  • findings — jsonb
  • summary — text
  • narratives — jsonb
  • gms_response_id — varchar(255)
  • failure_code — varchar(64)

user

  • email — varchar(255) — Primary key — NOT NULL
  • name — varchar(100)
  • nickname — varchar(100)
  • is_public — bool — NOT NULL
  • last_active_at — timestamptz
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • image_url — varchar(512)
  • tutorial_completed — bool
  • password_hash — varchar(60)
  • is_bot — bool — NOT NULL