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