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