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