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