kititem

✎ View and edit SQL

This data as json

0 records

CREATE TABLE "kititem" (
 "id" INTEGERNOT NULL ,
 "dateCreated" TEXT DEFAULT NULL,
 "dateLastModified" TEXT DEFAULT NULL,
 "defaultQty" REAL NOT NULL,
 "description" TEXT DEFAULT NULL,
 "discountId" INTEGERDEFAULT NULL,
 "kitItemTypeId" INTEGERNOT NULL,
 "kitProductId" INTEGERNOT NULL,
 "kitTypeId" INTEGERNOT NULL,
 "maxQty" REAL NOT NULL,
 "minQty" REAL NOT NULL,
 "note" TEXT ,
 "productId" INTEGERDEFAULT NULL,
 "qtyPriceAdjustment" REAL DEFAULT NULL,
 "soItemTypeId" INTEGERDEFAULT NULL,
 "sortOrder" INTEGERDEFAULT NULL,
 "taxRateId" INTEGERDEFAULT NULL,
 "uomId" INTEGERDEFAULT NULL,
 PRIMARY KEY ("id")
);