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