8888

Tables (11)

artist_members

  • artist_id — BIGINT — Primary key — NOT NULL
  • group_id — BIGINT — Primary key — NOT NULL
  • joined_at — DATE
  • left_at — DATE

artists

  • id — BIGINT
  • name — VARCHAR(120) — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • agency — VARCHAR(120)
  • gender — VARCHAR(10)
  • debut_date — DATE
  • photo_url — TEXT
  • created_at — TIMESTAMP — NOT NULL

chart_scores

  • chart_id — BIGINT — Primary key — NOT NULL
  • artist_id — BIGINT — Primary key — NOT NULL
  • vote_count — BIGINT — NOT NULL
  • credit_spent — BIGINT — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

charts

  • id — BIGSERIAL
  • period_month — CHAR(7) — NOT NULL
  • category — VARCHAR(10) — NOT NULL
  • status — VARCHAR(20)
  • created_at — TIMESTAMP — NOT NULL

credit_transactions

  • id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • amount — BIGINT — NOT NULL
  • balance_after — BIGINT — NOT NULL
  • ref_table — VARCHAR(50)
  • ref_id — BIGINT
  • provider — VARCHAR(50)
  • status — VARCHAR(20)
  • created_at — TIMESTAMP — NOT NULL

project_donations

  • id — BIGSERIAL
  • project_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • credits — BIGINT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

projects

  • id — BIGSERIAL
  • artist_id — BIGINT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • location — VARCHAR(200)
  • target_credits — BIGINT — NOT NULL
  • deadline_at — TIMESTAMP — NOT NULL
  • status — VARCHAR(20)
  • banner_url — TEXT
  • created_by — BIGINT
  • created_at — TIMESTAMP — NOT NULL

user_favorites

  • user_id — BIGINT — Primary key — NOT NULL
  • artist_id — BIGINT — Primary key — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

users

  • Key — Primary key — NOT NULL
  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • status — VARCHAR(20)
  • created_at — TIMESTAMP — NOT NULL

votes

  • id — BIGSERIAL
  • chart_id — BIGINT — NOT NULL
  • artist_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • votes_count — INT — NOT NULL
  • credit_spent — BIGINT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

wallets

  • user_id — BIGINT
  • balance_credits — BIGINT — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL