calcategory
8 rows
This data as json, CSV (advanced)
Suggested facets: color, dateLastModified, lastChangedUserId, parentID, dateCreated (date), dateLastModified (date)
| id ▼ | color | dateCreated | dateLastModified | lastChangedUserId | name | parentID | readOnly |
|---|---|---|---|---|---|---|---|
| 1 | 3399ff | 2023-01-05 17:27:13.756000 | 2024-05-10 11:30:39.639000 | 9 | Order | _binary | |
| 10 | a82929 | 2023-01-05 17:27:13.756000 | 2024-05-10 11:31:15.775000 | 9 | PO | 1 | _binary |
| 20 | 21911d | 2023-01-05 17:27:13.756000 | 2024-05-10 11:33:43.693000 | 9 | SO | 1 | _binary |
| 30 | 3399ff | 2023-01-05 17:27:13.756000 | 2024-05-10 11:30:36.722000 | 9 | WO | 1 | _binary |
| 31 | 3399FF | 2023-01-05 17:27:13.756000 | 2023-01-05 17:27:13.756000 | 1 | Entered | 30 | _binary |
| 32 | 3399FF | 2023-01-05 17:27:13.756000 | 2023-01-05 17:27:13.756000 | 1 | Started | 30 | _binary |
| 33 | 3399FF | 2023-01-05 17:27:13.756000 | 2023-01-05 17:27:13.756000 | 1 | Fulfilled | 30 | _binary |
| 99 | ff9933 | 2023-01-05 17:27:13.756000 | 2024-05-10 11:36:05.858000 | 9 | Company | _binary |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "calcategory" (
"id" INTEGERNOT NULL ,
"color" TEXT DEFAULT NULL,
"dateCreated" TEXT DEFAULT NULL,
"dateLastModified" TEXT DEFAULT NULL,
"lastChangedUserId" INTEGERNOT NULL,
"name" TEXT DEFAULT NULL,
"parentID" INTEGERDEFAULT NULL,
"readOnly" INTEGER DEFAULT NULL,
PRIMARY KEY ("id")
);