Misstion 17
Tables (7)
Artist
- Artist ID (artist_id) — BIGINT — Primary key — NOT NULL
- Name (name) — VARCHAR(100)
- Category (category) — VARCHAR(50)
- Created At (created_at) — TIMESTAMP
Charge (charge)
- Charge ID (charge_id) — BIGINT — Primary key — NOT NULL
- User ID (user_id) — BIGINT — Foreign key → User.User ID — NOT NULL
- Amount (amount) — INT
- Created At (created_at) — TIMESTAMP
Credit
- Credit ID (credit_id) — BIGINT — Primary key — NOT NULL
- User ID (user_id) — BIGINT — Foreign key → User.User ID — NOT NULL
- Amount (amount) — INT
- Type (type) — ENUM
- Created At (created_at) — TIMESTAMP
Donation
- Donation ID (donation_id) — BIGINT — Primary key — NOT NULL
- Artist ID (artist_id) — BIGINT — Foreign key → Artist.Artist ID — NOT NULL
- User ID (user_id) — BIGINT — Foreign key → User.User ID — NOT NULL
- Amount (amount) — INT
- Created At (created_at) — TIMESTAMP
Follow
- User ID (user_id) — BIGINT — Primary key — NOT NULL
- Artist ID (artist_id) — BIGINT
- Created At (created_at) — TIMESTAMP
User
- User ID (user_id) — BIGINT — Primary key — NOT NULL
- Username (username) — VARCHAR(50)
- Email (email) — VARCHAR(100)
- Password (password) — VARCHAR(255)
- Created At (created_at) — TIMESTAMP
- Updated At (updated_at) — TIMESTAMP
Vote
- Vote ID (vote_id) — BIGINT — Primary key — NOT NULL
- Artist ID (artist_id) — BIGINT — Foreign key → Artist.Artist ID — NOT NULL
- User ID (user_id) — BIGINT — Foreign key → User.User ID — NOT NULL
- Category (category) — VARCHAR(50)
- Used Credit (used_credit) — INT
- Created At (created_at) — TIMESTAMP