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