Tables and Relationships

1. Users Table
   • id (Primary Key)
   • fullName
   • email
   • mobile
   • password
   • status
   • isVerified
   • twoFactorAuth_enabled
   • twoFactorAuth_sendTo
   • picture
   • role
2. Coins Table
   • id (Primary Key)
   • symbol
   • name
   • image
   • current_price
   • market_cap
   • market_cap_rank
   • fully_diluted_valuation
   • total_volume
   • high_24h
   • low_24h
   • price_change_24h
   • price_change_percentage_24h
   • market_cap_change_24h
   • market_cap_change_percentage_24h
   • circulating_supply
   • total_supply
   • max_supply
   • ath
   • ath_change_percentage
   • ath_date
   • atl
   • atl_change_percentage
   • atl_date
   • roi
   • last_updated
3. Assets Table
   • id (Primary Key)
   • quantity
   • buy_price
   • coin_id (Foreign Key referencing Coins)
   • user_id (Foreign Key referencing Users)
4. Withdrawals Table
   • id (Primary Key)
   • status
   • amount
   • user_id (Foreign Key referencing Users)
   • date
5. Watchlists Table
   • id (Primary Key)
   • user_id (Foreign Key referencing Users)
6. Watchlist_Coins Table (Join Table for many-to-many relationship)
   • watchlist_id (Foreign Key referencing Watchlists)
   • coin_id (Foreign Key referencing Coins)
7. WalletTransactions Table
   • id (Primary Key)
   • wallet_id (Foreign Key referencing Wallets)
   • type
   • date
   • transfer_id
   • purpose
   • amount
8. Wallets Table
   • id (Primary Key)
   • user_id (Foreign Key referencing Users)
   • balance
9. VerificationCodes Table
   • id (Primary Key)
   • otp
   • user_id (Foreign Key referencing Users)
   • email
   • mobile
   • verification_type
10. TradingHistories Table
    • id (Primary Key)
    • selling_price
    • buying_price
    • coin_id (Foreign Key referencing Coins)
    • user_id (Foreign Key referencing Users)
11. PaymentOrders Table
    • id (Primary Key)
    • amount
    • status
    • payment_method
    • user_id (Foreign Key referencing Users)
12. PaymentDetails Table
    • id (Primary Key)
    • account_number
    • account_holder_name
    • ifsc
    • bank_name
    • user_id (Foreign Key referencing Users)
13. Orders Table
14. OrderItems Table
15. Notifications Table
16. MarketChartData Table
17. ForgotPasswordTokens Table