mission 8
Tables (8)
artists
- artist_id — INT
- name — VARCHAR(100) — NOT NULL
- debut_date — DATE
- profile_image_url — VARCHAR(255)
- created_at — TIMESTAMP
credit_charges
- charge_id — INT
- user_id — INT — NOT NULL
- amount — DECIMAL(15, 2) — NOT NULL
- payment_method — VARCHAR(50)
- transaction_id — VARCHAR(255)
- charged_at — TIMESTAMP
follows
- follow_id — INT
- user_id — INT — NOT NULL
- artist_id — INT — NOT NULL
- followed_at — TIMESTAMP
projects
- project_id — INT
- creator_id — INT — NOT NULL
- artist_id — INT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- target_amount — DECIMAL(15, 2
supports
- support_id — INT
- user_id — INT — NOT NULL
- project_id — INT — NOT NULL
- amount — DECIMAL(15, 2) — NOT NULL
- supported_at — TIMESTAMP
users
- user_id — INT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(100) — NOT NULL
- credit_balance — DECIMAL(15, 2) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
vote_topics
- topic_id — INT
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- start_date — DATETIME — NOT NULL
- end_date — DATETIME — NOT NULL
- created_at — TIMESTAMP
votes
- vote_id — INT
- user_id — INT — NOT NULL
- artist_id — INT — NOT NULL
- topic_id — INT — NOT NULL
- credits_spent — INT — NOT NULL
- voted_at — TIMESTAMP