Database Project

Tables (5)

Untitled (Users)

  • Field (UserID) — Primary key
  • Field2 (Name)
  • Field3 (Email)
  • Field4 (Password)
  • Field5 (RiskTolerance)
  • Field6 (InvestmentGoal)
  • Field7 (ExperienceLevel1)
  • Field (RegistrationDate)

Untitled (SerchHistory)

  • Field (SearchID) — Primary key
  • Field2 (UserID) — Primary key
  • Field3 (SearchTerm)
  • Field4 (SearchDate)
  • Field (UserID2) — Foreign key → Untitled.Field

Untitled (Stocks)

  • Field (StockID) — Primary key
  • Field2 (Name)
  • Field3 (Description)
  • Field4 (Price)
  • Field5 (Volume)
  • Field6 (MarketCap)

Untitled (Recommendations)

  • Field (RecommendationID) — Primary key
  • Field2 (UserID) — Primary key
  • Field4 (CryptoID) — nullable — Primary key
  • Field3 (StockID) — nullable — Primary key
  • Field5 (RecommendationDate)
  • Field (UserID2) — Foreign key → Untitled.Field
  • Field (StockID2) — Foreign key → Untitled.Field
  • Field (CryptoID2) — Foreign key → Untitled2.Field

Untitled2 (Cryptos)

  • Field (CryptoID) — Primary key
  • Field2 (Name)
  • Field3 (Description)
  • Field4 (Price)
  • Field5 (MarketCap)