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