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