Query

branch.sqlite — local_product_price_e...

SQL

CREATE TABLE "local_product_price_entries"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_local_product_price_entries" PRIMARY KEY,
  "ProductId" TEXT NOT NULL,
  "ScopeType" TEXT NOT NULL,
  "BranchId" TEXT NULL,
  "ServiceAreaId" TEXT NULL,
  "ChannelCode" TEXT NULL,
  "ScopeKey" TEXT NOT NULL,
  "EffectiveDate" TEXT NOT NULL,
  "PriceMinor" INTEGER NOT NULL,
  "TaxIncluded" INTEGER NOT NULL,
  "Currency" TEXT NOT NULL DEFAULT 'TRY',
  "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
ProductId TEXT Rename | Drop
ScopeType TEXT Rename | Drop
BranchId TEXT ✓ Rename | Drop
ServiceAreaId TEXT ✓ Rename | Drop
ChannelCode TEXT ✓ Rename | Drop
ScopeKey TEXT Rename | Drop
EffectiveDate TEXT Rename | Drop
PriceMinor INTEGER Rename | Drop
TaxIncluded INTEGER Rename | Drop
Currency 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_product_price_entries_ProductId_EffectiveDate
  • ProductId
  • EffectiveDate
 SQL 
CREATE INDEX "IX_local_product_price_entries_ProductId_EffectiveDate"
ON "local_product_price_entries" ("ProductId", "EffectiveDate")
Drop
IX_local_product_price_entries_ProductId_ScopeKey_EffectiveDate
  • ProductId
  • ScopeKey
  • EffectiveDate
 ✓ SQL 
CREATE UNIQUE INDEX "IX_local_product_price_entries_ProductId_ScopeKey_EffectiveDate"
ON "local_product_price_entries" ("ProductId", "ScopeKey", "EffectiveDate")
Drop
sqlite_autoindex_local_product_price_entries_1 Id ✓ SQL
-- no sql found --
 Drop