## Context The database schema ADR ([!18456](https://gitlab.com/gitlab-com/content-sites/handbook/-/merge_requests/18456)) defines the core tables for the Artifact Registry. It has been reviewed and approved by the ~"group::database frameworks" team ([request](https://gitlab.com/gitlab-org/database-team/team-tasks/-/work_items/589)). ## Remaining Work _None — all tasks complete._ ## Completed | Task | MR | Status | | --- | --- | --- | | Hybrid list support ([discussion](https://gitlab.com/gitlab-com/content-sites/handbook/-/merge_requests/18456#note_3163997154)) | — | Completed :white_check_mark: | | Remove access rules tables ([context](https://gitlab.com/groups/gitlab-org/-/work_items/21373#note_3190386819)) | gitlab-com/content-sites/handbook!19170 | Completed :white_check_mark: | | Reuse format-specific tables for remote repo cached content instead of flat `*_remote_cache_entries` ([discussion](https://gitlab.com/gitlab-org/gitlab/-/work_items/568349#note_3182757468)) | gitlab-com/content-sites/handbook!19225 | Completed :white_check_mark: | | Workspaces support ([discussion](https://gitlab.com/gitlab-com/content-sites/handbook/-/merge_requests/18456#note_3167541559)) | gitlab-com/content-sites/handbook!19173 | Completed :white_check_mark: | | Changes required for gitlab-com/content-sites/handbook!18961 | gitlab-com/content-sites/handbook!19227 | Completed :white_check_mark: | | Evaluate UUIDv7 for `namespace_id` (PK, partition key, FKs) ([comment](https://gitlab.com/gitlab-org/gitlab/-/work_items/590365#note_3173904837)) | gitlab-com/content-sites/handbook!19500 | Completed :white_check_mark: | | NPM Metadata table linked to attachments | gitlab-com/content-sites/handbook!19279 | Completed :white_check_mark: | | Pre-computing of entity downloads (count and last timestamp) | gitlab-com/content-sites/handbook!19293 | Completed :white_check_mark: | | Pre-computing of entity size: add size to manifests table, the sum of linked manifests and blobs | gitlab-com/content-sites/handbook!19497 | Completed :white_check_mark: | | Evaluate need for separate schemas for parent vs partition tables. On the container registry the team was advised to use separate `public` and `partitions` schemas | gitlab-com/content-sites/handbook!19499 | Completed :white_check_mark: | | Verify wording around upload sessions `status` (that doesn't exist) ([discussion](https://gitlab.com/gitlab-com/content-sites/handbook/-/merge_requests/19227#note_3249724511)) | gitlab-com/content-sites/handbook!19498 | Completed :white_check_mark: | | Add etag and related columns for virtual repositories if missing (added to remote tables, which virtual repos route through) | gitlab-com/content-sites/handbook!19225 | Completed :white_check_mark: | | Namespace-level storage accounting "insurance policy" | gitlab-com/content-sites/handbook!19226 | Completed :white_check_mark: | | Add `last_updated_by_user_id` and `created_by_user_id` columns to `repositories` ([discussion](https://gitlab.com/gitlab-org/gitlab/-/work_items/590365#note_3327755177)) | gitlab-com/content-sites/handbook!19737 | Completed :white_check_mark: | | Add `components_count` to `namespace_statistics` table ([discussion](https://gitlab.com/gitlab-com/content-sites/handbook/-/merge_requests/19226#note_3239620532)) | gitlab-com/content-sites/handbook!19761 | Completed :white_check_mark: | | Add `sha512 bytea NOT NULL` to `maven_files` and `maven_remote_files` (per [S10 Data Model](https://gitlab.com/gitlab-org/ops/artifact-registry/-/merge_requests/120)) | gitlab-com/content-sites/handbook!19778 | Completed :white_check_mark: | | Document 2048-char plaintext cap on `encrypted_username` / `encrypted_password` / `encrypted_auth_token` columns in remote repository tables, enforced at the Go validation layer (no DB length constraint on the bytea ciphertext), matching the Rails virtual registry cap in [!235682](https://gitlab.com/gitlab-org/gitlab/-/merge_requests/235682) | gitlab-com/content-sites/handbook!19777 | Completed :white_check_mark: | | Add publisher attribution (`gitlab_user_id`, `gitlab_project_id`, `gitlab_git_commit_sha`) to artifact tables `container_manifests`, `maven_versions`, `npm_versions` (for #593965) | gitlab-com/content-sites/handbook!19763 | Completed :white_check_mark: | | Add visibility-audit partial index on `repositories(namespace_id, visibility) WHERE soft_deleted_at IS NULL` (for #593965) | gitlab-com/content-sites/handbook!19766 | Completed :white_check_mark: | | Add `versions_count` and `tags_count` columns to `npm_packages` (for #593965) ([discussion](https://gitlab.com/gitlab-org/ops/artifact-registry/-/merge_requests/98#note_3317011874)) | gitlab-com/content-sites/handbook!19762 | Completed :white_check_mark: | | Add `billing_entity_type` and `billing_entity_id` to `namespaces` table (per [ADR-022 update](https://gitlab.com/gitlab-com/content-sites/handbook/-/merge_requests/19789)) | gitlab-com/content-sites/handbook!19860 | Completed :white_check_mark: | | Add `kind=2` (abbreviated packument) and `expires_at` column to `npm_metadata_files` (per [S11 Data Model](https://gitlab.com/gitlab-org/ops/artifact-registry/-/merge_requests/98)) | gitlab-com/content-sites/handbook!19896 | Completed :white_check_mark: | | Add `created_at` column and per-namespace `(namespace_id, created_at DESC)` indexes to artifact tables for publication history and time-range provenance (for #593965) | gitlab-com/content-sites/handbook!19918 | Completed :white_check_mark: | | Add trash-listing inverse partial indexes (`WHERE soft_deleted_at IS NOT NULL`) on `repositories` and the artifact-granularity tables (for #593965) | gitlab-com/content-sites/handbook!19917 | Completed :white_check_mark: | | Add `(namespace_id, blob_sha256)` reverse-lookup indexes to artifact tables for checksum search and vulnerability impact (for #593965) | gitlab-com/content-sites/handbook!19919 | Completed :white_check_mark: | | Schema changes required for #593965 (umbrella; sub-items tagged `for #593965` across both tables) | — | Completed :white_check_mark: | | Namespace-level, repository-level, and artifact-level storage usage pre-computing and insurance policies (for #593965) | gitlab-com/content-sites/handbook!19842 | Completed :white_check_mark: | ## Related - Parent Epic: &20959 - ADR MR: [!18456](https://gitlab.com/gitlab-com/content-sites/handbook/-/merge_requests/18456) - Split Blueprint Issue: #590282