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