캡디_ERD
테이블 (9)
Comment
- comment_id — INT
- playlist_id — INT — NOT NULL
- user_id — INT — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
Like
- like_id — INT
- playlist_id — INT — NOT NULL
- user_id — INT — NOT NULL
Music
- music_id — INT
- prompt_id — INT — NOT NULL
- file_url — VARCHAR(255) — NOT NULL
- genre — VARCHAR(100)
- duration — INT
- created_at — TIMESTAMP
Playlist
- playlist_id — INT
- user_id — INT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
PlaylistMusic
- playlist_music_id — INT
- playlist_id — INT — NOT NULL
- music_id — INT — NOT NULL
PlaylistTag
- playlist_tag_id — INT
- playlist_id — INT — NOT NULL
- tag_id — INT — NOT NULL
Prompt
- prompt_id — INT
- user_id — INT — NOT NULL
- text — TEXT — NOT NULL
- created_at — TIMESTAMP
Tag
- tag_id — INT
- tag_name — VARCHAR(255) — NOT NULL
User
- user_id — INT
- email — VARCHAR(255) — NOT NULL
- username — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP