test2

Tables (6)

Artists

  • artist_id — BIGINT — Primary key
  • category_id — BIGINT — Foreign key → Categories.category_id
  • name — VARCHAR(100)
  • description — VARCHAR(255)
  • image_url — VARCHAR(255)
  • created_at — DATETIME

Categories

  • category_id — BIGINT — Primary key
  • name — VARCHAR(100)
  • description — VARCHAR(255)

Credits

  • credit_id — BIGINT — Primary key
  • fan_id — BIGINT — Foreign key → Fans.fan_id
  • balance — DECIMAL(15,2)

Fans

  • fan_id — BIGINT — Primary key
  • name — VARCHAR(100)
  • email — VARCHAR(100)
  • password — VARCHAR(255)
  • created_at — DATETIME

Gifts

  • fan_id — BIGINT — Foreign key → Fans.fan_id
  • gift_id — BIGINT
  • artist_id — BIGINT
  • credit_id — BIGINT
  • gift_type — VARCHAR(50)
  • amount — DECIMAL(15,2)
  • message — VARCHAR(255)
  • created_at — DATETIME
  • artist_id (artist_id2) — BIGINT — Foreign key → Artists.artist_id
  • credit_id (credit_id2) — BIGINT — Foreign key → Credits.credit_id

Transactions

  • fan_id (fan_id2) — BIGINT — Foreign key → Fans.fan_id
  • transaction_id — BIGINT
  • amount — DECIMAL(15,2)
  • type — VARCHAR(20)
  • created_at — DATETIME