Fandom-k-01
Tables (10)
artists
- id — UUID
- name — VARCHAR(100) — NOT NULL
- agency — VARCHAR(100)
- profile_image — TEXT
- debut_date — DATE
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
credits
- id — UUID
- user_id — UUID
- amount — DECIMAL(10,2) — NOT NULL
- transaction_type — VARCHAR(10)
- description — TEXT
- created_at — TIMESTAMP
notifications
- id — UUID
- user_id — UUID
- message — TEXT — NOT NULL
- is_read — BOOLEAN
- created_at — TIMESTAMP
payments
- id — UUID
- user_id — UUID
- amount — DECIMAL(10,2) — NOT NULL
- payment_method — VARCHAR(20)
- status — VARCHAR(20)
- transaction_id — VARCHAR(255)
- created_at — TIMESTAMP
support_contributions
- id — UUID
- user_id — UUID
- project_id — UUID
- amount — DECIMAL(10,2) — NOT NULL
- created_at — TIMESTAMP
support_projects
- id — UUID
- artist_id — UUID
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- goal_credit — DECIMAL(10,2) — NOT NULL
- current_credit — DECIMAL(10,2)
- start_date — TIMESTAMP — NOT NULL
- end_date — TIMESTAMP — NOT NULL
- status — VARCHAR(20)
- created_at — TIMESTAMP
user_follow_artist
- user_id — UUID
- artist_id — UUID
- created_at — TIMESTAMP
users
- id — UUID
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- profile_image — TEXT
- bio — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
vote_categories
- id — UUID
- name — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP
votes
- id — UUID
- user_id — UUID
- artist_id — UUID
- category_id — UUID
- credit_spent — DECIMAL(10,2) — NOT NULL
- created_at — TIMESTAMP