DRIFT
Tables (4)
satellites
- id — UUID — Primary key — NOT NULL
- owner_id — UUID — Foreign key → users.id — NOT NULL
- song_id — UUID — Foreign key → songs.id — NOT NULL
- message — VARCHAR
- created_at — TIMESTAMP — NOT NULL
songs
- id — UUID — Primary key — NOT NULL
- title — VARCHAR — NOT NULL
- artist — VARCHAR — NOT NULL
- cover_url — VARCHAR
- preview_url — VARCHAR
- genre_tags — VARCHAR — Last.fm 태그 목록
- song_vector — FLOAT — 75차원 곡 벡터
- coord_x — FLOAT
- coord_y — FLOAT
- coord_z — FLOAT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
user_songs
- id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.id — NOT NULL
- song_id — UUID — Foreign key → songs.id — NOT NULL
- saved_at — TIMESTAMP — NOT NULL
- play_count — INT — NOT NULL
- source — VARCHAR — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
users
- id — UUID — Primary key — NOT NULL
- email — VARCHAR — NOT NULL
- username — VARCHAR — NOT NULL
- password_hash — VARCHAR — NOT NULL
- taste_vector — FLOAT — 75차원 취향 벡터
- vector_updated_at — TIMESTAMP
- coord_x — FLOAT
- coord_y — FLOAT
- coord_z — FLOAT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL