Fandom-K
Tables (6)
artists
- artist_id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar
- category (Field2) — varchar
- created_at (Field3) — datetime
follows
- follow_id (Key) — int — Primary key — NOT NULL
- followed_at (Field3) — datetime
- user_id (Key2) — int — Foreign key → users.user_id — NOT NULL
- artist_id (Key3) — int — Foreign key → artists.artist_id — NOT NULL
supports
- support_id (Key) — int — Primary key — NOT NULL
- credit_amount (Field3) — int
- supported_at (Field4) — datetime
- user_id (Key2) — int — Foreign key → users.user_id — NOT NULL
- artist_id (Key3) — int — Foreign key → artists.artist_id — NOT NULL
transactions (Untitled)
- transaction_id (Key) — int — Primary key — NOT NULL
- type (Field2) — varchar
- amount (Field3) — int
- created_at (Field4) — datetime
- note (Field5) — varchar
- user_id (Key2) — int — Foreign key → users.user_id — NOT NULL
users
- user_id (Key) — int — Primary key — NOT NULL
- username (Field) — varchar
- email (Field2) — varchar
- credit_balance (Field3) — int
- created_at (Field4) — datetime
votes
- vote_id (Key) — int — Primary key — NOT NULL
- credit_used (Field3) — int
- voted_at (Field4) — datetime
- user_id (Key2) — int — Foreign key → users.user_id — NOT NULL
- artist_id (Key3) — int — Foreign key → artists.artist_id — NOT NULL