OASIS BE V2
Tables (20)
ApiKey (Untitled8)
- ApiKeyId (Key) — Primary key — NOT NULL
- ExchangeId (Key2) — Foreign key → Exchange.ExchangeId — NOT NULL
- UserId (Key3) — int — Foreign key → USER.UserId — NOT NULL
- AccessKey (Field) — NOT NULL
- SecretKey (Field2) — NOT NULL
- PassPhase (Field3) — NOT NULL
Bot (Untitled3)
- BotId (Key) — Primary key — NOT NULL
- UserId (Key2) — int — Foreign key → USER.UserId — NOT NULL
- bot_management_id (Key6) — int — Foreign key → BotManagement.bot_management_id — NOT NULL
- ExchangeId (Key3) — Foreign key → Exchange.ExchangeId — NOT NULL
- IndicatorId (Key5) — Foreign key → Indicator.IndicatorId — NOT NULL
- CoinId (Key4) — Foreign key → Coin.CoinId — NOT NULL
- PresetId (Key32) — Foreign key → Preset.PresetId — NOT NULL
- BotUuid (Field) — NOT NULL
- BotName (Field2) — NOT NULL
- StartDate (Field3) — NOT NULL
- EndDate (Field6)
- IsRunning (Field4) — NOT NULL
- PresetData (Field5) — NOT NULL
- StartBalance (Field7) — NOT NULL
- ProfitCutRate (Field8) — NOT NULL
- LossCutRate (Field9) — NOT NULL
- PresetName (Field10) — NOT NULL
- Position (Field12) — NOT NULL
- Leverage (Field13) — NOT NULL
- StandardMinute (Field14)
BotManagement (Untitled16)
- bot_management_id (Key) — int — Primary key — NOT NULL
- bot_version_Id (Key2) — Foreign key → BotVersion.bot_version_Id — NOT NULL
- ip (Field)
- instance_id (Field2)
- is_deleted (Field3)
- created_at (Field4)
BotVersion (Untitled20)
- bot_version_Id (Key) — Primary key — NOT NULL
- major (Field)
- minor (Field2)
- patch (Field3)
- is_deleted (Field4)
- created_at (Field5)
Coin (Untitled6)
- CoinId (Key) — Primary key — NOT NULL
- CoinName (Field) — NOT NULL
- CoinSymbol (Field2)
CurrencyRate (Untitled15)
- currency_rate_id (Key) — int — Primary key — NOT NULL
- currency (Field) — varchar
- rate (Field2) — double
Exchange (Untitled5)
- ExchangeId (Key) — Primary key — NOT NULL
- ExchangeName (Field) — NOT NULL
ExchangeCoin (Untitled7)
- ExchangeCoinId (Key3) — Primary key — NOT NULL
- ExchangeId (Key) — Foreign key → Exchange.ExchangeId — NOT NULL
- CoinId (Key2) — Foreign key → Coin.CoinId — NOT NULL
ExchangeIndicator (Untitled11)
- ExchangeIndicatorId (Key) — Primary key — NOT NULL
- ExchangeId (Key2) — Foreign key → Exchange.ExchangeId — NOT NULL
- IndicatorId (Key3) — Foreign key → Indicator.IndicatorId — NOT NULL
Indicator (Untitled10)
- IndicatorId (Key) — Primary key — NOT NULL
- IndicatorName (Field) — NOT NULL
PAYMENT (Untitled9)
- PaymentId (Key) — Primary key — NOT NULL
- UserId (Key2) — int — Foreign key → USER.UserId — NOT NULL
- ProductId (Key5) — Foreign key → Product.ProductId — NOT NULL
- PaymentMethodId (Key3) — Foreign key → PaymentMethod.PaymentMethodId — NOT NULL
- PaidDate (Field) — Date — NOT NULL
- Price (Field2) — int — NOT NULL
PatchNote (Untitled18)
- PatchNoteId (Key) — Primary key — NOT NULL
- Title (Field)
- Content (Field2)
- PatchNoteCreateDate (Field3)
PaymentMethod (Untitled13)
- PaymentMethodId (Key) — int — Primary key — NOT NULL
- UserId (Key2) — int — Foreign key → USER.UserId — NOT NULL
- BillingToken (Field) — string — NOT NULL
- MaskedCardNumber (Field2) — string\ — NOT NULL
- CardCompany (Field3) — string — NOT NULL
Preset (Untitled2)
- PresetId (Key3) — Primary key — NOT NULL
- UserId (Key2) — int — Foreign key → USER.UserId — NOT NULL
- IndicatorId (Key) — Foreign key → Indicator.IndicatorId — NOT NULL
- PresetData (Field) — str — NOT NULL
- ProfitCutRate (Field2) — NOT NULL
- LossCutRate (Field3) — NOT NULL
- PresetName (Field4) — NOT NULL
- Position (Field5) — NOT NULL
Product (Untitled14)
- ProductId (Key) — Primary key — NOT NULL
- ProductName (Field) — NOT NULL
- ProductPrice (Field2) — NOT NULL
- PaidPeriod (Field3)
- isEnable (Field4)
Ranking (Untitled12)
- RankingId (Key) — Primary key — NOT NULL
- RankPeriod (Field) — NOT NULL
- Ranking (Field2) — NOT NULL
- UserName (Field3) — NOT NULL
- ExchangeName (Field4) — NOT NULL
- CoinName (Field5) — NOT NULL
- ProfitLossRate (Field6) — NOT NULL
- Duration (Field7) — NOT NULL
- PresetData (Field8) — NOT NULL
RefreshTokenInfo (Untitled19)
- RefreshTokenInfoId (Key) — Primary key — NOT NULL
- UserId (Key2) — int — Foreign key → USER.UserId — NOT NULL
- UserEmail (Field2)
- RefreshToken (Field3)
- RefreshTokenIssueDate (Field)
Subscribe (Untitled17)
- Key — Primary key — NOT NULL
- UserId (Key2) — int — Foreign key → USER.UserId — NOT NULL
- ProductId (Key3) — Foreign key → Product.ProductId — NOT NULL
- ExpireDate (Field)
- isCancelled (Field2)
- StartDate (Field3)
Transaction (Untitled4)
- TransactionId (Key) — Primary key — NOT NULL
- UserId (Key2) — int — Foreign key → USER.UserId — NOT NULL
- BotId (Key3) — Foreign key → Bot.BotId — NOT NULL
- ExchangeId (Key4) — Foreign key → Exchange.ExchangeId — NOT NULL
- CoinId (Key5) — Foreign key → Coin.CoinId — NOT NULL
- TransactionInfoCreateDate (Field) — NOT NULL
- TransactionDate (Field2)
- TransactionType (Field3) — NOT NULL
- TranscationPosition (Field4) — NOT NULL
- TransactionPrice (Field5) — NOT NULL
- TransactionVolume (Field6) — NOT NULL
- TransactionTotalPrice (Field7) — NOT NULL
- TransactionProfitLossRate (Field8) — NOT NULL
- TransactionProfitLoss (Field9)
USER (Untitled)
- UserId (Key) — int — Primary key — NOT NULL
- UserEmail (Field) — NOT NULL
- UserPassword (Field2) — NOT NULL
- UserCreateDate (Field3) — NOT NULL
- UserUpdateDate (Field4) — NOT NULL
- UserPhone (Field5)
- UserNickName (Field6) — NOT NULL
- UserType (Field7) — NOT NULL
- EssentialAgreement (Field8)
- AdAgreement (Field9)