Fandom K
Tables (7)
Artist (artist)
- artist_id — INT — Primary key — NOT NULL
- name (Field) — VARCHAR(50)
- group (Field2) — VARCHAR(50)
CreditCharge (크레딧 충전 기록)
- history_id — INT — Primary key — NOT NULL
- user_id (id2) — INT — Foreign key → User.user_id — NOT NULL
- amount (변동된 크레딧 양) — INT
- created_at (기록된 날짜/시간) — DATETIME
Follow (아티스트를 팔로우한 기록)
- follow_id — INT — Primary key — NOT NULL
- user_id (id2) — INT — Foreign key → User.user_id — NOT NULL
- artist_id — INT — Foreign key → Artist.artist_id — NOT NULL
- followed_at (팔로우한 날짜/시간) — DATETIME
Project (조공 프로젝트 정보)
- project_id — INT — Primary key — NOT NULL
- artist_id — INT — Foreign key → Artist.artist_id — NOT NULL
- title (조공 프로젝트 제목) — VARCHAR(100)
- start_date (조공 시작일) — DATE
- end_date (조공 마감일) — DATE
- target_credit (목표 크레딧) — INT
- status (프로젝트 상태 (진행중, 완료, 실패 등)) — VARCHAR(20)
Support (프로젝트에 후원한 기록)
- support_id — INT — Primary key — NOT NULL
- user_id (id2) — INT — Foreign key → User.user_id — NOT NULL
- project_id — INT — Foreign key → Project.project_id — NOT NULL
- artist_id — INT — Foreign key → Project.artist_id — NOT NULL
- support_credit (후원한 크레딧 양) — INT
- supported_at (후원한 날짜/시간) — DATETIME
User (팬 사용자 정보)
- user_id (id) — INT — Primary key — NOT NULL
- name (Feild1) — VARCHAR(50)
- email (Field2) — VARCHAR(100)
- password (Field3) — VARCHAR(100)
- created_at (Field4) — DATETIME
Vote (아티스트에 투표한 기록)
- vote_id — INT — Primary key — NOT NULL
- user_id (id2) — INT — Foreign key → User.user_id — NOT NULL
- artist_id — INT — Foreign key → Artist.artist_id — NOT NULL
- vote_credit (투표에 사용한 크레딧 양) — INT
- voted_at (투표한 날짜/시간) — DATETIME