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