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