Fandom-K
Tables (9)
Customer (customer)
- User ID (user_id) — INT — Primary key — NOT NULL
- Name (name) — VARCHAR(255)
- Nickname (nickname) — VARCHAR(100)
- Age (age) — INT
- Phone (phone) — CHAR(14)
- Registration Time (registration_time) — DATETIME
- Available Credits (available_credits) — INT
- Profile Picture (profile_picture) — VARCHAR(255)
Idol (idol)
- Idol ID (idol_id) — INT — Primary key
- Name (name) — VARCHAR(255)
- Group Name (group_name) — VARCHAR(255)
- Profile Picture (profile_picture) — VARCHAR(255)
Interest (interest)
- User ID (user_id2) — INT — Foreign key → Customer.User ID — NOT NULL
- Idol ID (idol_id2) — INT — Foreign key → Idol.Idol ID
- Timestamp (timestamp) — DATETIME
- Cancellation Status (cancellation_status) — BOOLEAN
MonthlyChart (monthly_chart)
- Idol ID (idol_id) — INT — Primary key
- Chart ID (chart_id) — INT — NOT NULL
- Vote Count (vote_count) — INT
- Rank (rank) — INT
Recharge Details (recharge_details)
- Timestamp (timestamp) — DATETIME — Primary key
- User ID (user_id) — INT — Foreign key → Customer.User ID — NOT NULL
- Recharge Amount (recharge_amount) — INT
Sponsorship (sponsorship)
- Event ID (event_id) — INT — Primary key — NOT NULL
- event_title — VARCHAR(255)
- Sponsorship Amount (sponsorship_amount) — INT
- Event Start Date (event_start_date) — DATETIME
- Event End Date (event_end_date) — DATETIME
- Idol ID (idol_id) — INT — Foreign key → Idol.Idol ID
Sponsorship Details (sponsorship_details)
- User ID (user_id) — INT — Foreign key → Customer.User ID — NOT NULL
- Event ID (event_id) — INT — Foreign key → Sponsorship.Event ID — NOT NULL
- Credited Amount (credited_amount) — INT
- Timestamp (timestamp) — DATETIME
V (y)
- Timestamp (timestamp) — DATETIME — Primary key
- Idol ID (idol_id) — INT — Foreign key → Idol.Idol ID
VotingHistory (voting_history)
- Timestamp (timestamp) — DATETIME — Primary key
- User ID (user_id) — INT — Foreign key → Customer.User ID — NOT NULL
- Idol ID (idol_id) — INT — Foreign key → MonthlyChart.Idol ID