Fandom-K

Tables (7)

artist votes

  • Key (id) — INT — Primary key — NOT NULL
  • Key (user_id) — INT — Foreign key → users.Key — NOT NULL
  • Key (artist_id) — INT — Foreign key → artists.Key — NOT NULL
  • Field (category) — VARCHAR(20)
  • Field2 (vote_count) — INT
  • Field3 (voted_at) — DATETIME

artists

  • Key (id) — INT — Primary key — NOT NULL
  • Field (name) — VARCHAR(20)
  • Field2 (agency) — VARCHAR(20)
  • Field3 (debut_date) — DATE

credits

  • Key (id) — INT — Primary key — NOT NULL
  • Key (user_id) — INT — Foreign key → users.Key — NOT NULL
  • Field2 (amount) — INT
  • Field3 (status) — VARCHAR(20)
  • Field4 (created_at) — DATETIME

donate

  • Key (id) — INT — Primary key — NOT NULL
  • Key (user_id) — INT — Foreign key → users.Key — NOT NULL
  • Key (project_id) — INT — Foreign key → donate projects.Key — NOT NULL
  • Field (amount) — INT
  • Field2 (donate_at) — DATETIME

donate projects

  • Key (id) — INT — Primary key — NOT NULL
  • Key (artist_id) — INT — Foreign key → artists.Key — NOT NULL
  • Field (project_name) — VARCHAR(20)
  • Field2 (start_date) — DATETIME
  • Field3 (end_date) — DATETIME
  • Field4 (status) — VARCHAR(20)
  • Field5 (target_amount) — INT

follows

  • Key (id) — INT — Primary key — NOT NULL
  • Key (user_id) — INT — Foreign key → users.Key — NOT NULL
  • Key (artist_id) — INT — Foreign key → artists.Key — NOT NULL
  • Field (followed_at) — DATETIME

users

  • Key (id) — INT — Primary key — NOT NULL
  • Field1 (username) — VARCHAR(20)
  • Field2 (password) — VARCHAR(20)
  • Field3 (email) — VARCHAR(20)
  • Field4 (created_at) — DATETIME