real_music_app
Tables (4)
likes
- user_id — INT — Foreign key → users.id
- song_id — INT — Foreign key → songs.id
- created_at — DATETIME
- updated_at — DATETIME
recent_plays
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → users.id
- song_id — INT — Foreign key → songs.id
- played_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
songs
- id — INT — Primary key
- title — VARCHAR(30) — NOT NULL
- cover_url — VARCHAR(255)
- audio_url — VARCHAR(255) — NOT NULL
- duration — INT
- created_at — DATETIME
- updated_at — DATETIME
- uploader_id — INT — Foreign key → users.id
users
- id — INT — Primary key
- email — VARCHAR(30) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- username — VARCHAR(30) — NOT NULL
- profile_image_url — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME
- isVerified — BOOLEAN
- signup_token — VARCHAR(255)
- signup_token_expiration — DATETIME
- Field