FandomK

Tables (11)

Artists (artists)

  • Artist ID (artist_id) — INT — Primary key — NOT NULL
  • Group ID (group_id) — INT — Foreign key → Groups.Group ID — NOT NULL
  • Artist Name (artist_name) — VARCHAR(100)
  • Artist Gender (artist_gender) — ENUM('male', 'female')

Credit Charge (credit_charge)

  • Charge ID (charge_id) — INT — Primary key — NOT NULL
  • User ID (user_id) — INT — Foreign key → Users.User ID — NOT NULL
  • Charged Amount (charged_amount) — DECIMAL(10,2)
  • Charged At (charged_at) — DATETIME

Credit Used (credit_used)

  • Credit Used ID (used_id) — INT — Primary key — NOT NULL
  • User ID (user_id) — INT — Foreign key → Users.User ID — NOT NULL
  • Used Amount (used_amount) — DECIMAL(10,2)
  • Used At (used_at) — DATETIME
  • Use Type (use_type) — ENUM('vote', 'donate')

Donation (donation)

  • ID (donate_id) — INT — Primary key — NOT NULL
  • User ID (user_id) — INT — Foreign key → Users.User ID — NOT NULL
  • Tribution ID (trib_id) — INT — Foreign key → Tribution.Tribution ID — NOT NULL
  • Donated Credit amount (donated_credit_amt) — DECIMAL(10,2)
  • Donated At (donated_at) — DATE

Follow (follow)

  • ID (follow_id) — INT — Primary key — NOT NULL
  • User ID (user_id) — INT — Foreign key → Users.User ID — NOT NULL
  • Artist ID (artist_id) — INT — Foreign key → Artists.Artist ID — NOT NULL
  • Follow_At (follow_at) — DATETIME

Groups (groups)

  • Group ID (group_id) — INT — Primary key — NOT NULL
  • Group name (group_name) — VARCHAR(100)
  • Group gender (group_gender) — ENUM('male', 'female' ,'mixed')

News (artist_news)

  • NEWS ID (news_id) — INT — Primary key — NOT NULL
  • Artist ID (artist_id) — INT — Foreign key → Artists.Artist ID — NOT NULL
  • Group ID (group_id) — INT — Foreign key → Groups.Group ID
  • Title (title) — VARCHAR(255)
  • Content (content) — TEXT

Tribution (tribution)

  • Tribution ID (trib_id) — INT — Primary key — NOT NULL
  • Artist ID (artist_id) — INT — Foreign key → Artists.Artist ID — NOT NULL
  • Content (content) — TEXT — Contents of tribution for artists
  • Target Amount (target_amt) — DECIMAL(10,2)
  • Current Amount (current_amt) — DECIMAL(10,2)
  • Tribution Start Date (tribute_start_date) — DATETIME
  • Tribution End Date (tribute_end_date) — DATETIME

Users (users)

  • User ID (user_id) — INT — Primary key — NOT NULL
  • User Name (user_name) — VARCHAR(100)

Vote for Artists (vote_artist)

  • ID (vote_id) — INT — Primary key — NOT NULL
  • User ID (user_id) — INT — Foreign key → Users.User ID — NOT NULL
  • Artist ID (artist_id) — INT — Foreign key → Artists.Artist ID — NOT NULL
  • Credit Used (credit_used) — DECIMAL(10,2)
  • Vote At (vote_at) — DATETIME
  • Vote Start Date (vote_start_date) — DATETIME
  • Vote End Date (vote_end_date) — DATETIME

Vote for Groups (vote_group)

  • ID (vote_id) — INT — Primary key — NOT NULL
  • User ID (user_id) — INT — Foreign key → Users.User ID — NOT NULL
  • Group ID (group_id) — INT — Foreign key → Groups.Group ID — NOT NULL
  • Credit Used (credit_used) — DECIMAL(10,2)
  • Vote At (vote_at) — DATETIME
  • Vote Start Date (vote_start_date) — DATETIME
  • Vote End Date (vote_end_date) — DATETIME