---
title: "GET /contents/{id}/files"
method: GET
path: "/contents/{id}/files"
tags: ["Content"]
---

# GET /contents/{id}/files

`GET /contents/{id}/files`

## Request

- Base URL: `https://api.vp0.com` (the document declares no server; this is the origin it was published from)
- URL: `https://api.vp0.com/contents/{id}/files`
- Auth: HTTP bearer

## Path parameters

- `id` string, required

## Response `200`

- DesignFile[]
  - `id` number, required
  - `version_id` number, required
  - `target` string, required
  - `path` string, required
  - `file_name` string, required
  - `file_type` string, required
  - `content_url` string, nullable, required
  - `content_inline` string, nullable, required
  - `content_hash` string, nullable, required
  - `sort_order` number, required
  - `is_entrypoint` boolean, required
  - `created_at` string, date-time, required
  - `version` ContentVersion, required
    - `id` number, required
    - `content_id` string, required
    - `version_number` number, required
    - `code_url` string, required
    - `preview_url` string, required
    - `video_url` string, required
    - `changelog` string, required
    - `rebuild_score` number, nullable, required
    - `rebuild_diff_url` string, nullable, required
    - `rebuild_checked_at` string, date-time, nullable, required
    - `created_at` string, date-time, required
    - `content` Content, required
      - `id` string, required
      - `type` 'component' | 'demo' | 'template', required
      - `kind` string, nullable, required
      - `category_id` number, nullable, required
      - `user_id` string, required
      - `parent_id` string, required
      - `remixed_from_id` string, nullable, required
      - `name` string, required
      - `slug` string, required
      - `description` string, required
      - `latest_version_id` number, required
      - `likes_count` number, required
      - `downloads_count` number, required
      - `is_public` boolean, required
      - `is_featured` boolean, required
      - `source_token` string, nullable, required
      - `created_at` string, date-time, required
      - `updated_at` string, date-time, required
      - `deleted_at` string, date-time, required
      - `deleted_by` string, required
      - `user` User, required
        - `id` string, required
        - `email` string, required
        - `username` string, nullable, required
        - `name` string, nullable, required
        - `display_name` string, nullable, required
        - `password_hash` string, nullable, required
        - `image_url` string, nullable, required
        - `bio` string, nullable, required
        - `twitter_url` string, nullable, required
        - `github_url` string, nullable, required
        - `website_url` string, nullable, required
        - `google_id` string, nullable, required
        - `github_id` string, nullable, required
        - `created_at` string, date-time, required
        - `updated_at` string, date-time, required
        - `deleted_at` string, date-time, nullable, required
        - `deleted_by` string, nullable, required
        - `trust_status` string, nullable, required
        - `trust_note` string, nullable, required
        - `suspended_until` string, date-time, nullable, required
        - `warnings_count` number, required
        - `last_warned_at` string, date-time, nullable, required
        - `slug_history` UserSlugHistory[], required
          - `id` number, required
          - `user_id` string, required
          - `slug` string, required
          - `created_at` string, date-time, required
          - `user` User, required (recursive)
        - `user_roles` UserRole[], required
          - `id` number, required
          - `user_id` string, required
          - `role_id` number, required
          - `granted_by` string, required
          - `granted_at` string, date-time, required
          - `expires_at` string, date-time, required
          - `user` User, required (recursive)
          - `role` Role, required
            - `id` number, required
            - `name` string, required
            - `description` string, required
            - `created_at` string, date-time, required
            - `role_permissions` RolePermission[], required
              - …
            - `user_roles` UserRole[], required
        - `contents` Content[], required
        - `content_likes` ContentLike[], required
          - `id` number, required
          - `user_id` string, required
          - `content_id` string, required
          - `created_at` string, date-time, required
          - `user` User, required (recursive)
          - `content` Content, required (recursive)
        - `content_bookmarks` ContentBookmark[], required
          - `id` number, required
          - `user_id` string, required
          - `content_id` string, required
          - `created_at` string, date-time, required
          - `user` User, required (recursive)
          - `content` Content, required (recursive)
        - `collections` Collection[], required
          - `id` string, required
          - `user_id` string, required
          - `name` string, required
          - `slug` string, required
          - `description` string, required
          - `is_public` boolean, required
          - `created_at` string, date-time, required
          - `updated_at` string, date-time, required
          - `deleted_at` string, date-time, required
          - `user` User, required (recursive)
          - `items` CollectionItem[], required
            - `id` number, required
            - `collection_id` string, required
            - `content_id` string, required
            - `position` number, required
            - `note` string, nullable, required
            - `added_by` string, nullable, required
            - `added_at` string, date-time, required
            - `collection` Collection, required (recursive)
            - `content` Content, required (recursive)
        - `api_keys` ApiKey[], required
          - `id` number, required
          - `user_id` string, required
          - `key_hash` string, required
          - `key_prefix` string, required
          - `name` string, required
          - `is_active` boolean, required
          - `last_used_at` string, date-time, required
          - `created_at` string, date-time, required
          - `expires_at` string, date-time, required
          - `user` User, required (recursive)
        - `prompt_rule` UserPromptRule, required
          - `id` number, required
          - `user_id` string, required
          - `tech_stack` string[], required
          - `theme` string, required
          - `custom_context` string, required
          - `brand` object, required
            - `appName` string
            - `primaryColor` string
            - `accentColor` string
            - `font` string
          - `created_at` string, date-time, required
          - `updated_at` string, date-time, required
          - `user` User, required (recursive)
        - `ai_generation_requests` AiGenerationRequest[], required
          - `id` number, required
          - `user_id` string, required
          - `search_query` string, required
          - `prompt` string, required
          - `result_url` string, required
          - `model` string, required
          - `tokens_used` number, required
          - `created_at` string, date-time, required
          - `user` User, required (recursive)
          - `content_usages` AiGenerationContentUsage[], required
            - `id` number, required
            - `request_id` number, required
            - `version_id` number, required
            - `created_at` string, date-time, required
            - `request` AiGenerationRequest, required (recursive)
            - `version` ContentVersion, required (recursive)
        - `hunt_votes` HuntVote[], required
          - `id` number, required
          - `entry_id` number, required
          - `user_id` string, required
          - `created_at` string, date-time, required
          - `entry` HuntEntry, required
            - `id` number, required
            - `round_id` number, required
            - `version_id` number, required
            - `votes_count` number, required
            - `views_count` number, required
            - `installs_count` number, required
            - `final_score` number, required
            - `prize_tier` number, required
            - `created_at` string, date-time, required
            - `updated_at` string, date-time, required
            - `round` HuntRound, required
              - …
            - `version` ContentVersion, required (recursive)
            - `votes` HuntVote[], required
          - `user` User, required (recursive)
        - `feedbacks` Feedback[], required
          - `id` number, required
          - `user_id` string, required
          - `type` 'bug' | 'feature' | 'general', required
          - `title` string, required
          - `description` string, required
          - `status` 'pending' | 'approved' | 'rejected', required
          - `admin_response` string, required
          - `created_at` string, date-time, required
          - `updated_at` string, date-time, required
          - `user` User, required (recursive)
        - `deletion_requests` DeletionRequest[], required
          - `id` number, required
          - `user_id` string, required
          - `status` 'pending' | 'processing' | 'completed' | 'cancelled', required
          - `requested_at` string, date-time, required
          - `completed_at` string, date-time, required
          - `user` User, required (recursive)
          - `audit_logs` DeletionAuditLog[], required
            - `id` number, required
            - `request_id` number, required
            - `table_name` string, required
            - `record_count` number, required
            - `deleted_at` string, date-time, required
            - `request` DeletionRequest, required (recursive)
      - `parent` Content, required (recursive)
      - `remixed_from` Content, required (recursive)
      - `children` Content[], required
      - `slug_history` ContentSlugHistory[], required
        - `id` number, required
        - `content_id` string, required
        - `slug` string, required
        - `created_at` string, date-time, required
        - `content` Content, required (recursive)
      - `versions` ContentVersion[], required
      - `component_detail` ComponentDetail, required
        - `id` number, required
        - `content_id` string, required
        - `registry` 'ui' | 'hooks' | 'lib' | 'blocks', required
        - `license` string, required
        - `tailwind_config_extension` string, required
        - `global_css_extension` string, required
        - `content` Content, required (recursive)
      - `demo_detail` DemoDetail, required
        - `id` number, required
        - `content_id` string, required
        - `compiled_css_url` string, required
        - `bundle_url` string, required
        - `content` Content, required (recursive)
      - `template_detail` TemplateDetail, required
        - `id` number, required
        - `content_id` string, required
        - `github_url` string, nullable, required
        - `demo_url` string, required
        - `page_count` number, required
        - `created_at` string, date-time, required
        - `updated_at` string, date-time, required
        - `content` Content, required (recursive)
      - `content_tags` ContentTag[], required
        - `id` number, required
        - `content_id` string, required
        - `tag_id` number, required
        - `created_at` string, date-time, required
        - `content` Content, required (recursive)
        - `tag` Tag, required
          - `id` number, required
          - `name` string, required
          - `slug` string, required
          - `tag_type` string, required
          - `sort_order` number, required
          - `is_active` boolean, required
          - `created_at` string, date-time, required
          - `content_tags` ContentTag[], required
      - `likes` ContentLike[], required
        - `id` number, required
        - `user_id` string, required
        - `content_id` string, required
        - `created_at` string, date-time, required
        - `user` User, required
          - `id` string, required
          - `email` string, required
          - `username` string, nullable, required
          - `name` string, nullable, required
          - `display_name` string, nullable, required
          - `password_hash` string, nullable, required
          - `image_url` string, nullable, required
          - `bio` string, nullable, required
          - `twitter_url` string, nullable, required
          - `github_url` string, nullable, required
          - `website_url` string, nullable, required
          - `google_id` string, nullable, required
          - `github_id` string, nullable, required
          - `created_at` string, date-time, required
          - `updated_at` string, date-time, required
          - `deleted_at` string, date-time, nullable, required
          - `deleted_by` string, nullable, required
          - `trust_status` string, nullable, required
          - `trust_note` string, nullable, required
          - `suspended_until` string, date-time, nullable, required
          - `warnings_count` number, required
          - `last_warned_at` string, date-time, nullable, required
          - `slug_history` UserSlugHistory[], required
            - `id` number, required
            - `user_id` string, required
            - `slug` string, required
            - `created_at` string, date-time, required
            - `user` User, required (recursive)
          - `user_roles` UserRole[], required
            - `id` number, required
            - `user_id` string, required
            - `role_id` number, required
            - `granted_by` string, required
            - `granted_at` string, date-time, required
            - `expires_at` string, date-time, required
            - `user` User, required (recursive)
            - `role` Role, required
              - …
          - `contents` Content[], required
          - `content_likes` ContentLike[], required
          - `content_bookmarks` ContentBookmark[], required
            - `id` number, required
            - `user_id` string, required
            - `content_id` string, required
            - `created_at` string, date-time, required
            - `user` User, required (recursive)
            - `content` Content, required (recursive)
          - `collections` Collection[], required
            - `id` string, required
            - `user_id` string, required
            - `name` string, required
            - `slug` string, required
            - `description` string, required
            - `is_public` boolean, required
            - `created_at` string, date-time, required
            - `updated_at` string, date-time, required
            - `deleted_at` string, date-time, required
            - `user` User, required (recursive)
            - `items` CollectionItem[], required
              - …
          - `api_keys` ApiKey[], required
            - `id` number, required
            - `user_id` string, required
            - `key_hash` string, required
            - `key_prefix` string, required
            - `name` string, required
            - `is_active` boolean, required
            - `last_used_at` string, date-time, required
            - `created_at` string, date-time, required
            - `expires_at` string, date-time, required
            - `user` User, required (recursive)
          - `prompt_rule` UserPromptRule, required
            - `id` number, required
            - `user_id` string, required
            - `tech_stack` string[], required
            - `theme` string, required
            - `custom_context` string, required
            - `brand` object, required
              - …
            - `created_at` string, date-time, required
            - `updated_at` string, date-time, required
            - `user` User, required (recursive)
          - `ai_generation_requests` AiGenerationRequest[], required
            - `id` number, required
            - `user_id` string, required
            - `search_query` string, required
            - `prompt` string, required
            - `result_url` string, required
            - `model` string, required
            - `tokens_used` number, required
            - `created_at` string, date-time, required
            - `user` User, required (recursive)
            - `content_usages` AiGenerationContentUsage[], required
              - …
          - `hunt_votes` HuntVote[], required
            - `id` number, required
            - `entry_id` number, required
            - `user_id` string, required
            - `created_at` string, date-time, required
            - `entry` HuntEntry, required
              - …
            - `user` User, required (recursive)
          - `feedbacks` Feedback[], required
            - `id` number, required
            - `user_id` string, required
            - `type` 'bug' | 'feature' | 'general', required
            - `title` string, required
            - `description` string, required
            - `status` 'pending' | 'approved' | 'rejected', required
            - `admin_response` string, required
            - `created_at` string, date-time, required
            - `updated_at` string, date-time, required
            - `user` User, required (recursive)
          - `deletion_requests` DeletionRequest[], required
            - `id` number, required
            - `user_id` string, required
            - `status` 'pending' | 'processing' | 'completed' | 'cancelled', required
            - `requested_at` string, date-time, required
            - `completed_at` string, date-time, required
            - `user` User, required (recursive)
            - `audit_logs` DeletionAuditLog[], required
              - …
        - `content` Content, required (recursive)
      - `bookmarks` ContentBookmark[], required
        - `id` number, required
        - `user_id` string, required
        - `content_id` string, required
        - `created_at` string, date-time, required
        - `user` User, required
          - `id` string, required
          - `email` string, required
          - `username` string, nullable, required
          - `name` string, nullable, required
          - `display_name` string, nullable, required
          - `password_hash` string, nullable, required
          - `image_url` string, nullable, required
          - `bio` string, nullable, required
          - `twitter_url` string, nullable, required
          - `github_url` string, nullable, required
          - `website_url` string, nullable, required
          - `google_id` string, nullable, required
          - `github_id` string, nullable, required
          - `created_at` string, date-time, required
          - `updated_at` string, date-time, required
          - `deleted_at` string, date-time, nullable, required
          - `deleted_by` string, nullable, required
          - `trust_status` string, nullable, required
          - `trust_note` string, nullable, required
          - `suspended_until` string, date-time, nullable, required
          - `warnings_count` number, required
          - `last_warned_at` string, date-time, nullable, required
          - `slug_history` UserSlugHistory[], required
            - `id` number, required
            - `user_id` string, required
            - `slug` string, required
            - `created_at` string, date-time, required
            - `user` User, required (recursive)
          - `user_roles` UserRole[], required
            - `id` number, required
            - `user_id` string, required
            - `role_id` number, required
            - `granted_by` string, required
            - `granted_at` string, date-time, required
            - `expires_at` string, date-time, required
            - `user` User, required (recursive)
            - `role` Role, required
              - …
          - `contents` Content[], required
          - `content_likes` ContentLike[], required
            - `id` number, required
            - `user_id` string, required
            - `content_id` string, required
            - `created_at` string, date-time, required
            - `user` User, required (recursive)
            - `content` Content, required (recursive)
          - `content_bookmarks` ContentBookmark[], required
          - `collections` Collection[], required
            - `id` string, required
            - `user_id` string, required
            - `name` string, required
            - `slug` string, required
            - `description` string, required
            - `is_public` boolean, required
            - `created_at` string, date-time, required
            - `updated_at` string, date-time, required
            - `deleted_at` string, date-time, required
            - `user` User, required (recursive)
            - `items` CollectionItem[], required
              - …
          - `api_keys` ApiKey[], required
            - `id` number, required
            - `user_id` string, required
            - `key_hash` string, required
            - `key_prefix` string, required
            - `name` string, required
            - `is_active` boolean, required
            - `last_used_at` string, date-time, required
            - `created_at` string, date-time, required
            - `expires_at` string, date-time, required
            - `user` User, required (recursive)
          - `prompt_rule` UserPromptRule, required
            - `id` number, required
            - `user_id` string, required
            - `tech_stack` string[], required
            - `theme` string, required
            - `custom_context` string, required
            - `brand` object, required
              - …
            - `created_at` string, date-time, required
            - `updated_at` string, date-time, required
            - `user` User, required (recursive)
          - `ai_generation_requests` AiGenerationRequest[], required
            - `id` number, required
            - `user_id` string, required
            - `search_query` string, required
            - `prompt` string, required
            - `result_url` string, required
            - `model` string, required
            - `tokens_used` number, required
            - `created_at` string, date-time, required
            - `user` User, required (recursive)
            - `content_usages` AiGenerationContentUsage[], required
              - …
          - `hunt_votes` HuntVote[], required
            - `id` number, required
            - `entry_id` number, required
            - `user_id` string, required
            - `created_at` string, date-time, required
            - `entry` HuntEntry, required
              - …
            - `user` User, required (recursive)
          - `feedbacks` Feedback[], required
            - `id` number, required
            - `user_id` string, required
            - `type` 'bug' | 'feature' | 'general', required
            - `title` string, required
            - `description` string, required
            - `status` 'pending' | 'approved' | 'rejected', required
            - `admin_response` string, required
            - `created_at` string, date-time, required
            - `updated_at` string, date-time, required
            - `user` User, required (recursive)
          - `deletion_requests` DeletionRequest[], required
            - `id` number, required
            - `user_id` string, required
            - `status` 'pending' | 'processing' | 'completed' | 'cancelled', required
            - `requested_at` string, date-time, required
            - `completed_at` string, date-time, required
            - `user` User, required (recursive)
            - `audit_logs` DeletionAuditLog[], required
              - …
        - `content` Content, required (recursive)
      - `analytics` ContentAnalytics[], required
        - `id` number, required
        - `content_id` string, required
        - `version_id` number, required
        - `date` string, date-time, required
        - `view_count` number, required
        - `download_count` number, required
        - `copy_count` number, required
        - `dwell_seconds` number, required
        - `created_at` string, date-time, required
        - `content` Content, required (recursive)
        - `version` ContentVersion, required (recursive)
      - `collection_items` CollectionItem[], required
        - `id` number, required
        - `collection_id` string, required
        - `content_id` string, required
        - `position` number, required
        - `note` string, nullable, required
        - `added_by` string, nullable, required
        - `added_at` string, date-time, required
        - `collection` Collection, required
          - `id` string, required
          - `user_id` string, required
          - `name` string, required
          - `slug` string, required
          - `description` string, required
          - `is_public` boolean, required
          - `created_at` string, date-time, required
          - `updated_at` string, date-time, required
          - `deleted_at` string, date-time, required
          - `user` User, required
            - `id` string, required
            - `email` string, required
            - `username` string, nullable, required
            - `name` string, nullable, required
            - `display_name` string, nullable, required
            - `password_hash` string, nullable, required
            - `image_url` string, nullable, required
            - `bio` string, nullable, required
            - `twitter_url` string, nullable, required
            - `github_url` string, nullable, required
            - `website_url` string, nullable, required
            - `google_id` string, nullable, required
            - `github_id` string, nullable, required
            - `created_at` string, date-time, required
            - `updated_at` string, date-time, required
            - `deleted_at` string, date-time, nullable, required
            - `deleted_by` string, nullable, required
            - `trust_status` string, nullable, required
            - `trust_note` string, nullable, required
            - `suspended_until` string, date-time, nullable, required
            - `warnings_count` number, required
            - `last_warned_at` string, date-time, nullable, required
            - `slug_history` UserSlugHistory[], required
              - …
            - `user_roles` UserRole[], required
              - …
            - `contents` Content[], required
            - `content_likes` ContentLike[], required
              - …
            - `content_bookmarks` ContentBookmark[], required
              - …
            - `collections` Collection[], required
            - `api_keys` ApiKey[], required
              - …
            - `prompt_rule` UserPromptRule, required
              - …
            - `ai_generation_requests` AiGenerationRequest[], required
              - …
            - `hunt_votes` HuntVote[], required
              - …
            - `feedbacks` Feedback[], required
              - …
            - `deletion_requests` DeletionRequest[], required
              - …
          - `items` CollectionItem[], required
        - `content` Content, required (recursive)
    - `dependencies` VersionDependency[], required
      - `id` number, required
      - `version_id` number, required
      - `package_id` number, required
      - `version_spec` string, required
      - `is_dev` boolean, required
      - `created_at` string, date-time, required
      - `version` ContentVersion, required (recursive)
      - `package` Package, required
        - `id` number, required
        - `name` string, required
        - `registry` 'npm' | 'internal', required
        - `homepage_url` string, required
        - `is_blocked` boolean, required
        - `blocked_reason` string, required
        - `created_at` string, date-time, required
        - `version_dependencies` VersionDependency[], required
    - `internal_dependencies` InternalDependency[], required
      - `id` number, required
      - `version_id` number, required
      - `depends_on_content_id` string, required
      - `version_spec` string, required
      - `created_at` string, date-time, required
      - `version` ContentVersion, required (recursive)
      - `depends_on_content` Content, required
        - `id` string, required
        - `type` 'component' | 'demo' | 'template', required
        - `kind` string, nullable, required
        - `category_id` number, nullable, required
        - `user_id` string, required
        - `parent_id` string, required
        - `remixed_from_id` string, nullable, required
        - `name` string, required
        - `slug` string, required
        - `description` string, required
        - `latest_version_id` number, required
        - `likes_count` number, required
        - `downloads_count` number, required
        - `is_public` boolean, required
        - `is_featured` boolean, required
        - `source_token` string, nullable, required
        - `created_at` string, date-time, required
        - `updated_at` string, date-time, required
        - `deleted_at` string, date-time, required
        - `deleted_by` string, required
        - `user` User, required
          - `id` string, required
          - `email` string, required
          - `username` string, nullable, required
          - `name` string, nullable, required
          - `display_name` string, nullable, required
          - `password_hash` string, nullable, required
          - `image_url` string, nullable, required
          - `bio` string, nullable, required
          - `twitter_url` string, nullable, required
          - `github_url` string, nullable, required
          - `website_url` string, nullable, required
          - `google_id` string, nullable, required
          - `github_id` string, nullable, required
          - `created_at` string, date-time, required
          - `updated_at` string, date-time, required
          - `deleted_at` string, date-time, nullable, required
          - `deleted_by` string, nullable, required
          - `trust_status` string, nullable, required
          - `trust_note` string, nullable, required
          - `suspended_until` string, date-time, nullable, required
          - `warnings_count` number, required
          - `last_warned_at` string, date-time, nullable, required
          - `slug_history` UserSlugHistory[], required
            - `id` number, required
            - `user_id` string, required
            - `slug` string, required
            - `created_at` string, date-time, required
            - `user` User, required (recursive)
          - `user_roles` UserRole[], required
            - `id` number, required
            - `user_id` string, required
            - `role_id` number, required
            - `granted_by` string, required
            - `granted_at` string, date-time, required
            - `expires_at` string, date-time, required
            - `user` User, required (recursive)
            - `role` Role, required
              - …
          - `contents` Content[], required
          - `content_likes` ContentLike[], required
            - `id` number, required
            - `user_id` string, required
            - `content_id` string, required
            - `created_at` string, date-time, required
            - `user` User, required (recursive)
            - `content` Content, required (recursive)
          - `content_bookmarks` ContentBookmark[], required
            - `id` number, required
            - `user_id` string, required
            - `content_id` string, required
            - `created_at` string, date-time, required
            - `user` User, required (recursive)
            - `content` Content, required (recursive)
          - `collections` Collection[], required
            - `id` string, required
            - `user_id` string, required
            - `name` string, required
            - `slug` string, required
            - `description` string, required
            - `is_public` boolean, required
            - `created_at` string, date-time, required
            - `updated_at` string, date-time, required
            - `deleted_at` string, date-time, required
            - `user` User, required (recursive)
            - `items` CollectionItem[], required
              - …
          - `api_keys` ApiKey[], required
            - `id` number, required
            - `user_id` string, required
            - `key_hash` string, required
            - `key_prefix` string, required
            - `name` string, required
            - `is_active` boolean, required
            - `last_used_at` string, date-time, required
            - `created_at` string, date-time, required
            - `expires_at` string, date-time, required
            - `user` User, required (recursive)
          - `prompt_rule` UserPromptRule, required
            - `id` number, required
            - `user_id` string, required
            - `tech_stack` string[], required
            - `theme` string, required
            - `custom_context` string, required
            - `brand` object, required
              - …
            - `created_at` string, date-time, required
            - `updated_at` string, date-time, required
            - `user` User, required (recursive)
          - `ai_generation_requests` AiGenerationRequest[], required
            - `id` number, required
            - `user_id` string, required
            - `search_query` string, required
            - `prompt` string, required
            - `result_url` string, required
            - `model` string, required
            - `tokens_used` number, required
            - `created_at` string, date-time, required
            - `user` User, required (recursive)
            - `content_usages` AiGenerationContentUsage[], required
              - …
          - `hunt_votes` HuntVote[], required
            - `id` number, required
            - `entry_id` number, required
            - `user_id` string, required
            - `created_at` string, date-time, required
            - `entry` HuntEntry, required
              - …
            - `user` User, required (recursive)
          - `feedbacks` Feedback[], required
            - `id` number, required
            - `user_id` string, required
            - `type` 'bug' | 'feature' | 'general', required
            - `title` string, required
            - `description` string, required
            - `status` 'pending' | 'approved' | 'rejected', required
            - `admin_response` string, required
            - `created_at` string, date-time, required
            - `updated_at` string, date-time, required
            - `user` User, required (recursive)
          - `deletion_requests` DeletionRequest[], required
            - `id` number, required
            - `user_id` string, required
            - `status` 'pending' | 'processing' | 'completed' | 'cancelled', required
            - `requested_at` string, date-time, required
            - `completed_at` string, date-time, required
            - `user` User, required (recursive)
            - `audit_logs` DeletionAuditLog[], required
              - …
        - `parent` Content, required (recursive)
        - `remixed_from` Content, required (recursive)
        - `children` Content[], required
        - `slug_history` ContentSlugHistory[], required
          - `id` number, required
          - `content_id` string, required
          - `slug` string, required
          - `created_at` string, date-time, required
          - `content` Content, required (recursive)
        - `versions` ContentVersion[], required
        - `component_detail` ComponentDetail, required
          - `id` number, required
          - `content_id` string, required
          - `registry` 'ui' | 'hooks' | 'lib' | 'blocks', required
          - `license` string, required
          - `tailwind_config_extension` string, required
          - `global_css_extension` string, required
          - `content` Content, required (recursive)
        - `demo_detail` DemoDetail, required
          - `id` number, required
          - `content_id` string, required
          - `compiled_css_url` string, required
          - `bundle_url` string, required
          - `content` Content, required (recursive)
        - `template_detail` TemplateDetail, required
          - `id` number, required
          - `content_id` string, required
          - `github_url` string, nullable, required
          - `demo_url` string, required
          - `page_count` number, required
          - `created_at` string, date-time, required
          - `updated_at` string, date-time, required
          - `content` Content, required (recursive)
        - `content_tags` ContentTag[], required
          - `id` number, required
          - `content_id` string, required
          - `tag_id` number, required
          - `created_at` string, date-time, required
          - `content` Content, required (recursive)
          - `tag` Tag, required
            - `id` number, required
            - `name` string, required
            - `slug` string, required
            - `tag_type` string, required
            - `sort_order` number, required
            - `is_active` boolean, required
            - `created_at` string, date-time, required
            - `content_tags` ContentTag[], required
        - `likes` ContentLike[], required
          - `id` number, required
          - `user_id` string, required
          - `content_id` string, required
          - `created_at` string, date-time, required
          - `user` User, required
            - `id` string, required
            - `email` string, required
            - `username` string, nullable, required
            - `name` string, nullable, required
            - `display_name` string, nullable, required
            - `password_hash` string, nullable, required
            - `image_url` string, nullable, required
            - `bio` string, nullable, required
            - `twitter_url` string, nullable, required
            - `github_url` string, nullable, required
            - `website_url` string, nullable, required
            - `google_id` string, nullable, required
            - `github_id` string, nullable, required
            - `created_at` string, date-time, required
            - `updated_at` string, date-time, required
            - `deleted_at` string, date-time, nullable, required
            - `deleted_by` string, nullable, required
            - `trust_status` string, nullable, required
            - `trust_note` string, nullable, required
            - `suspended_until` string, date-time, nullable, required
            - `warnings_count` number, required
            - `last_warned_at` string, date-time, nullable, required
            - `slug_history` UserSlugHistory[], required
              - …
            - `user_roles` UserRole[], required
              - …
            - `contents` Content[], required
            - `content_likes` ContentLike[], required
            - `content_bookmarks` ContentBookmark[], required
              - …
            - `collections` Collection[], required
              - …
            - `api_keys` ApiKey[], required
              - …
            - `prompt_rule` UserPromptRule, required
              - …
            - `ai_generation_requests` AiGenerationRequest[], required
              - …
            - `hunt_votes` HuntVote[], required
              - …
            - `feedbacks` Feedback[], required
              - …
            - `deletion_requests` DeletionRequest[], required
              - …
          - `content` Content, required (recursive)
        - `bookmarks` ContentBookmark[], required
          - `id` number, required
          - `user_id` string, required
          - `content_id` string, required
          - `created_at` string, date-time, required
          - `user` User, required
            - `id` string, required
            - `email` string, required
            - `username` string, nullable, required
            - `name` string, nullable, required
            - `display_name` string, nullable, required
            - `password_hash` string, nullable, required
            - `image_url` string, nullable, required
            - `bio` string, nullable, required
            - `twitter_url` string, nullable, required
            - `github_url` string, nullable, required
            - `website_url` string, nullable, required
            - `google_id` string, nullable, required
            - `github_id` string, nullable, required
            - `created_at` string, date-time, required
            - `updated_at` string, date-time, required
            - `deleted_at` string, date-time, nullable, required
            - `deleted_by` string, nullable, required
            - `trust_status` string, nullable, required
            - `trust_note` string, nullable, required
            - `suspended_until` string, date-time, nullable, required
            - `warnings_count` number, required
            - `last_warned_at` string, date-time, nullable, required
            - `slug_history` UserSlugHistory[], required
              - …
            - `user_roles` UserRole[], required
              - …
            - `contents` Content[], required
            - `content_likes` ContentLike[], required
              - …
            - `content_bookmarks` ContentBookmark[], required
            - `collections` Collection[], required
              - …
            - `api_keys` ApiKey[], required
              - …
            - `prompt_rule` UserPromptRule, required
              - …
            - `ai_generation_requests` AiGenerationRequest[], required
              - …
            - `hunt_votes` HuntVote[], required
              - …
            - `feedbacks` Feedback[], required
              - …
            - `deletion_requests` DeletionRequest[], required
              - …
          - `content` Content, required (recursive)
        - `analytics` ContentAnalytics[], required
          - `id` number, required
          - `content_id` string, required
          - `version_id` number, required
          - `date` string, date-time, required
          - `view_count` number, required
          - `download_count` number, required
          - `copy_count` number, required
          - `dwell_seconds` number, required
          - `created_at` string, date-time, required
          - `content` Content, required (recursive)
          - `version` ContentVersion, required (recursive)
        - `collection_items` CollectionItem[], required
          - `id` number, required
          - `collection_id` string, required
          - `content_id` string, required
          - `position` number, required
          - `note` string, nullable, required
          - `added_by` string, nullable, required
          - `added_at` string, date-time, required
          - `collection` Collection, required
            - `id` string, required
            - `user_id` string, required
            - `name` string, required
            - `slug` string, required
            - `description` string, required
            - `is_public` boolean, required
            - `created_at` string, date-time, required
            - `updated_at` string, date-time, required
            - `deleted_at` string, date-time, required
            - `user` User, required
              - …
            - `items` CollectionItem[], required
          - `content` Content, required (recursive)
    - `dependencies_cache` VersionDependenciesCache, required
      - `id` number, required
      - `version_id` number, required
      - `npm_dependencies` object, required
      - `npm_dev_dependencies` object, required
      - `internal_dependencies` string[], required
      - `updated_at` string, date-time, required
      - `version` ContentVersion, required (recursive)
    - `moderation_actions` ModerationAction[], required
      - `id` number, required
      - `version_id` number, required
      - `moderator_id` string, required
      - `action` 'submit' | 'approve' | 'reject' | 'flag' | 'unflag', required
      - `reason` string, required
      - `created_at` string, date-time, required
      - `version` ContentVersion, required (recursive)
      - `moderator` User, required
        - `id` string, required
        - `email` string, required
        - `username` string, nullable, required
        - `name` string, nullable, required
        - `display_name` string, nullable, required
        - `password_hash` string, nullable, required
        - `image_url` string, nullable, required
        - `bio` string, nullable, required
        - `twitter_url` string, nullable, required
        - `github_url` string, nullable, required
        - `website_url` string, nullable, required
        - `google_id` string, nullable, required
        - `github_id` string, nullable, required
        - `created_at` string, date-time, required
        - `updated_at` string, date-time, required
        - `deleted_at` string, date-time, nullable, required
        - `deleted_by` string, nullable, required
        - `trust_status` string, nullable, required
        - `trust_note` string, nullable, required
        - `suspended_until` string, date-time, nullable, required
        - `warnings_count` number, required
        - `last_warned_at` string, date-time, nullable, required
        - `slug_history` UserSlugHistory[], required
          - `id` number, required
          - `user_id` string, required
          - `slug` string, required
          - `created_at` string, date-time, required
          - `user` User, required (recursive)
        - `user_roles` UserRole[], required
          - `id` number, required
          - `user_id` string, required
          - `role_id` number, required
          - `granted_by` string, required
          - `granted_at` string, date-time, required
          - `expires_at` string, date-time, required
          - `user` User, required (recursive)
          - `role` Role, required
            - `id` number, required
            - `name` string, required
            - `description` string, required
            - `created_at` string, date-time, required
            - `role_permissions` RolePermission[], required
              - …
            - `user_roles` UserRole[], required
        - `contents` Content[], required
          - `id` string, required
          - `type` 'component' | 'demo' | 'template', required
          - `kind` string, nullable, required
          - `category_id` number, nullable, required
          - `user_id` string, required
          - `parent_id` string, required
          - `remixed_from_id` string, nullable, required
          - `name` string, required
          - `slug` string, required
          - `description` string, required
          - `latest_version_id` number, required
          - `likes_count` number, required
          - `downloads_count` number, required
          - `is_public` boolean, required
          - `is_featured` boolean, required
          - `source_token` string, nullable, required
          - `created_at` string, date-time, required
          - `updated_at` string, date-time, required
          - `deleted_at` string, date-time, required
          - `deleted_by` string, required
          - `user` User, required (recursive)
          - `parent` Content, required (recursive)
          - `remixed_from` Content, required (recursive)
          - `children` Content[], required
          - `slug_history` ContentSlugHistory[], required
            - `id` number, required
            - `content_id` string, required
            - `slug` string, required
            - `created_at` string, date-time, required
            - `content` Content, required (recursive)
          - `versions` ContentVersion[], required
          - `component_detail` ComponentDetail, required
            - `id` number, required
            - `content_id` string, required
            - `registry` 'ui' | 'hooks' | 'lib' | 'blocks', required
            - `license` string, required
            - `tailwind_config_extension` string, required
            - `global_css_extension` string, required
            - `content` Content, required (recursive)
          - `demo_detail` DemoDetail, required
            - `id` number, required
            - `content_id` string, required
            - `compiled_css_url` string, required
            - `bundle_url` string, required
            - `content` Content, required (recursive)
          - `template_detail` TemplateDetail, required
            - `id` number, required
            - `content_id` string, required
            - `github_url` string, nullable, required
            - `demo_url` string, required
            - `page_count` number, required
            - `created_at` string, date-time, required
            - `updated_at` string, date-time, required
            - `content` Content, required (recursive)
          - `content_tags` ContentTag[], required
            - `id` number, required
            - `content_id` string, required
            - `tag_id` number, required
            - `created_at` string, date-time, required
            - `content` Content, required (recursive)
            - `tag` Tag, required
              - …
          - `likes` ContentLike[], required
            - `id` number, required
            - `user_id` string, required
            - `content_id` string, required
            - `created_at` string, date-time, required
            - `user` User, required (recursive)
            - `content` Content, required (recursive)
          - `bookmarks` ContentBookmark[], required
            - `id` number, required
            - `user_id` string, required
            - `content_id` string, required
            - `created_at` string, date-time, required
            - `user` User, required (recursive)
            - `content` Content, required (recursive)
          - `analytics` ContentAnalytics[], required
            - `id` number, required
            - `content_id` string, required
            - `version_id` number, required
            - `date` string, date-time, required
            - `view_count` number, required
            - `download_count` number, required
            - `copy_count` number, required
            - `dwell_seconds` number, required
            - `created_at` string, date-time, required
            - `content` Content, required (recursive)
            - `version` ContentVersion, required (recursive)
          - `collection_items` CollectionItem[], required
            - `id` number, required
            - `collection_id` string, required
            - `content_id` string, required
            - `position` number, required
            - `note` string, nullable, required
            - `added_by` string, nullable, required
            - `added_at` string, date-time, required
            - `collection` Collection, required
              - …
            - `content` Content, required (recursive)
        - `content_likes` ContentLike[], required
          - `id` number, required
          - `user_id` string, required
          - `content_id` string, required
          - `created_at` string, date-time, required
          - `user` User, required (recursive)
          - `content` Content, required
            - `id` string, required
            - `type` 'component' | 'demo' | 'template', required
            - `kind` string, nullable, required
            - `category_id` number, nullable, required
            - `user_id` string, required
            - `parent_id` string, required
            - `remixed_from_id` string, nullable, required
            - `name` string, required
            - `slug` string, required
            - `description` string, required
            - `latest_version_id` number, required
            - `likes_count` number, required
            - `downloads_count` number, required
            - `is_public` boolean, required
            - `is_featured` boolean, required
            - `source_token` string, nullable, required
            - `created_at` string, date-time, required
            - `updated_at` string, date-time, required
            - `deleted_at` string, date-time, required
            - `deleted_by` string, required
            - `user` User, required (recursive)
            - `parent` Content, required (recursive)
            - `remixed_from` Content, required (recursive)
            - `children` Content[], required
            - `slug_history` ContentSlugHistory[], required
              - …
            - `versions` ContentVersion[], required
            - `component_detail` ComponentDetail, required
              - …
            - `demo_detail` DemoDetail, required
              - …
            - `template_detail` TemplateDetail, required
              - …
            - `content_tags` ContentTag[], required
              - …
            - `likes` ContentLike[], required
            - `bookmarks` ContentBookmark[], required
              - …
            - `analytics` ContentAnalytics[], required
              - …
            - `collection_items` CollectionItem[], required
              - …
        - `content_bookmarks` ContentBookmark[], required
          - `id` number, required
          - `user_id` string, required
          - `content_id` string, required
          - `created_at` string, date-time, required
          - `user` User, required (recursive)
          - `content` Content, required
            - `id` string, required
            - `type` 'component' | 'demo' | 'template', required
            - `kind` string, nullable, required
            - `category_id` number, nullable, required
            - `user_id` string, required
            - `parent_id` string, required
            - `remixed_from_id` string, nullable, required
            - `name` string, required
            - `slug` string, required
            - `description` string, required
            - `latest_version_id` number, required
            - `likes_count` number, required
            - `downloads_count` number, required
            - `is_public` boolean, required
            - `is_featured` boolean, required
            - `source_token` string, nullable, required
            - `created_at` string, date-time, required
            - `updated_at` string, date-time, required
            - `deleted_at` string, date-time, required
            - `deleted_by` string, required
            - `user` User, required (recursive)
            - `parent` Content, required (recursive)
            - `remixed_from` Content, required (recursive)
            - `children` Content[], required
            - `slug_history` ContentSlugHistory[], required
              - …
            - `versions` ContentVersion[], required
            - `component_detail` ComponentDetail, required
              - …
            - `demo_detail` DemoDetail, required
              - …
            - `template_detail` TemplateDetail, required
              - …
            - `content_tags` ContentTag[], required
              - …
            - `likes` ContentLike[], required
              - …
            - `bookmarks` ContentBookmark[], required
            - `analytics` ContentAnalytics[], required
              - …
            - `collection_items` CollectionItem[], required
              - …
        - `collections` Collection[], required
          - `id` string, required
          - `user_id` string, required
          - `name` string, required
          - `slug` string, required
          - `description` string, required
          - `is_public` boolean, required
          - `created_at` string, date-time, required
          - `updated_at` string, date-time, required
          - `deleted_at` string, date-time, required
          - `user` User, required (recursive)
          - `items` CollectionItem[], required
            - `id` number, required
            - `collection_id` string, required
            - `content_id` string, required
            - `position` number, required
            - `note` string, nullable, required
            - `added_by` string, nullable, required
            - `added_at` string, date-time, required
            - `collection` Collection, required (recursive)
            - `content` Content, required
              - …
        - `api_keys` ApiKey[], required
          - `id` number, required
          - `user_id` string, required
          - `key_hash` string, required
          - `key_prefix` string, required
          - `name` string, required
          - `is_active` boolean, required
          - `last_used_at` string, date-time, required
          - `created_at` string, date-time, required
          - `expires_at` string, date-time, required
          - `user` User, required (recursive)
        - `prompt_rule` UserPromptRule, required
          - `id` number, required
          - `user_id` string, required
          - `tech_stack` string[], required
          - `theme` string, required
          - `custom_context` string, required
          - `brand` object, required
            - `appName` string
            - `primaryColor` string
            - `accentColor` string
            - `font` string
          - `created_at` string, date-time, required
          - `updated_at` string, date-time, required
          - `user` User, required (recursive)
        - `ai_generation_requests` AiGenerationRequest[], required
          - `id` number, required
          - `user_id` string, required
          - `search_query` string, required
          - `prompt` string, required
          - `result_url` string, required
          - `model` string, required
          - `tokens_used` number, required
          - `created_at` string, date-time, required
          - `user` User, required (recursive)
          - `content_usages` AiGenerationContentUsage[], required
            - `id` number, required
            - `request_id` number, required
            - `version_id` number, required
            - `created_at` string, date-time, required
            - `request` AiGenerationRequest, required (recursive)
            - `version` ContentVersion, required (recursive)
        - `hunt_votes` HuntVote[], required
          - `id` number, required
          - `entry_id` number, required
          - `user_id` string, required
          - `created_at` string, date-time, required
          - `entry` HuntEntry, required
            - `id` number, required
            - `round_id` number, required
            - `version_id` number, required
            - `votes_count` number, required
            - `views_count` number, required
            - `installs_count` number, required
            - `final_score` number, required
            - `prize_tier` number, required
            - `created_at` string, date-time, required
            - `updated_at` string, date-time, required
            - `round` HuntRound, required
              - …
            - `version` ContentVersion, required (recursive)
            - `votes` HuntVote[], required
          - `user` User, required (recursive)
        - `feedbacks` Feedback[], required
          - `id` number, required
          - `user_id` string, required
          - `type` 'bug' | 'feature' | 'general', required
          - `title` string, required
          - `description` string, required
          - `status` 'pending' | 'approved' | 'rejected', required
          - `admin_response` string, required
          - `created_at` string, date-time, required
          - `updated_at` string, date-time, required
          - `user` User, required (recursive)
        - `deletion_requests` DeletionRequest[], required
          - `id` number, required
          - `user_id` string, required
          - `status` 'pending' | 'processing' | 'completed' | 'cancelled', required
          - `requested_at` string, date-time, required
          - `completed_at` string, date-time, required
          - `user` User, required (recursive)
          - `audit_logs` DeletionAuditLog[], required
            - `id` number, required
            - `request_id` number, required
            - `table_name` string, required
            - `record_count` number, required
            - `deleted_at` string, date-time, required
            - `request` DeletionRequest, required (recursive)
    - `moderation_status` VersionModerationStatus, required
      - `id` number, required
      - `version_id` number, required
      - `status` 'pending' | 'approved' | 'rejected' | 'flagged', required
      - `last_action_id` number, required
      - `updated_at` string, date-time, required
      - `version` ContentVersion, required (recursive)
      - `last_action` ModerationAction, required
        - `id` number, required
        - `version_id` number, required
        - `moderator_id` string, required
        - `action` 'submit' | 'approve' | 'reject' | 'flag' | 'unflag', required
        - `reason` string, required
        - `created_at` string, date-time, required
        - `version` ContentVersion, required (recursive)
        - `moderator` User, required
          - `id` string, required
          - `email` string, required
          - `username` string, nullable, required
          - `name` string, nullable, required
          - `display_name` string, nullable, required
          - `password_hash` string, nullable, required
          - `image_url` string, nullable, required
          - `bio` string, nullable, required
          - `twitter_url` string, nullable, required
          - `github_url` string, nullable, required
          - `website_url` string, nullable, required
          - `google_id` string, nullable, required
          - `github_id` string, nullable, required
          - `created_at` string, date-time, required
          - `updated_at` string, date-time, required
          - `deleted_at` string, date-time, nullable, required
          - `deleted_by` string, nullable, required
          - `trust_status` string, nullable, required
          - `trust_note` string, nullable, required
          - `suspended_until` string, date-time, nullable, required
          - `warnings_count` number, required
          - `last_warned_at` string, date-time, nullable, required
          - `slug_history` UserSlugHistory[], required
            - `id` number, required
            - `user_id` string, required
            - `slug` string, required
            - `created_at` string, date-time, required
            - `user` User, required (recursive)
          - `user_roles` UserRole[], required
            - `id` number, required
            - `user_id` string, required
            - `role_id` number, required
            - `granted_by` string, required
            - `granted_at` string, date-time, required
            - `expires_at` string, date-time, required
            - `user` User, required (recursive)
            - `role` Role, required
              - …
          - `contents` Content[], required
            - `id` string, required
            - `type` 'component' | 'demo' | 'template', required
            - `kind` string, nullable, required
            - `category_id` number, nullable, required
            - `user_id` string, required
            - `parent_id` string, required
            - `remixed_from_id` string, nullable, required
            - `name` string, required
            - `slug` string, required
            - `description` string, required
            - `latest_version_id` number, required
            - `likes_count` number, required
            - `downloads_count` number, required
            - `is_public` boolean, required
            - `is_featured` boolean, required
            - `source_token` string, nullable, required
            - `created_at` string, date-time, required
            - `updated_at` string, date-time, required
            - `deleted_at` string, date-time, required
            - `deleted_by` string, required
            - `user` User, required (recursive)
            - `parent` Content, required (recursive)
            - `remixed_from` Content, required (recursive)
            - `children` Content[], required
            - `slug_history` ContentSlugHistory[], required
              - …
            - `versions` ContentVersion[], required
            - `component_detail` ComponentDetail, required
              - …
            - `demo_detail` DemoDetail, required
              - …
            - `template_detail` TemplateDetail, required
              - …
            - `content_tags` ContentTag[], required
              - …
            - `likes` ContentLike[], required
              - …
            - `bookmarks` ContentBookmark[], required
              - …
            - `analytics` ContentAnalytics[], required
              - …
            - `collection_items` CollectionItem[], required
              - …
          - `content_likes` ContentLike[], required
            - `id` number, required
            - `user_id` string, required
            - `content_id` string, required
            - `created_at` string, date-time, required
            - `user` User, required (recursive)
            - `content` Content, required
              - …
          - `content_bookmarks` ContentBookmark[], required
            - `id` number, required
            - `user_id` string, required
            - `content_id` string, required
            - `created_at` string, date-time, required
            - `user` User, required (recursive)
            - `content` Content, required
              - …
          - `collections` Collection[], required
            - `id` string, required
            - `user_id` string, required
            - `name` string, required
            - `slug` string, required
            - `description` string, required
            - `is_public` boolean, required
            - `created_at` string, date-time, required
            - `updated_at` string, date-time, required
            - `deleted_at` string, date-time, required
            - `user` User, required (recursive)
            - `items` CollectionItem[], required
              - …
          - `api_keys` ApiKey[], required
            - `id` number, required
            - `user_id` string, required
            - `key_hash` string, required
            - `key_prefix` string, required
            - `name` string, required
            - `is_active` boolean, required
            - `last_used_at` string, date-time, required
            - `created_at` string, date-time, required
            - `expires_at` string, date-time, required
            - `user` User, required (recursive)
          - `prompt_rule` UserPromptRule, required
            - `id` number, required
            - `user_id` string, required
            - `tech_stack` string[], required
            - `theme` string, required
            - `custom_context` string, required
            - `brand` object, required
              - …
            - `created_at` string, date-time, required
            - `updated_at` string, date-time, required
            - `user` User, required (recursive)
          - `ai_generation_requests` AiGenerationRequest[], required
            - `id` number, required
            - `user_id` string, required
            - `search_query` string, required
            - `prompt` string, required
            - `result_url` string, required
            - `model` string, required
            - `tokens_used` number, required
            - `created_at` string, date-time, required
            - `user` User, required (recursive)
            - `content_usages` AiGenerationContentUsage[], required
              - …
          - `hunt_votes` HuntVote[], required
            - `id` number, required
            - `entry_id` number, required
            - `user_id` string, required
            - `created_at` string, date-time, required
            - `entry` HuntEntry, required
              - …
            - `user` User, required (recursive)
          - `feedbacks` Feedback[], required
            - `id` number, required
            - `user_id` string, required
            - `type` 'bug' | 'feature' | 'general', required
            - `title` string, required
            - `description` string, required
            - `status` 'pending' | 'approved' | 'rejected', required
            - `admin_response` string, required
            - `created_at` string, date-time, required
            - `updated_at` string, date-time, required
            - `user` User, required (recursive)
          - `deletion_requests` DeletionRequest[], required
            - `id` number, required
            - `user_id` string, required
            - `status` 'pending' | 'processing' | 'completed' | 'cancelled', required
            - `requested_at` string, date-time, required
            - `completed_at` string, date-time, required
            - `user` User, required (recursive)
            - `audit_logs` DeletionAuditLog[], required
              - …
    - `sandboxes` Sandbox[], required
      - `id` number, required
      - `version_id` number, required
      - `runtime_type` 'web' | 'react_native', required
      - `runtime_version` string, required
      - `build_hash` string, required
      - `dependencies_lock` object, required
      - `sandbox_url` string, required
      - `sandbox_provider` string, required
      - `status` string, required
      - `build_logs_url` string, required
      - `build_started_at` string, date-time, required
      - `build_completed_at` string, date-time, required
      - `build_duration_ms` number, required
      - `created_at` string, date-time, required
      - `version` ContentVersion, required (recursive)
      - `mobile_config` SandboxMobileConfig, required
        - `id` number, required
        - `sandbox_id` number, required
        - `platform` string, required
        - `min_os_version` string, required
        - `expo_sdk_version` string, required
        - `native_modules` string[], required
        - `required_permissions` string[], required
        - `simulator_device` string, required
        - `created_at` string, date-time, required
        - `sandbox` Sandbox, required (recursive)
    - `embeddings` VersionEmbedding[], required
      - `id` number, required
      - `version_id` number, required
      - `embedding_type` string, required
      - `model` string, required
      - `embedding` number[], required
      - `source_text` string, required
      - `is_active` boolean, required
      - `created_at` string, date-time, required
      - `version` ContentVersion, required (recursive)
    - `analytics` ContentAnalytics[], required
      - `id` number, required
      - `content_id` string, required
      - `version_id` number, required
      - `date` string, date-time, required
      - `view_count` number, required
      - `download_count` number, required
      - `copy_count` number, required
      - `dwell_seconds` number, required
      - `created_at` string, date-time, required
      - `content` Content, required
        - `id` string, required
        - `type` 'component' | 'demo' | 'template', required
        - `kind` string, nullable, required
        - `category_id` number, nullable, required
        - `user_id` string, required
        - `parent_id` string, required
        - `remixed_from_id` string, nullable, required
        - `name` string, required
        - `slug` string, required
        - `description` string, required
        - `latest_version_id` number, required
        - `likes_count` number, required
        - `downloads_count` number, required
        - `is_public` boolean, required
        - `is_featured` boolean, required
        - `source_token` string, nullable, required
        - `created_at` string, date-time, required
        - `updated_at` string, date-time, required
        - `deleted_at` string, date-time, required
        - `deleted_by` string, required
        - `user` User, required
          - `id` string, required
          - `email` string, required
          - `username` string, nullable, required
          - `name` string, nullable, required
          - `display_name` string, nullable, required
          - `password_hash` string, nullable, required
          - `image_url` string, nullable, required
          - `bio` string, nullable, required
          - `twitter_url` string, nullable, required
          - `github_url` string, nullable, required
          - `website_url` string, nullable, required
          - `google_id` string, nullable, required
          - `github_id` string, nullable, required
          - `created_at` string, date-time, required
          - `updated_at` string, date-time, required
          - `deleted_at` string, date-time, nullable, required
          - `deleted_by` string, nullable, required
          - `trust_status` string, nullable, required
          - `trust_note` string, nullable, required
          - `suspended_until` string, date-time, nullable, required
          - `warnings_count` number, required
          - `last_warned_at` string, date-time, nullable, required
          - `slug_history` UserSlugHistory[], required
            - `id` number, required
            - `user_id` string, required
            - `slug` string, required
            - `created_at` string, date-time, required
            - `user` User, required (recursive)
          - `user_roles` UserRole[], required
            - `id` number, required
            - `user_id` string, required
            - `role_id` number, required
            - `granted_by` string, required
            - `granted_at` string, date-time, required
            - `expires_at` string, date-time, required
            - `user` User, required (recursive)
            - `role` Role, required
              - …
          - `contents` Content[], required
          - `content_likes` ContentLike[], required
            - `id` number, required
            - `user_id` string, required
            - `content_id` string, required
            - `created_at` string, date-time, required
            - `user` User, required (recursive)
            - `content` Content, required (recursive)
          - `content_bookmarks` ContentBookmark[], required
            - `id` number, required
            - `user_id` string, required
            - `content_id` string, required
            - `created_at` string, date-time, required
            - `user` User, required (recursive)
            - `content` Content, required (recursive)
          - `collections` Collection[], required
            - `id` string, required
            - `user_id` string, required
            - `name` string, required
            - `slug` string, required
            - `description` string, required
            - `is_public` boolean, required
            - `created_at` string, date-time, required
            - `updated_at` string, date-time, required
            - `deleted_at` string, date-time, required
            - `user` User, required (recursive)
            - `items` CollectionItem[], required
              - …
          - `api_keys` ApiKey[], required
            - `id` number, required
            - `user_id` string, required
            - `key_hash` string, required
            - `key_prefix` string, required
            - `name` string, required
            - `is_active` boolean, required
            - `last_used_at` string, date-time, required
            - `created_at` string, date-time, required
            - `expires_at` string, date-time, required
            - `user` User, required (recursive)
          - `prompt_rule` UserPromptRule, required
            - `id` number, required
            - `user_id` string, required
            - `tech_stack` string[], required
            - `theme` string, required
            - `custom_context` string, required
            - `brand` object, required
              - …
            - `created_at` string, date-time, required
            - `updated_at` string, date-time, required
            - `user` User, required (recursive)
          - `ai_generation_requests` AiGenerationRequest[], required
            - `id` number, required
            - `user_id` string, required
            - `search_query` string, required
            - `prompt` string, required
            - `result_url` string, required
            - `model` string, required
            - `tokens_used` number, required
            - `created_at` string, date-time, required
            - `user` User, required (recursive)
            - `content_usages` AiGenerationContentUsage[], required
              - …
          - `hunt_votes` HuntVote[], required
            - `id` number, required
            - `entry_id` number, required
            - `user_id` string, required
            - `created_at` string, date-time, required
            - `entry` HuntEntry, required
              - …
            - `user` User, required (recursive)
          - `feedbacks` Feedback[], required
            - `id` number, required
            - `user_id` string, required
            - `type` 'bug' | 'feature' | 'general', required
            - `title` string, required
            - `description` string, required
            - `status` 'pending' | 'approved' | 'rejected', required
            - `admin_response` string, required
            - `created_at` string, date-time, required
            - `updated_at` string, date-time, required
            - `user` User, required (recursive)
          - `deletion_requests` DeletionRequest[], required
            - `id` number, required
            - `user_id` string, required
            - `status` 'pending' | 'processing' | 'completed' | 'cancelled', required
            - `requested_at` string, date-time, required
            - `completed_at` string, date-time, required
            - `user` User, required (recursive)
            - `audit_logs` DeletionAuditLog[], required
              - …
        - `parent` Content, required (recursive)
        - `remixed_from` Content, required (recursive)
        - `children` Content[], required
        - `slug_history` ContentSlugHistory[], required
          - `id` number, required
          - `content_id` string, required
          - `slug` string, required
          - `created_at` string, date-time, required
          - `content` Content, required (recursive)
        - `versions` ContentVersion[], required
        - `component_detail` ComponentDetail, required
          - `id` number, required
          - `content_id` string, required
          - `registry` 'ui' | 'hooks' | 'lib' | 'blocks', required
          - `license` string, required
          - `tailwind_config_extension` string, required
          - `global_css_extension` string, required
          - `content` Content, required (recursive)
        - `demo_detail` DemoDetail, required
          - `id` number, required
          - `content_id` string, required
          - `compiled_css_url` string, required
          - `bundle_url` string, required
          - `content` Content, required (recursive)
        - `template_detail` TemplateDetail, required
          - `id` number, required
          - `content_id` string, required
          - `github_url` string, nullable, required
          - `demo_url` string, required
          - `page_count` number, required
          - `created_at` string, date-time, required
          - `updated_at` string, date-time, required
          - `content` Content, required (recursive)
        - `content_tags` ContentTag[], required
          - `id` number, required
          - `content_id` string, required
          - `tag_id` number, required
          - `created_at` string, date-time, required
          - `content` Content, required (recursive)
          - `tag` Tag, required
            - `id` number, required
            - `name` string, required
            - `slug` string, required
            - `tag_type` string, required
            - `sort_order` number, required
            - `is_active` boolean, required
            - `created_at` string, date-time, required
            - `content_tags` ContentTag[], required
        - `likes` ContentLike[], required
          - `id` number, required
          - `user_id` string, required
          - `content_id` string, required
          - `created_at` string, date-time, required
          - `user` User, required
            - `id` string, required
            - `email` string, required
            - `username` string, nullable, required
            - `name` string, nullable, required
            - `display_name` string, nullable, required
            - `password_hash` string, nullable, required
            - `image_url` string, nullable, required
            - `bio` string, nullable, required
            - `twitter_url` string, nullable, required
            - `github_url` string, nullable, required
            - `website_url` string, nullable, required
            - `google_id` string, nullable, required
            - `github_id` string, nullable, required
            - `created_at` string, date-time, required
            - `updated_at` string, date-time, required
            - `deleted_at` string, date-time, nullable, required
            - `deleted_by` string, nullable, required
            - `trust_status` string, nullable, required
            - `trust_note` string, nullable, required
            - `suspended_until` string, date-time, nullable, required
            - `warnings_count` number, required
            - `last_warned_at` string, date-time, nullable, required
            - `slug_history` UserSlugHistory[], required
              - …
            - `user_roles` UserRole[], required
              - …
            - `contents` Content[], required
            - `content_likes` ContentLike[], required
            - `content_bookmarks` ContentBookmark[], required
              - …
            - `collections` Collection[], required
              - …
            - `api_keys` ApiKey[], required
              - …
            - `prompt_rule` UserPromptRule, required
              - …
            - `ai_generation_requests` AiGenerationRequest[], required
              - …
            - `hunt_votes` HuntVote[], required
              - …
            - `feedbacks` Feedback[], required
              - …
            - `deletion_requests` DeletionRequest[], required
              - …
          - `content` Content, required (recursive)
        - `bookmarks` ContentBookmark[], required
          - `id` number, required
          - `user_id` string, required
          - `content_id` string, required
          - `created_at` string, date-time, required
          - `user` User, required
            - `id` string, required
            - `email` string, required
            - `username` string, nullable, required
            - `name` string, nullable, required
            - `display_name` string, nullable, required
            - `password_hash` string, nullable, required
            - `image_url` string, nullable, required
            - `bio` string, nullable, required
            - `twitter_url` string, nullable, required
            - `github_url` string, nullable, required
            - `website_url` string, nullable, required
            - `google_id` string, nullable, required
            - `github_id` string, nullable, required
            - `created_at` string, date-time, required
            - `updated_at` string, date-time, required
            - `deleted_at` string, date-time, nullable, required
            - `deleted_by` string, nullable, required
            - `trust_status` string, nullable, required
            - `trust_note` string, nullable, required
            - `suspended_until` string, date-time, nullable, required
            - `warnings_count` number, required
            - `last_warned_at` string, date-time, nullable, required
            - `slug_history` UserSlugHistory[], required
              - …
            - `user_roles` UserRole[], required
              - …
            - `contents` Content[], required
            - `content_likes` ContentLike[], required
              - …
            - `content_bookmarks` ContentBookmark[], required
            - `collections` Collection[], required
              - …
            - `api_keys` ApiKey[], required
              - …
            - `prompt_rule` UserPromptRule, required
              - …
            - `ai_generation_requests` AiGenerationRequest[], required
              - …
            - `hunt_votes` HuntVote[], required
              - …
            - `feedbacks` Feedback[], required
              - …
            - `deletion_requests` DeletionRequest[], required
              - …
          - `content` Content, required (recursive)
        - `analytics` ContentAnalytics[], required
        - `collection_items` CollectionItem[], required
          - `id` number, required
          - `collection_id` string, required
          - `content_id` string, required
          - `position` number, required
          - `note` string, nullable, required
          - `added_by` string, nullable, required
          - `added_at` string, date-time, required
          - `collection` Collection, required
            - `id` string, required
            - `user_id` string, required
            - `name` string, required
            - `slug` string, required
            - `description` string, required
            - `is_public` boolean, required
            - `created_at` string, date-time, required
            - `updated_at` string, date-time, required
            - `deleted_at` string, date-time, required
            - `user` User, required
              - …
            - `items` CollectionItem[], required
          - `content` Content, required (recursive)
      - `version` ContentVersion, required (recursive)
    - `hunt_entries` HuntEntry[], required
      - `id` number, required
      - `round_id` number, required
      - `version_id` number, required
      - `votes_count` number, required
      - `views_count` number, required
      - `installs_count` number, required
      - `final_score` number, required
      - `prize_tier` number, required
      - `created_at` string, date-time, required
      - `updated_at` string, date-time, required
      - `round` HuntRound, required
        - `id` number, required
        - `year` number, required
        - `week_number` number, required
        - `category` 'ui' | 'marketing' | 'seasonal' | 'global', required
        - `seasonal_tag` string, required
        - `start_date` string, date-time, required
        - `end_date` string, date-time, required
        - `is_active` boolean, required
        - `created_at` string, date-time, required
        - `entries` HuntEntry[], required
      - `version` ContentVersion, required (recursive)
      - `votes` HuntVote[], required
        - `id` number, required
        - `entry_id` number, required
        - `user_id` string, required
        - `created_at` string, date-time, required
        - `entry` HuntEntry, required (recursive)
        - `user` User, required
          - `id` string, required
          - `email` string, required
          - `username` string, nullable, required
          - `name` string, nullable, required
          - `display_name` string, nullable, required
          - `password_hash` string, nullable, required
          - `image_url` string, nullable, required
          - `bio` string, nullable, required
          - `twitter_url` string, nullable, required
          - `github_url` string, nullable, required
          - `website_url` string, nullable, required
          - `google_id` string, nullable, required
          - `github_id` string, nullable, required
          - `created_at` string, date-time, required
          - `updated_at` string, date-time, required
          - `deleted_at` string, date-time, nullable, required
          - `deleted_by` string, nullable, required
          - `trust_status` string, nullable, required
          - `trust_note` string, nullable, required
          - `suspended_until` string, date-time, nullable, required
          - `warnings_count` number, required
          - `last_warned_at` string, date-time, nullable, required
          - `slug_history` UserSlugHistory[], required
            - `id` number, required
            - `user_id` string, required
            - `slug` string, required
            - `created_at` string, date-time, required
            - `user` User, required (recursive)
          - `user_roles` UserRole[], required
            - `id` number, required
            - `user_id` string, required
            - `role_id` number, required
            - `granted_by` string, required
            - `granted_at` string, date-time, required
            - `expires_at` string, date-time, required
            - `user` User, required (recursive)
            - `role` Role, required
              - …
          - `contents` Content[], required
            - `id` string, required
            - `type` 'component' | 'demo' | 'template', required
            - `kind` string, nullable, required
            - `category_id` number, nullable, required
            - `user_id` string, required
            - `parent_id` string, required
            - `remixed_from_id` string, nullable, required
            - `name` string, required
            - `slug` string, required
            - `description` string, required
            - `latest_version_id` number, required
            - `likes_count` number, required
            - `downloads_count` number, required
            - `is_public` boolean, required
            - `is_featured` boolean, required
            - `source_token` string, nullable, required
            - `created_at` string, date-time, required
            - `updated_at` string, date-time, required
            - `deleted_at` string, date-time, required
            - `deleted_by` string, required
            - `user` User, required (recursive)
            - `parent` Content, required (recursive)
            - `remixed_from` Content, required (recursive)
            - `children` Content[], required
            - `slug_history` ContentSlugHistory[], required
              - …
            - `versions` ContentVersion[], required
            - `component_detail` ComponentDetail, required
              - …
            - `demo_detail` DemoDetail, required
              - …
            - `template_detail` TemplateDetail, required
              - …
            - `content_tags` ContentTag[], required
              - …
            - `likes` ContentLike[], required
              - …
            - `bookmarks` ContentBookmark[], required
              - …
            - `analytics` ContentAnalytics[], required
              - …
            - `collection_items` CollectionItem[], required
              - …
          - `content_likes` ContentLike[], required
            - `id` number, required
            - `user_id` string, required
            - `content_id` string, required
            - `created_at` string, date-time, required
            - `user` User, required (recursive)
            - `content` Content, required
              - …
          - `content_bookmarks` ContentBookmark[], required
            - `id` number, required
            - `user_id` string, required
            - `content_id` string, required
            - `created_at` string, date-time, required
            - `user` User, required (recursive)
            - `content` Content, required
              - …
          - `collections` Collection[], required
            - `id` string, required
            - `user_id` string, required
            - `name` string, required
            - `slug` string, required
            - `description` string, required
            - `is_public` boolean, required
            - `created_at` string, date-time, required
            - `updated_at` string, date-time, required
            - `deleted_at` string, date-time, required
            - `user` User, required (recursive)
            - `items` CollectionItem[], required
              - …
          - `api_keys` ApiKey[], required
            - `id` number, required
            - `user_id` string, required
            - `key_hash` string, required
            - `key_prefix` string, required
            - `name` string, required
            - `is_active` boolean, required
            - `last_used_at` string, date-time, required
            - `created_at` string, date-time, required
            - `expires_at` string, date-time, required
- … truncated; see the full OpenAPI document linked below

---

[API](https://skmtc.dev/vp0/apis/vp0-api.md) · [All operations](https://skmtc.dev/vp0/apis/vp0-api/llms.txt) · [OpenAPI document](https://skmtc.dev/vp0/apis/vp0-api/revisions/a41365f59c00?raw)
