music app
Tables (8)
album_songs
- id — INT
- album_id — INT
- song_id — INT
- order — INT
albums
- id — INT
- user_id — INT
- title — VARCHAR(255)
- description — TEXT
- cover_url — TEXT
- created_at — DATETIME
comments
- id — INT
- user_id — INT
- song_id — INT
- content — TEXT
- created_at — DATETIME
follows
- id — INT
- follower_id — INT
- following_id — INT
- created_at — DATETIME
likes
- id — INT
- user_id — INT
- song_id — INT
- created_at — DATETIME
listens
- id — INT
- user_id — INT
- song_id — INT
- played_at — DATETIME
songs
- id — INT
- user_id — INT
- title — VARCHAR(255)
- description — TEXT
- audio_url — TEXT
- cover_url — TEXT
- created_at — DATETIME
users
- id — INT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50)
- verified — BOOLEAN
- created_at — DATETIME