Create
Query
avatarai.db
—
OpenPositions
__EFMigrationsHistory
AspNetRoleClaims
AspNetRoles
AspNetUserClaims
AspNetUserLogins
AspNetUserRoles
AspNetUsers
AspNetUserTokens
AvatarCapabilities
Avatars
AvatarTools
BetRecommendationLogs
CacheConversations
CalendarBookings
Capabilities
ChatMessages
ConversationSummaries
OpenPositions
OutboundMessages
ProviderPricing
ProviderUsage
sqlite_sequence
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Insert row into OpenPositions
Id
Primary key.
TEXT NOT NULL
AvatarId
TEXT NOT NULL
ClientId
TEXT NOT NULL
ClosedAt
TEXT
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)
ExitReason
TEXT
HighestPrice
decimal(38,18) NOT NULL
OcoOrderListId
TEXT
Quantity
decimal(38,18) NOT NULL
RealizedPnl
decimal(38,18)
RealizedPnlPercent
decimal(10,4)
Status
TEXT NOT NULL
Strategy
TEXT
Symbol
TEXT NOT NULL
TrailingActivated
INTEGER NOT NULL
UpdatedAt
TEXT NOT NULL
Insert
Cancel