parttracking
4 rows
This data as json, CSV (advanced)
Suggested facets: typeId
| id ▼ | abbr | activeFlag | description | name | sortOrder | typeId | gs1Code |
|---|---|---|---|---|---|---|---|
| 1 | Lot# | _binary | Lot Number | 1 | 10 | ||
| 2 | Rev# | _binary | Revision Level | 2 | 10 | ||
| 3 | ExpDate | _binary | Expiration Date | 3 | 30 | ||
| 4 | SN(s) | _binary | Serial Number | 4 | 40 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "parttracking" (
"id" INTEGERNOT NULL ,
"abbr" TEXT NOT NULL,
"activeFlag" INTEGER NOT NULL,
"description" TEXT DEFAULT NULL,
"name" TEXT NOT NULL,
"sortOrder" INTEGERNOT NULL,
"typeId" INTEGERNOT NULL,
"gs1Code" INTEGERDEFAULT NULL,
PRIMARY KEY ("id")
);