7

Tables (9)

Artists

  • artist_id — BIGINT
  • name — VARCHAR(150) — NOT NULL
  • agency — VARCHAR(150)
  • debut_date — DATE
  • country_code — VARCHAR(2)
  • created_at — DATETIME — NOT NULL

Campaigns

  • campaign_id — BIGINT
  • artist_id — BIGINT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • goal_credits — INT — NOT NULL
  • start_at — DATETIME — NOT NULL
  • end_at — DATETIME — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL

CreditTransactions

  • tx_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • direction — VARCHAR(10) — NOT NULL
  • reason — VARCHAR(20) — NOT NULL
  • related_type — VARCHAR(20)
  • related_id — BIGINT
  • credits — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

Pledges

  • pledge_id — BIGINT
  • campaign_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • credits — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL

UserFollows

  • user_id — BIGINT — Primary key — NOT NULL
  • artist_id — BIGINT — Primary key — NOT NULL
  • followed_at — DATETIME — NOT NULL

Users

  • user_id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • display_name — VARCHAR(100) — NOT NULL
  • locale — VARCHAR(10)
  • created_at — DATETIME — NOT NULL

VoteCategories

  • category_id — BIGINT
  • category_name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(255)

VoteEvents

  • event_id — BIGINT
  • category_id — BIGINT — NOT NULL
  • event_title — VARCHAR(200) — NOT NULL
  • vote_credit_cost — INT — NOT NULL
  • start_at — DATETIME — NOT NULL
  • end_at — DATETIME — NOT NULL
  • status — VARCHAR(20) — NOT NULL

Votes

  • vote_id — BIGINT
  • event_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • artist_id — BIGINT — NOT NULL
  • vote_count — INT — NOT NULL
  • credits_spent — INT — NOT NULL
  • created_at — DATETIME — NOT NULL