soundscape

Tables (5)

music (Untitled2)

  • id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR
  • artist — VARCHAR
  • audio_object_key — VARCHAR
  • genre — VARCHAR
  • brightness — DECIMAL
  • energy — DECIMAL
  • calmness — DECIMAL
  • warmth — DECIMAL
  • positivity — DECIMAL
  • dreaminess — DECIMAL
  • duration_seconds — INT
  • created_at — DATETIME
  • updated_at — DATETIME

music_theme (Untitled5)

  • theme — VARCHAR — Primary key — NOT NULL
  • music_id (id) — BIGINT — Foreign key → music.id — NOT NULL

playlist (Untitled3)

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • title — VARCHAR
  • sorce_type — VARCHAR
  • sorce_genre — VARCHAR
  • cover_object_key — VARCHAR
  • created_at — DATETIME
  • updated_at — DATETIME

playlist_music (Untitled4)

  • id — BIGINT — Primary key — NOT NULL
  • music_id — BIGINT — Foreign key → music.id — NOT NULL
  • playlist_id — BIGINT — Foreign key → playlist.id — NOT NULL
  • position — INT

users (Untitled)

  • id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME — NOT NULL — ㅁㄴㅇㄹㅁㄴㅇㄹ
  • nickname — nickname