musicService2
Tables (16)
album (앨범)
- album_id (id) — BIGINT — Primary key — NOT NULL
- artist_id (id2) — BIGINT — Foreign key → artist.artist_id — NOT NULL
- title (앨범명) — VARCHAR(100) — NOT NULL
- cover_image_url (앨범커버) — VARCHAR(255)
- release_date (발매일) — DATE
artist (아티스트)
- artist_id (아티스트ID) — BIGINT — Primary key — NOT NULL
- name (아티스트이름) — VARCHAR(100) — NOT NULL
- profile_image_url (프로필이미지) — VARCHAR(255)
comment
- comment_id (코멘트ID) — BIGINT — Primary key — NOT NULL
- user_id (사용자ID) — BIGINT — Foreign key → user.user_id — NOT NULL
- target_type — ENUM('TRACK', 'ALBUM') — NOT NULL
- target_id — BIGINT — NOT NULL
- parent_comment_id — BIGINT
- content — TEXT
distributor_request (등록요청)
- dR_id (유통사요청ID) — BIGINT — Primary key — NOT NULL
- user_id (사용자ID) — BIGINT — Foreign key → user.user_id — NOT NULL
- target_type — ENUM('TRACK', 'ALBUM') — NOT NULL
- target_id — BIGINT — NOT NULL
- status — ENUM('PENDING', 'APPROVED', 'REJECTED')
- requested_at — DATETIME
download_log (다운로드 기록)
- download_id (다운로드ID) — BIGINT — Primary key
- user_id (사용자ID) — BIGINT — Foreign key → user.user_id — NOT NULL
- track_id (곡ID) — BIGINT — NOT NULL
- downloaded_at — DATETIME
genre (장르)
- genre_id (장르ID) — BIGINT — Primary key — NOT NULL
- name (장르명) — VARCHAR(50) — NOT NULL
like
- like_id (좋아요ID) — BIGINT — Primary key — NOT NULL
- user_id (사용자ID) — BIGINT — Foreign key → user.user_id — NOT NULL
- user_id — BIGINT — NOT NULL
- target_type — ENUM('TRACK', 'ALBUM', 'ARTIST') — NOT NULL
- target_id — BIGINT — NOT NULL
notification (알림)
- noti_id (알림ID) — BIGINT — Primary key — NOT NULL
- user_id (사용자ID) — BIGINT — Foreign key → user.user_id — NOT NULL
- type — ENUM('INVITE', 'RELEASE', 'SYSTEM') — NOT NULL
- message — TEXT
- is_read — BOOLEAN
payment (결제)
- payment_id (id) — BIGINT — Primary key — NOT NULL
- user_id (사용자ID) — BIGINT — Foreign key → user.user_id — NOT NULL
- amount — DECIMAL(10, 2) — NOT NULL
- method — ENUM('CARD', 'PHONE', 'BANK', 'ETC') — NOT NULL
- status — ENUM('COMPLETE', 'FAIL', 'REFUND') — NOT NULL
- transaction_id — VARCHAR(255)
- paid_at — DATETIME
playlist (플레이리스트)
- playlist_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (사용자ID) — BIGINT — Foreign key → user.user_id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- is_public — BOOLEAN
playlist_track (플레이리스트에 담긴 곡)
- playlist_trak_id (id) — BIGINT — Primary key — NOT NULL
- playlist_id (Key) — BIGINT — Foreign key → playlist.playlist_id — NOT NULL
- user_id (사용자ID) — BIGINT — Foreign key → playlist.user_id — NOT NULL
- artist_id (아티스트ID) — BIGINT — Foreign key → track.artist_id — NOT NULL
- album_id (앨범ID) — BIGINT — Foreign key → track.album_id — NOT NULL
- track_id (곡ID) — BIGINT — Foreign key → track.track_id — NOT NULL
- genre_id (장르ID) — BIGINT — Foreign key → track.genre_id — NOT NULL
- sequence_order — INT
track (곡)
- track_id (곡ID) — BIGINT — Primary key — NOT NULL
- artist_id (아티스트ID) — BIGINT — Foreign key → album.artist_id — NOT NULL
- album_id (앨범ID) — BIGINT — Foreign key → album.album_id — NOT NULL
- genre_id (장르ID) — BIGINT — Foreign key → genre.genre_id — NOT NULL
- title (곡명) — VARCHAR(100) — NOT NULL
- duration (플레이타임) — INT
- file_url — VARCHAR(255)
- lyrics (가사) — TEXT
track_metadata (곡 집계데이터)
- track_id (곡ID) — BIGINT — Foreign key → playlist_track.track_id — NOT NULL
- play_count (재생횟수) — INT
- download_count (다운로드횟수) — INT
- like_count (곡좋아요수) — INT
user
- user_id (사용자ID) — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255)
- password — VARCHAR(255)
- nickname — VARCHAR(50)
- phone — VARCHAR(20)
- role — ENUM('USER', 'DISTRIBUTOR', 'ADMIN') — NOT NULL
- status — ENUM('ACTIVE', 'DORMANT', 'WITHDRAW')
- created_at — DATETIME
- Field
user_follow
- follow_id (팔로우ID) — BIGINT — Primary key — NOT NULL
- user_id (사용자ID) — BIGINT — Foreign key → user.user_id — NOT NULL
- from_user_id — BIGINT — NOT NULL
- to_user_id — BIGINT — NOT NULL
user_oauth (유저 인증)
- user_auth_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (사용자ID) — BIGINT — Foreign key → user.user_id — NOT NULL
- provider — ENUM('GOOGLE', 'KAKAO', 'NAVER') — NOT NULL
- provider_user_id — VARCHAR(255) — NOT NULL
- created_at — DATETIME