Query

branch.sqlite — local_inventory_documents

SQL

CREATE TABLE "local_inventory_documents"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_local_inventory_documents" PRIMARY KEY,
  "DocNo" TEXT NOT NULL,
  "DocType" TEXT NOT NULL,
  "SourceWarehouseId" TEXT NULL,
  "TargetWarehouseId" TEXT NOT NULL,
  "Status" TEXT NOT NULL,
  "DocDate" TEXT NOT NULL,
  "PostedAt" TEXT NULL,
  "CreatedByUserId" TEXT NOT NULL,
  "PostedByUserId" TEXT NULL,
  "Reference" TEXT NULL,
  "Notes" TEXT 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
DocNo TEXT Rename | Drop
DocType TEXT Rename | Drop
SourceWarehouseId TEXT ✓ Rename | Drop
TargetWarehouseId TEXT Rename | Drop
Status TEXT Rename | Drop
DocDate TEXT Rename | Drop
PostedAt TEXT ✓ Rename | Drop
CreatedByUserId TEXT Rename | Drop
PostedByUserId TEXT ✓ Rename | Drop
Reference TEXT ✓ Rename | Drop
Notes 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_inventory_documents_DocNo DocNo ✓ SQL 
CREATE UNIQUE INDEX "IX_local_inventory_documents_DocNo"
ON "local_inventory_documents" ("DocNo")
Drop
IX_local_inventory_documents_DocType_DocDate
  • DocType
  • DocDate
 SQL 
CREATE INDEX "IX_local_inventory_documents_DocType_DocDate"
ON "local_inventory_documents" ("DocType", "DocDate")
Drop
IX_local_inventory_documents_Status Status SQL 
CREATE INDEX "IX_local_inventory_documents_Status"
ON "local_inventory_documents" ("Status")
Drop
IX_local_inventory_documents_TargetWarehouseId TargetWarehouseId SQL 
CREATE INDEX "IX_local_inventory_documents_TargetWarehouseId"
ON "local_inventory_documents" ("TargetWarehouseId")
Drop
sqlite_autoindex_local_inventory_documents_1 Id ✓ SQL
-- no sql found --
 Drop