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