Query

branch.sqlite — local_check_adjustments

SQL

CREATE TABLE "local_check_adjustments"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_local_check_adjustments" PRIMARY KEY,
  "CheckId" TEXT NOT NULL,
  "CheckLineId" TEXT NULL,
  "Kind" TEXT NOT NULL,
  "Scope" TEXT NOT NULL,
  "AmountMinor" INTEGER NOT NULL,
  "Type" TEXT NOT NULL,
  "PercentBp" INTEGER NULL,
  "ReasonCode" TEXT NOT NULL,
  "ReasonText" TEXT NULL,
  "Status" TEXT NOT NULL,
  "AppliedByUserId" TEXT NOT NULL,
  "ApprovedByUserId" TEXT NULL,
  "AppliedAt" TEXT NOT NULL,
  "VoidedAt" TEXT NULL,
  "VoidedByUserId" TEXT NULL,
  "VoidReason" 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
CheckId TEXT Rename | Drop
CheckLineId TEXT ✓ Rename | Drop
Kind TEXT Rename | Drop
Scope TEXT Rename | Drop
AmountMinor INTEGER Rename | Drop
Type TEXT Rename | Drop
PercentBp INTEGER ✓ Rename | Drop
ReasonCode TEXT Rename | Drop
ReasonText TEXT ✓ Rename | Drop
Status TEXT Rename | Drop
AppliedByUserId TEXT Rename | Drop
ApprovedByUserId TEXT ✓ Rename | Drop
AppliedAt TEXT Rename | Drop
VoidedAt TEXT ✓ Rename | Drop
VoidedByUserId TEXT ✓ Rename | Drop
VoidReason 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_check_adjustments_AppliedAt AppliedAt SQL 
CREATE INDEX "IX_local_check_adjustments_AppliedAt"
ON "local_check_adjustments" ("AppliedAt")
Drop
IX_local_check_adjustments_AppliedByUserId AppliedByUserId SQL 
CREATE INDEX "IX_local_check_adjustments_AppliedByUserId"
ON "local_check_adjustments" ("AppliedByUserId")
Drop
IX_local_check_adjustments_CheckId_Status
  • CheckId
  • Status
 SQL 
CREATE INDEX "IX_local_check_adjustments_CheckId_Status"
ON "local_check_adjustments" ("CheckId", "Status")
Drop
IX_local_check_adjustments_CheckLineId_Status
  • CheckLineId
  • Status
 SQL 
CREATE INDEX "IX_local_check_adjustments_CheckLineId_Status"
ON "local_check_adjustments" ("CheckLineId", "Status")
Drop
IX_local_check_adjustments_Kind Kind SQL 
CREATE INDEX "IX_local_check_adjustments_Kind"
ON "local_check_adjustments" ("Kind")
Drop
IX_local_check_adjustments_ReasonCode ReasonCode SQL 
CREATE INDEX "IX_local_check_adjustments_ReasonCode"
ON "local_check_adjustments" ("ReasonCode")
Drop
sqlite_autoindex_local_check_adjustments_1 Id ✓ SQL
-- no sql found --
 Drop