fandomk - 2025-06-12 07:03:36
Tables (8)
Artists
- Artists아이디 (id) — INT — Primary key — NOT NULL
- 아티스트이름 (artists_name) — VARCHAR(100)
- 아티스트아이디 (artist_id) — VARCHAR(20)
- 비밀번호 (password) — INT
- 그룹명 (group_name) — VARCHAR(50)
- 성별 (gender) — CHAR(1)
- 나이 (age) — INT
- Field
Credits
- Credits아이디 (id) — INT — Primary key — NOT NULL
- 사용패턴 (use_pattern) — CHAR(4)
- 총크레딧 (total_credit) — INT
- 크레딧 (credit) — INT
- 날짜 (date) — DATETIME
- Field
- User아이디 (id2) — INT — Foreign key — NOT NULL
Follow
- follow아이디 (id) — INT — Primary key — NOT NULL
- Field
- User아이디 (user_id) — INT — Foreign key — NOT NULL
- Artists아이디 (artist_id) — INT — Foreign key — NOT NULL
Sales
- Sales아이디 (id) — INT — Primary key — NOT NULL
- 날짜 (occurrence_date) — DATETIME
- 충전크레딧 (recharge_credit) — INT
- 크레딧_원화계산 (to_won_conv) — INT
- 수수료율 (commission_rate) — FLOAT
- 실매출 (actual_sales) — FLOAT
- Credits아이디 (id2) — INT — Foreign key — NOT NULL
Tribute
- Tribute아이디 (id) — INT — Primary key — NOT NULL
- 조공명 (tribute_name) — VARCHAR(30)
- 목표치 (target_credit) — INT
- Field
- User아이디 (user_id) — INT — Foreign key — NOT NULL
User
- User아이디 (id) — INT — Primary key — NOT NULL
- 사용자아이디 (user_id) — VARCHAR(20)
- 비밀번호 (password) — INT
- 사용자이름 (user_name) — VARCHAR(50)
- 나이 (age) — INT
- 성별 (gender) — CHAR(1)
- email — VARCHAR(30)
- 전화번호 (phone_num) — INT
- 주소 (addresss) — VARCHAR(100)
- Field
Vote
- 투표아이디 (id) — INT — Primary key — NOT NULL
- 투표날짜 (date) — DATETIME
- User아이디 (user_id) — INT — Foreign key — NOT NULL
- Artists아이디 (artist_id) — INT — Foreign key — NOT NULL
- 투표수 (vote_count) — INT
- 투표시간 (created_at) — DATETIME
and 1 more table