Fandom-K

Tables (15)

ALBUM (Untitled11)

  • 앨범ID (album_id(PK)) — Primary key — NOT NULL
  • 제목 (title) — 255 — NOT NULL
  • 출시일 (release_date)
  • 생성일 (created_at) — NOT NULL
  • 아티스트ID (artist_id) — Foreign key → ARTIST.아티스트ID — NOT NULL

ARTIST (Untitled4)

  • 아티스트ID (artist_id(PK)) — Primary key — NOT NULL
  • 아티스트이름 (name) — NOT NULL
  • 성별 (gender) — NOT NULL
  • 프로필사진 (profile_image)
  • 대뷔일자 (debut_date)
  • 상태 (status) — NOT NULL
  • 생성일 (created_at) — NOT NULL — DEFAULT CURRENT_TIMESTAMP

BLOCK (Untitled6)

  • 블럭ID (block_id(PK)) — Primary key — NOT NULL
  • 생성일 (created_at) — NOT NULL
  • 회원ID (member_id) — Foreign key → MEMBER.회원ID — NOT NULL
  • 아티스트ID (artist_id) — Foreign key → ARTIST.아티스트ID — NOT NULL

CREDIT_TRANSACTION (Untitled3)

  • 거래ID (transaction_id(PK)) — Primary key — NOT NULL
  • 거래유형 (type) — NOT NULL
  • 거래금액 (amount) — NOT NULL
  • 생성일 (created_at) — NOT NULL
  • 연결대상 (related_id)
  • 회원ID (member_id) — Foreign key → MEMBER.회원ID — NOT NULL

CREDIT_WALLET (CopyOfUntitled2)

  • 지갑ID (wallet_id(PK)) — Primary key — NOT NULL
  • 현재잔액 (balance) — NOT NULL
  • 생성일 (created_at) — NOT NULL
  • 수정일 (updated_at) — NOT NULL
  • 회원ID (member_id) — Foreign key → MEMBER.회원ID — NOT NULL

DONATION (Untitled8)

  • 기부금ID (donation_id(PK)) — Primary key — NOT NULL
  • 금액 (amount) — NOT NULL
  • 생성일 (created_at) — NOT NULL
  • 회원ID (member_id) — Foreign key → MEMBER.회원ID — NOT NULL
  • 프로젝트ID (project_id) — Foreign key → DONATION_PROJECT.프로젝트ID — NOT NULL

DONATION_PROJECT (Untitled7)

  • 프로젝트ID (project_id(PK)) — Primary key — NOT NULL
  • 제목 (title) — 255 — NOT NULL
  • 목표금액 (target_amount) — NOT NULL
  • 현재금액 (current_amount) — NOT NULL
  • 마감기간 (deadline) — NOT NULL
  • 생성일 (created_at) — NOT NULL
  • 상태 (status) — NOT NULL
  • 아티스트ID (artist_id) — Foreign key → ARTIST.아티스트ID — NOT NULL

DOWNLOAD (Untitled14)

  • 다운로드ID (download_id(PK)) — Primary key — NOT NULL
  • 사용된크레딧 (used_credit) — NOT NULL
  • 생성일 (created_at) — NOT NULL
  • 회원ID (member_id) — Foreign key → MEMBER.회원ID — NOT NULL
  • 노래ID (song_id) — Foreign key → SONG.노래ID — NOT NULL

EMAIL_AUTH (Untitled2)

  • 인증ID (auth_id(PK)) — Primary key — NOT NULL
  • 이메일 (email) — 255 — NOT NULL
  • 인증코드 (auth_code) — NOT NULL
  • 인증유형 (auth_type) — NOT NULL
  • 증명여부 (is_verified) — NOT NULL
  • 만료시간 (expired_at) — NOT NULL
  • 가입일 (created_at) — NOT NULL
  • 회원ID (member_id) — Foreign key → MEMBER.회원ID — NOT NULL

FOLLOW (Untitled5)

  • 팔로우ID (follow_id(PK)) — Primary key — NOT NULL
  • 생성일 (created_at) — NOT NULL
  • 회원ID (member_id) — Foreign key → MEMBER.회원ID — NOT NULL
  • 아티스트ID (artist_id) — Foreign key → ARTIST.아티스트ID — NOT NULL

MEMBER (Untitled)

  • 회원ID (member_id(PK)) — Primary key — NOT NULL
  • 이메일 (email) — 255 — NOT NULL
  • 비밀번호 (password_hash) — 255 — NOT NULL
  • 성별 (gender) — NOT NULL — M: 남성 F: 여성
  • 생년월일 (birth_date) — NOT NULL
  • 닉네임 (nickname) — NOT NULL
  • 전화번호 (phone)
  • 프로필사진 (profile_image)
  • 가입일 (created_at) — NOT NULL
  • 수정일 (updated_at)
  • 상태 (status) — NOT NULL

MONTHLY_CHART (Untitled9)

  • 차트ID (chart_id(PK)) — Primary key — NOT NULL
  • 년도 (year) — NOT NULL
  • 월 (month) — NOT NULL
  • 성별 (gender) — NOT NULL
  • 생성일 (created_at) — NOT NULL

REVIEW (Untitled13)

  • 리뷰ID (review_id(PK)) — Primary key — NOT NULL
  • 별점 (rating) — NOT NULL
  • 내용 (content)
  • 생성일 (created_at) — NOT NULL
  • 회원ID (member_id) — Foreign key → MEMBER.회원ID — NOT NULL
  • 앨범ID (album_id) — Foreign key → ALBUM.앨범ID — NOT NULL

SONG (Untitled12)

  • 노래ID (song_id(PK)) — Primary key — NOT NULL
  • 제목 (title) — 255 — NOT NULL
  • 재생길이 (duration) — NOT NULL
  • 다운로드비용 (download_cost) — NOT NULL
  • 생성일 (created_at) — NOT NULL
  • 앨범ID (album_id) — Foreign key → ALBUM.앨범ID — NOT NULL

VOTE (Untitled10)

  • 투표ID (vote_id(PK)) — Primary key — NOT NULL
  • 투표수 (vote_count) — NOT NULL
  • 사용된크레딧 (used_credit) — NOT NULL
  • 생성일 (created_at) — NOT NULL
  • 회원ID (member_id) — Foreign key → MEMBER.회원ID — NOT NULL
  • 차트ID (chart_id) — Foreign key → MONTHLY_CHART.차트ID — NOT NULL
  • 아티스트ID (artist_id) — Foreign key → ARTIST.아티스트ID — NOT NULL