Fandom-k-01

Tables (10)

artists

  • id — UUID
  • name — VARCHAR(100) — NOT NULL
  • agency — VARCHAR(100)
  • profile_image — TEXT
  • debut_date — DATE
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

credits

  • id — UUID
  • user_id — UUID
  • amount — DECIMAL(10,2) — NOT NULL
  • transaction_type — VARCHAR(10)
  • description — TEXT
  • created_at — TIMESTAMP

notifications

  • id — UUID
  • user_id — UUID
  • message — TEXT — NOT NULL
  • is_read — BOOLEAN
  • created_at — TIMESTAMP

payments

  • id — UUID
  • user_id — UUID
  • amount — DECIMAL(10,2) — NOT NULL
  • payment_method — VARCHAR(20)
  • status — VARCHAR(20)
  • transaction_id — VARCHAR(255)
  • created_at — TIMESTAMP

support_contributions

  • id — UUID
  • user_id — UUID
  • project_id — UUID
  • amount — DECIMAL(10,2) — NOT NULL
  • created_at — TIMESTAMP

support_projects

  • id — UUID
  • artist_id — UUID
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • goal_credit — DECIMAL(10,2) — NOT NULL
  • current_credit — DECIMAL(10,2)
  • start_date — TIMESTAMP — NOT NULL
  • end_date — TIMESTAMP — NOT NULL
  • status — VARCHAR(20)
  • created_at — TIMESTAMP

user_follow_artist

  • user_id — UUID
  • artist_id — UUID
  • created_at — TIMESTAMP

users

  • id — UUID
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • profile_image — TEXT
  • bio — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

vote_categories

  • id — UUID
  • name — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP

votes

  • id — UUID
  • user_id — UUID
  • artist_id — UUID
  • category_id — UUID
  • credit_spent — DECIMAL(10,2) — NOT NULL
  • created_at — TIMESTAMP