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)