Aiverse
Tables (10)
asset
- id — bigint — Primary key — NOT NULL
- creator_id — bigint — Foreign key → user.id — NOT NULL
- title — varchar — NOT NULL
- description — varchar
- asset_type — varchar — NOT NULL
- category — varchar — NOT NULL
- preview_url — varchar
- file_url — varchar — NOT NULL
- price_credit — int — NOT NULL
- ai_tool — varchar
- license_type — varchar — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime
asset_tag
- id — bigint — Primary key — NOT NULL
- asset_id — bigint — Foreign key → asset.id — NOT NULL
- tag_id — bigint — Foreign key → tag.id — NOT NULL
creator_settlement
- id — bigint — Primary key — NOT NULL
- creator_id — bigint — Foreign key → user.id — NOT NULL
- purchase_id — bigint — Foreign key → purchase.id — NOT NULL
- asset_id — bigint — Foreign key → asset.id — NOT NULL
- gross_credit — int — NOT NULL
- platform_fee_credit — int — NOT NULL
- settlement_credit — int — NOT NULL
- status — varchar — NOT NULL
- created_at — datetime — NOT NULL
- settled_at — datetime
credit_product
- id — bigint — Primary key — NOT NULL
- name — varchar
- credit_amount — int
- bonus_credit — int
- price — int
- status — varchar
- created_at — datetime
credit_transaction
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- payment_id — varchar — Foreign key → payment.id
- type — varchar — NOT NULL
- amount — int — NOT NULL
- balance_after — int — NOT NULL
- Field (reason) — varchar — NOT NULL
- created_at — datetime — NOT NULL
download
- id — bigint — Primary key — NOT NULL
- purchase_id — bigint — Foreign key → purchase.id — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- asset_id — bigint — Foreign key → asset.id — NOT NULL
- downloaded_at — datetime — NOT NULL
payment
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- credit_product_id — bigint — Foreign key → credit_product.id — NOT NULL
- amount — int — NOT NULL
- method — varchar — NOT NULL
- status — varchar — NOT NULL
- transaction_key — varchar
- paid_at — varchar
- failed_reason — varchar
- created_at — datetime — NOT NULL
purchase
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- id (asset_id) — bigint — Foreign key → asset.id — NOT NULL
- id (credit_transaction_id) — bigint — Foreign key → credit_transaction.id — NOT NULL
- purchase_price_credit — int — NOT NULL
- license_type — varchar — NOT NULL
- purchased_at — datetime — NOT NULL
tag
- id — bigint — Primary key — NOT NULL
- name — varchar — NOT NULL — unique
- created_at — datetime — NOT NULL
user
- id — bigint — Primary key — NOT NULL
- email — varchar — NOT NULL — unique
- password — varchar — NOT NULL
- nickname — varchar — NOT NULL
- role — varchar — NOT NULL
- Field (profile_url) — varchar
- Field (introduction) — text
- credit_balance — int — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime