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