Lion Pay ERD

Tables (11)

Untitled (Coin)

  • Key (id) — String — Primary key — NOT NULL
  • Key (networkId) — String — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — String
  • Field (symbol) — String
  • Field (coinGeckoId) — String
  • Field (icon) — String
  • Field (decimal) — Integer
  • Field (website) — String
  • Field (explorerUrl) — Strng
  • Field (isActive) — Boolean
  • Field (isDeleted) — Boolean
  • Field (createdAt) — Date
  • Field (updatedAt) — Date
  • Field

Untitled (Network)

  • Key (id) — String — Primary key — NOT NULL
  • Field (name) — String
  • Field (symbol) — String
  • Field (icon) — String
  • Field (chainId) — Number
  • Field (rpcUrl) — String
  • Field (scanUrl) — String
  • Field (scanTrxUrl) — String
  • Field (isActive) — Boolean
  • Field (type) — enum(EVM, Bitcoin, Solana)
  • Field

Untitled (CoinPrice)

  • Key (id) — String — Primary key — NOT NULL
  • Key (coinId) — String — Foreign key → Untitled.Key — NOT NULL
  • Key (networkId) — String — Foreign key → Untitled.Key — NOT NULL
  • Key (currencyId) — String — Foreign key → Untitled.Key — NOT NULL
  • Field (price) — String
  • Field (changed_percentage_in_24_hours) — Double
  • Field (weekly_change_graph) — Array[Date,Price]
  • Field (market_cap) — Number
  • Field (volume_24_hours) — Number
  • Field (circulating_supply) — Number

Untitled (Wallet)

  • Key (id) — String — Primary key — NOT NULL
  • Key (userId) — String — Foreign key → User.Key — NOT NULL
  • Key (networkId) — String — Foreign key → Untitled.Key — NOT NULL
  • Field (walletAddress) — String
  • Field (walletPrivateKey) — String
  • Field (isDeleted) — Boolean
  • Field

Untitled (Balance)

  • Key (id) — String — Primary key — NOT NULL
  • Key (walletId) — String — Foreign key → Untitled.Key — NOT NULL
  • Key (userId) — String — Foreign key → Untitled.Key — NOT NULL
  • Key (networkId) — String — Foreign key → Untitled.Key — NOT NULL
  • Key (coinId) — String — Foreign key → Untitled.Key — NOT NULL
  • Field (balance) — Number
  • Field (createdAt) — Date
  • Field (updatedAt) — Date
  • Field

Untitled (Transaction)

  • Key (id) — String — Primary key — NOT NULL
  • Key (coinId) — String — Foreign key → Untitled.Key — NOT NULL
  • Key (networkId) — String — Foreign key → Untitled.Key — NOT NULL
  • Key (walletId) — String — Foreign key → Untitled.Key — NOT NULL
  • Key (userId) — String — Foreign key → Untitled.Key — NOT NULL
  • Field (from_address) — String
  • Field (to_address) — String
  • Field (transactionHash) — String
  • Field (status) — String
  • Field (type) — String
  • Field (amount) — Double
  • Field (amountInUsd) — Double
  • Field (fee) — Double
  • Field (feeInUsd) — Double
  • Field (transactionTime) — Date
  • Field (isDeleted) — Boolean
  • Field (transactionUrl) — String
  • Field

Untitled (Address Book)

  • Key (id) — String — Primary key — NOT NULL
  • Key (userId) — String — Foreign key → User.Key — NOT NULL
  • Key (networkId) — String — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — String
  • Field (address) — String
  • Field (label) — String
  • Field (createAt) — String
  • Field (updatedAt) — String
  • Field (isDeleted) — String
  • Field

Untitled (BuyCryptoTransaction)

  • Key (id) — String — Primary key — NOT NULL
  • Key (walletId) — String — Foreign key → Untitled.Key — NOT NULL
  • Key (userId) — String — Foreign key → Untitled.Key — NOT NULL
  • Key (networkId) — String — Foreign key → Untitled.Key — NOT NULL
  • Key (coinId) — String — Foreign key → Untitled.Key — NOT NULL
  • Key (currencyId) — String — Foreign key → Untitled.Key — NOT NULL
  • Field (fiatAmount) — Double
  • Field (currency) — String
  • Field (cryptoAmount) — String
  • Field (platform) — String
  • Field (paymentMethod) — String
  • Field (status) — String
  • Field (isDeleted) — Boolean
  • Field (createdAt) — Date
  • Field (updatedAt) — Date
  • Field

Untitled (Fiat Card)

  • Key (id) — String — Primary key — NOT NULL
  • Key (userId) — String — Foreign key → User.Key — NOT NULL
  • Field (cardNumber) — String
  • Field (cardHolderName) — String
  • Field (expiryDate) — Date
  • Field (cvc) — Integer
  • Field (type) — enum(Credit, Debit)
  • Field (provider) — String(Visa, Mastercard)
  • Field

Untitled (Fiat Currency)

  • Key (id) — String — Primary key — NOT NULL
  • Field (name) — String
  • Field (symbol) — String
  • Field (shortName) — String
  • Field (isPopular) — Boolean
  • Field (isActive) — Boolean
  • Field (isDeleted) — Boolean
  • Field (createdAt) — Date
  • Field (updatedAt) — Date
  • Field

User

  • Key (id) — String — Primary key — NOT NULL
  • Field (firstname) — String
  • Field (lastname) — String
  • Field (email) — String
  • Field (password) — String
  • Field (isBusiness) — Boolean
  • Field (businessName) — String
  • Field (businessDba) — String
  • Field (businessAddress) — String
  • Field (isActive) — Boolean
  • Field2 (isDeleted) — Boolean
  • Field (createdAt) — Date
  • Field (updatedAt) — Date
  • Field