12rows
14 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
DocumentNode | BLOB | no | PK | — |
DocumentLevel | INTEGER | yes | — | — |
Title | TEXT | no | — | — |
Owner | INTEGER | no | — | HumanResources.Employee.BusinessEntityID |
FolderFlag | INTEGER | no | — | — |
FileName | TEXT | no | — | — |
FileExtension | TEXT | no | — | — |
Revision | TEXT | no | — | — |
ChangeNumber | INTEGER | no | — | — |
Status | INTEGER | no | — | — |
DocumentSummary | TEXT | yes | — | — |
Document | BLOB | yes | — | — |
rowguid | TEXT | no | — | — |
ModifiedDate | TEXT | no | — | — |
Keys and unique indexes
Physical SQLite metadataPrimary key is declared above.
Additional unique keys
Production_Document_AK_Document_DocumentLevel_DocumentNodeDocumentLevel + DocumentNodeProduction_Document_AK_Document_rowguidrowguidProduction_Document_inline_unique_rowguidrowguid4 unique indexes inspected
Production_Document_AK_Document_DocumentLevel_DocumentNodeDocumentLevel + DocumentNodeCREATE UNIQUE INDEX "Production_Document_AK_Document_DocumentLevel_DocumentNode" ON "Production.Document" ("DocumentLevel", "DocumentNode")Production_Document_AK_Document_rowguidrowguidCREATE UNIQUE INDEX "Production_Document_AK_Document_rowguid" ON "Production.Document" ("rowguid")Production_Document_inline_unique_rowguidrowguidCREATE UNIQUE INDEX "Production_Document_inline_unique_rowguid" ON "Production.Document" ("rowguid")sqlite_autoindex_Production.Document_1DocumentNodeData preview
Sample records
| DocumentNode | DocumentLevel | Title | Owner | FolderFlag | FileName | FileExtension |
|---|---|---|---|---|---|---|
| AA== | 0 | Documents | 217 | 1 | Documents | |
| WA== | 1 | Overview | 217 | 1 | Overview | |
| WsA= | 2 | Introduction 1 | 219 | 0 | Introduction 1.doc | .doc |
| W0A= | 2 | Repair and Service Guidelines | 220 | 0 | Repair and Service Guidelines.doc | .doc |
| aA== | 1 | Maintenance | 217 | 1 | Maintenance | |
| asA= | 2 | Crank Arm and Tire Maintenance | 219 | 0 | Crank Arm and Tire Maintenance.doc | .doc |
| a0A= | 2 | Lubrication Maintenance | 219 | 0 | Lubrication Maintenance.doc | .doc |
| eA== | 1 | Assembly | 217 | 1 | Assembly |
Interactive explorer