SarahPark
Tables (8)
Artists
- artist_id — INT
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- category_id — INT
- created_at — TIMESTAMP
Categories
- category_id — INT
- name — VARCHAR(50) — NOT NULL
- description — VARCHAR(200)
Credits
- user_id — INT
- balance — DECIMAL(10, 2) — NOT NULL
- last_updated — TIMESTAMP
Donations
- donation_id — INT
- user_id — INT — NOT NULL
- tribute_id — INT — NOT NULL
- amount — DECIMAL(10, 2) — NOT NULL
- donated_at — TIMESTAMP
Follows
- follow_id — INT
- user_id — INT — NOT NULL
- artist_id — INT — NOT NULL
- followed_at — TIMESTAMP
Tributes
- tribute_id — INT
- artist_id — INT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- goal_amount — DECIMAL(10, 2) — NOT NULL
- current_amount — DECIMAL(10, 2)
- status — ENUM('active', 'achieved', 'expired')
- start_date — DATE
- end_date — DATE
- created_at — TIMESTAMP
Users
- user_id — INT
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Votes
- vote_id — INT
- user_id — INT — NOT NULL
- artist_id — INT — NOT NULL
- category_id — INT — NOT NULL
- voted_at — TIMESTAMP