Documents
660
Fields seen
17
JSON size
223 KB
Largest
375 B
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% | "c5268289-da08-447a-bc0d-a28bc8413935" | |
| sku | string | 100% | "SKU-CAB-2053" | |
| name | string | 100% | "Rugged Relay X8" | |
| category | string | 100% | "power" | |
| currency | string | 100% | "USD" | |
| dimensions | object | 100% | ||
| dimensions.widthMm | number | 100% | 195 | |
| dimensions.heightMm | number | 100% | 97 | |
| dimensions.depthMm | number | 100% | 129 | |
| dimensions.weightG | number | 100% | 1282 | |
| tags | array | 100% | ||
| discontinuedOn | null | string | 100% | "2024-12-19" | |
| price | number | 100% | 41.16 | |
| inStock | bool | 100% | true | |
| stockLevel | number | 100% | 438 | |
| rating | number | 100% | 3.87 | |
| reviewCount | number | 100% | 929 |
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 - Product here. |
| Data | The JSON body. Queried with the provider's JSON functions. |
| CreatedAt | Set on insert. |
| UpdatedAt | Touched on every write. |