Aiverse 최신

테이블 (12)

asset

  • id — bigint — 기본 키 — NOT NULL
  • creator_id — bigint — 외래 키 → user.id — NOT NULL
  • Key (category_id) — bigint — 외래 키 → category.id — NOT NULL
  • title — varchar — NOT NULL
  • description — varchar
  • asset_type — enum — NOT NULL
  • category — varchar — NOT NULL
  • preview_url (preview_object_key) — varchar
  • file_url (original_object_key) — varchar — NOT NULL
  • original_file_name — varchar
  • content_type — varchar
  • file_size — bigint
  • price_credit — int — NOT NULL
  • ai_tool — varchar
  • license_type — enum — NOT NULL
  • status — enum
  • view_count — bigint
  • created_at — datetime — NOT NULL
  • updated_at — datetime
  • deleted_at — datetime

asset_tag

  • id — bigint — 기본 키 — NOT NULL
  • asset_id — bigint — 외래 키 → asset.id — NOT NULL
  • tag_id — bigint — 외래 키 → tag.id — NOT NULL

category

  • id — bigint — 기본 키 — NOT NULL
  • name — varchar
  • slug — varchar
  • display_order — int
  • active — boolean
  • created_at — datetime
  • updated_at — datetime

creator_settlement

  • id — bigint — 기본 키 — NOT NULL
  • creator_id — bigint — 외래 키 → user.id — NOT NULL
  • purchase_id — bigint — 외래 키 → purchase.id — NOT NULL
  • asset_id — bigint — 외래 키 → asset.id — NOT NULL
  • gross_credit — int — NOT NULL
  • platform_fee_credit — int — NOT NULL
  • settlement_credit — int — NOT NULL
  • status — enum — NOT NULL
  • created_at — datetime — NOT NULL
  • settled_at — datetime

credit_product

  • id — bigint — 기본 키 — NOT NULL
  • code — varchar — unique
  • name — varchar
  • credit_amount — int
  • bonus_credit — int
  • price — int
  • display_order — int — unique
  • status — enum
  • created_at — datetime

credit_transaction

  • id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → user.id — NOT NULL
  • payment_id — bigint — 외래 키 → payment.id
  • type — enum — NOT NULL
  • amount — int — NOT NULL
  • balance_after — int — NOT NULL
  • reason — varchar — NOT NULL
  • created_at — datetime — NOT NULL

download

  • id — bigint — 기본 키 — NOT NULL
  • purchase_id — bigint — 외래 키 → purchase.id — NOT NULL
  • user_id — bigint — 외래 키 → user.id — NOT NULL
  • asset_id — bigint — 외래 키 → asset.id — NOT NULL
  • downloaded_at — datetime — NOT NULL

payment

  • id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → user.id — NOT NULL
  • credit_product_id — bigint — 외래 키 → credit_product.id — NOT NULL
  • idempotency_key — varchar
  • amount — int — NOT NULL
  • method — enum — NOT NULL
  • status — enum — NOT NULL
  • transaction_key — varchar
  • paid_at — varchar
  • failed_reason — varchar
  • created_at — datetime — NOT NULL

purchase

  • id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → user.id — NOT NULL
  • asset_id — bigint — 외래 키 → asset.id — NOT NULL
  • credit_transaction_id — bigint — 외래 키 → credit_transaction.id — NOT NULL
  • idempotency_key — varchar
  • purchase_price_credit — int — NOT NULL
  • license_type — enum — NOT NULL
  • purchased_at — datetime — NOT NULL

refresh_token

  • id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → user.id — NOT NULL
  • token_hash — varchar
  • expires_at — datetime
  • revoked_at — datetime
  • created_at — datetime

tag

  • id — bigint — 기본 키 — NOT NULL
  • name — varchar — NOT NULL — unique
  • created_at — datetime — NOT NULL

user

  • id — bigint — 기본 키 — NOT NULL
  • email — varchar — NOT NULL — unique
  • password — varchar — NOT NULL
  • nickname — varchar — NOT NULL — unique
  • role — enum — NOT NULL
  • status — enum
  • profile_url — varchar
  • introduction — text
  • credit_balance — int — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime