The store is schema-free, so this describes what the sampled documents actually contain - not a contract. A field below 100% is simply absent from some documents.
| Path | Type | Present | Example | Index |
|---|---|---|---|---|
| id | string | 100% | "EMP-2011" | |
| name | string | 100% | "Zoe Ferreira" | |
| role | string | 100% | "Support engineer" | |
| office | string | 100% | "Austin" | |
| startDate | string | 100% | "2026-06-15" | |
| active | bool | 100% | true | |
| taxId🔒 encrypted | encrypted | string | 100% | "encrypted · key k2" | |
| homePostalCode🔒 encrypted | encrypted | 100% | "encrypted · key k2" |
These fields hold enc:1:<key>:<base64> envelopes written by MapProperty(…, p => p.Encrypt()). This tool never creates one and never overwrites one without asking. Counting reads every document of this type on paths that are not indexed, so it is a button rather than something this page does on load.
| Path | Mode | Keys in sample | Coverage |
|---|---|---|---|
| taxId | mode unknown(?) | k2, k1 | not counted |
| homePostalCode | deterministic (observed) | k2 | not counted |
Rewrapping is a library call — store.RewrapAsync<T>() — because it needs the type's mapping and the key ring in-process. What this card is for is telling you whether you still need to run it: retiring a key while documents are still under it makes those documents unreadable.
Every index on the table, not only the ones DocumentDb created — an index someone added by hand is often exactly what explains a query's speed. Only DocumentDb's own can be dropped from here.
| Index | Type | Path / definition | Size | Scans | |
|---|---|---|---|---|---|
| idx_documents_typename | external | CREATE INDEX idx_documents_typename ON "documents" (TypeName) | — | — | |
| sqlite_autoindex_documents_1 | external | — | — | — |
| Column | Meaning |
|---|---|
| Id | Primary key, unique per TypeName. Mirrored into the JSON body. |
| TypeName | The document type - Employee here. |
| Data | The JSON body. Queried with the provider's JSON functions. |
| CreatedAt | Set on insert. |
| UpdatedAt | Touched on every write. |