ㄴㅁㅇ
Tables (5)
likes
- id — INT — Primary key — NOT NULL
- music_id — INT — Foreign key → musics.id — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- user_id — VARCHAR(100) — Foreign key → users.uid
lives
- id — INT — Primary key — NOT NULL
- live_url — VARCHAR(150) — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- user_id — VARCHAR(100) — Foreign key → users.uid
musics
- id — INT — Primary key — NOT NULL
- songName — VARCHAR(100) — NOT NULL
- artist — VARCHAR(50) — NOT NULL
- songImg — VARCHAR(100)
- musicResource — VARCHAR(200)
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
playlists
- id — INT — Primary key — NOT NULL
- playlistName — VARCHAR(100) — NOT NULL
- music_id — INT — Foreign key → musics.id — NOT NULL
- isLive — TINYINT(1) — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- user_id — VARCHAR(100) — Foreign key → users.uid
users
- uid — VARCHAR(100) — Primary key — NOT NULL
- nickname — VARCHAR(20) — NOT NULL
- profileImg — VARCHAR(255)
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL