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)