Query

branch.sqlite — local_stock

SQL

CREATE TABLE "local_stock"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_local_stock" PRIMARY KEY,
  "LocalWarehouseId" TEXT NOT NULL,
  "LocalProductId" TEXT NOT NULL,
  "UnitId" TEXT NOT NULL,
  "WarehouseLocationId" TEXT NULL,
  "OnHandQuantity" DECIMAL(18,4) NOT NULL,
  "ReservedQuantity" DECIMAL(18,4) NOT NULL,
  "MinLevel" DECIMAL(18,4) NOT NULL,
  "MaxLevel" DECIMAL(18,4) NOT NULL,
  "ReorderPoint" DECIMAL(18,4) NOT NULL,
  "AutoReorderEnabled" INTEGER NOT NULL,
  "LastMovementAt" TEXT NULL,
  "IsActive" INTEGER NOT NULL,
  "CreatedAt" TEXT NOT NULL,
  "UpdatedAt" TEXT NOT NULL,
  "IsDeleted" INTEGER NOT NULL,
  "DeletedAt" TEXT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Id TEXT ✓ Rename | Drop
LocalWarehouseId TEXT Rename | Drop
LocalProductId TEXT Rename | Drop
UnitId TEXT Rename | Drop
WarehouseLocationId TEXT ✓ Rename | Drop
OnHandQuantity DECIMAL(18,4) Rename | Drop
ReservedQuantity DECIMAL(18,4) Rename | Drop
MinLevel DECIMAL(18,4) Rename | Drop
MaxLevel DECIMAL(18,4) Rename | Drop
ReorderPoint DECIMAL(18,4) Rename | Drop
AutoReorderEnabled INTEGER Rename | Drop
LastMovementAt TEXT ✓ Rename | Drop
IsActive INTEGER Rename | Drop
CreatedAt TEXT Rename | Drop
UpdatedAt TEXT Rename | Drop
IsDeleted INTEGER Rename | Drop
DeletedAt TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IX_local_stock_LocalProductId LocalProductId SQL 
CREATE INDEX "IX_local_stock_LocalProductId"
ON "local_stock" ("LocalProductId")
Drop
IX_local_stock_LocalWarehouseId LocalWarehouseId SQL 
CREATE INDEX "IX_local_stock_LocalWarehouseId"
ON "local_stock" ("LocalWarehouseId")
Drop
IX_local_stock_LocalWarehouseId_LocalProductId_WarehouseLocationId
  • LocalWarehouseId
  • LocalProductId
  • WarehouseLocationId
 ✓ SQL 
CREATE UNIQUE INDEX "IX_local_stock_LocalWarehouseId_LocalProductId_WarehouseLocationId"
ON "local_stock" ("LocalWarehouseId", "LocalProductId", "WarehouseLocationId")
Drop
sqlite_autoindex_local_stock_1 Id ✓ SQL
-- no sql found --
 Drop