Query

branch.sqlite — local_stock_movements

SQL

CREATE TABLE "local_stock_movements"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_local_stock_movements" PRIMARY KEY,
  "LocalStockId" TEXT NOT NULL,
  "LocalWarehouseId" TEXT NOT NULL,
  "LocalProductId" TEXT NOT NULL,
  "UnitId" TEXT NOT NULL,
  "MovementType" TEXT NOT NULL,
  "Quantity" DECIMAL(18,4) NOT NULL,
  "PreBalance" DECIMAL(18,4) NOT NULL,
  "PostBalance" DECIMAL(18,4) NOT NULL,
  "UnitCostMinor" INTEGER NULL,
  "Reason" TEXT NULL,
  "SourceDocType" TEXT NULL,
  "SourceDocId" TEXT NULL,
  "SourceLineId" TEXT NULL,
  "UserId" TEXT NOT NULL,
  "OccurredAt" TEXT 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
LocalStockId TEXT Rename | Drop
LocalWarehouseId TEXT Rename | Drop
LocalProductId TEXT Rename | Drop
UnitId TEXT Rename | Drop
MovementType TEXT Rename | Drop
Quantity DECIMAL(18,4) Rename | Drop
PreBalance DECIMAL(18,4) Rename | Drop
PostBalance DECIMAL(18,4) Rename | Drop
UnitCostMinor INTEGER ✓ Rename | Drop
Reason TEXT ✓ Rename | Drop
SourceDocType TEXT ✓ Rename | Drop
SourceDocId TEXT ✓ Rename | Drop
SourceLineId TEXT ✓ Rename | Drop
UserId TEXT Rename | Drop
OccurredAt TEXT 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_movements_LocalProductId LocalProductId SQL 
CREATE INDEX "IX_local_stock_movements_LocalProductId"
ON "local_stock_movements" ("LocalProductId")
Drop
IX_local_stock_movements_LocalStockId LocalStockId SQL 
CREATE INDEX "IX_local_stock_movements_LocalStockId"
ON "local_stock_movements" ("LocalStockId")
Drop
IX_local_stock_movements_MovementType MovementType SQL 
CREATE INDEX "IX_local_stock_movements_MovementType"
ON "local_stock_movements" ("MovementType")
Drop
IX_local_stock_movements_OccurredAt OccurredAt SQL 
CREATE INDEX "IX_local_stock_movements_OccurredAt"
ON "local_stock_movements" ("OccurredAt")
Drop
IX_local_stock_movements_SourceDocType_SourceDocId
  • SourceDocType
  • SourceDocId
 SQL 
CREATE INDEX "IX_local_stock_movements_SourceDocType_SourceDocId"
ON "local_stock_movements" ("SourceDocType", "SourceDocId")
Drop
sqlite_autoindex_local_stock_movements_1 Id ✓ SQL
-- no sql found --
 Drop