Fandom-K

Tables (7)

Artists

  • PK (artist_id) — INT AUTO_INCREMENT — Primary key — NOT NULL
  • Field (artist_name) — VARCHAR(20) NOT_NULL
  • Field (gender) — BOOLEAN
  • Field (group_name) — VARCHAR(20)
  • Field (birth_date) — DATETIME
  • Field (agency) — VARCHAR(20)

Donations

  • PK (donation_id) — INT AUTO_INCREMENT — Primary key — NOT NULL
  • FK (user_id) — INT — Foreign key → Users.PK — NOT NULL
  • FK (project_id) — INT — Foreign key → Projects.PK — NOT NULL
  • Field (credits_used) — INT NOT NULL
  • Field (donated_at) — TIMESTAMP
  • Field

Follows

  • FK (user_id) — INT — Foreign key → Users.PK — NOT NULL
  • FK (artist_id) — INT — Foreign key → Artists.PK — NOT NULL
  • Field (followed_at) — TIMESTAMP

Projects

  • PK (project_id) — INT AUTO_INCREMENT — Primary key — NOT NULL
  • FK (artist_id) — INT — Foreign key → Artists.PK — NOT NULL
  • Field (title) — VARCHAR(30)
  • Field (project_category) — VARCHAR(20)
  • Field (Field3) — INT NOT NULL
  • Field (collected_credits) — INT DEFAULT 0
  • Field (start_date) — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
  • Field (end_date) — TIMESTAMP NOT NULL

Users

  • PK (user_id) — INT AUTO_INCREMENT — Primary key — NOT NULL
  • Field (user_name) — VARCHAR(20)
  • Field (age) — INT
  • Field (gender) — BOOLEAN(MALE OR FEMALE)
  • Field (phone_number) — INT UNIQUE
  • Field (email) — VARCHAR(30) UNIQUE
  • Field (created_at) — TIMESTAMP

Vote_categories

  • PK (category_id) — INT AUTO_INCREMENT — Primary key — NOT NULL
  • Field (name) — VARCHAR(100)

Votes

  • PK (vote_id) — INT AUTO_INCREMENT — Primary key — NOT NULL
  • FK (user_id) — INT — Foreign key → Users.PK — NOT NULL
  • FK (category_id) — INT — Foreign key → Vote_categories.PK — NOT NULL
  • FK (artist_id) — INT — Foreign key → Artists.PK — NOT NULL
  • Field (credits_used) — INT NOT NULL
  • Field (voted_at) — TIMESTAMP