1

Tables (6)

Artist

  • ID — INT — Primary key — NOT NULL
  • Artist Name — VARCHAR(20)
  • Artist Group — VARCHAR(20)
  • Sponsor ID — INT — Foreign key → Sponsor.ID — NOT NULL
  • Vote ID — INT — Foreign key → Vote.ID — NOT NULL

Credit

  • ID — INT — Primary key — NOT NULL
  • Amount of credit — INT
  • Fan ID — INT — Foreign key → Fan.ID — NOT NULL

Fan

  • ID — INT — Primary key — NOT NULL
  • Fan Name — VARCHAR(20)
  • Following artist — VARCHAR(20)
  • Age — INT

Follow

  • ID — INT — Primary key — NOT NULL
  • Following Artist ID — INT
  • Fan ID — INT — Foreign key → Fan.ID — NOT NULL
  • Artist ID — INT — Foreign key → Artist.ID — NOT NULL

Sponsor

  • ID — INT — Primary key — NOT NULL
  • Amount of sponsor — INT
  • Fan ID — INT — Foreign key → Fan.ID — NOT NULL

Vote

  • ID — INT — Primary key — NOT NULL
  • Count of votes — INT
  • Fan ID — INT — Foreign key → Fan.ID — NOT NULL