Fandom-K
Tables (6)
Artists
- artist_id — INT
- name — VARCHAR(100) — NOT NULL
- category — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP
Credits
- credit_id — INT
- user_id — INT — NOT NULL
- amount — DECIMAL(10, 2) — NOT NULL
- created_at — TIMESTAMP
Donations
- donation_id — INT
- user_id — INT — NOT NULL
- artist_id — INT — NOT NULL
- amount — DECIMAL(10, 2) — NOT NULL
- created_at — TIMESTAMP
Follows
- follow_id — INT
- user_id — INT — NOT NULL
- artist_id — INT — NOT NULL
- created_at — TIMESTAMP
Users
- user_id — INT
- username — VARCHAR(100) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
Votes
- vote_id — INT
- user_id — INT — NOT NULL
- artist_id — INT — NOT NULL
- category — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP