Query

avatarai.db — OpenPositions

SQL

CREATE TABLE "OpenPositions"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_OpenPositions" PRIMARY KEY,
  "AvatarId" TEXT NOT NULL,
  "ClientId" TEXT NOT NULL,
  "ClosedAt" TEXT NULL,
  "CreatedAt" TEXT NOT NULL,
  "CurrentSlPrice" decimal(38,18) NOT NULL,
  "CurrentStopLimitPrice" decimal(38,18) NOT NULL,
  "CurrentTpPrice" decimal(38,18) NOT NULL,
  "EntryPrice" decimal(38,18) NOT NULL,
  "ExitPrice" decimal(38,18) NULL,
  "ExitReason" TEXT NULL,
  "HighestPrice" decimal(38,18) NOT NULL,
  "OcoOrderListId" TEXT NULL,
  "Quantity" decimal(38,18) NOT NULL,
  "RealizedPnl" decimal(38,18) NULL,
  "RealizedPnlPercent" decimal(10,4) NULL,
  "Status" TEXT NOT NULL,
  "Strategy" TEXT NULL,
  "Symbol" TEXT NOT NULL,
  "TrailingActivated" INTEGER NOT NULL,
  "UpdatedAt" TEXT NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Id TEXT ✓ Rename | Drop
AvatarId TEXT Rename | Drop
ClientId TEXT Rename | Drop
ClosedAt TEXT ✓ Rename | Drop
CreatedAt TEXT Rename | Drop
CurrentSlPrice decimal(38,18) Rename | Drop
CurrentStopLimitPrice decimal(38,18) Rename | Drop
CurrentTpPrice decimal(38,18) Rename | Drop
EntryPrice decimal(38,18) Rename | Drop
ExitPrice decimal(38,18) ✓ Rename | Drop
ExitReason TEXT ✓ Rename | Drop
HighestPrice decimal(38,18) Rename | Drop
OcoOrderListId TEXT ✓ Rename | Drop
Quantity decimal(38,18) Rename | Drop
RealizedPnl decimal(38,18) ✓ Rename | Drop
RealizedPnlPercent decimal(10,4) ✓ Rename | Drop
Status TEXT Rename | Drop
Strategy TEXT ✓ Rename | Drop
Symbol TEXT Rename | Drop
TrailingActivated INTEGER Rename | Drop
UpdatedAt TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_OpenPositions_1 Id ✓ SQL
-- no sql found --
 Drop