test2
Tables (6)
Artists
- artist_id — BIGINT — Primary key
- category_id — BIGINT — Foreign key → Categories.category_id
- name — VARCHAR(100)
- description — VARCHAR(255)
- image_url — VARCHAR(255)
- created_at — DATETIME
Categories
- category_id — BIGINT — Primary key
- name — VARCHAR(100)
- description — VARCHAR(255)
Credits
- credit_id — BIGINT — Primary key
- fan_id — BIGINT — Foreign key → Fans.fan_id
- balance — DECIMAL(15,2)
Fans
- fan_id — BIGINT — Primary key
- name — VARCHAR(100)
- email — VARCHAR(100)
- password — VARCHAR(255)
- created_at — DATETIME
Gifts
- fan_id — BIGINT — Foreign key → Fans.fan_id
- gift_id — BIGINT
- artist_id — BIGINT
- credit_id — BIGINT
- gift_type — VARCHAR(50)
- amount — DECIMAL(15,2)
- message — VARCHAR(255)
- created_at — DATETIME
- artist_id (artist_id2) — BIGINT — Foreign key → Artists.artist_id
- credit_id (credit_id2) — BIGINT — Foreign key → Credits.credit_id
Transactions
- fan_id (fan_id2) — BIGINT — Foreign key → Fans.fan_id
- transaction_id — BIGINT
- amount — DECIMAL(15,2)
- type — VARCHAR(20)
- created_at — DATETIME