value point

Tables (28)

B/S (Untitled6)

  • Key — Primary key — NOT NULL
  • TotalCurrentAssets (Field)
  • TotalNonCurrentAssets (Field2)
  • TotalAssets (Field3)
  • TotalCurrentLiabilities (Field4)
  • TotalNonCurrentLiabilities (Field5)
  • TotalLiabilities (Field6)
  • TotalShareholdersEquity (Field7)

BusinessModel (Untitled9)

  • Key — Primary key — NOT NULL
  • Description (Field)

Cash Flow Statement Items (CopyOfCopyOfUntitled6)

  • Key — Primary key — NOT NULL
  • NetCashFromOperatingActivities (Field)
  • NetCashUsedInInvestingActivities (Field2)
  • NetCashFromFinancingActivities (Field3)
  • NetchageInCash (Field4)

CompanyHistory (Untitled20)

  • Key — Primary key — NOT NULL
  • Year (Field)
  • Milestone (Field2)
  • Description (Field3)

CompetitiveLandscape (Untitled13)

  • Key — Primary key — NOT NULL
  • CompetitorMarketShare (Field)
  • Strategic Moves (Field2)
  • Threat Level (Field3)

Consensus (Untitled4)

  • Key — Primary key — NOT NULL
  • Company_id (Ticker) — Foreign key → STOCK.Ticker — NOT NULL
  • MarketConsensus_id (Key2) — Foreign key → MarketConsensus.Key — NOT NULL
  • Key (Key7) — Foreign key → STOCK.FinancialData_id — NOT NULL
  • Field2

ExpertConsensus (Untitled8)

  • Key — Primary key — NOT NULL
  • Consensus_id (Ticker) — Foreign key → Consensus.Company_id — NOT NULL
  • Key (Key7) — Foreign key → Consensus.Key — NOT NULL
  • ExpertOpinion (Field2)
  • AnalasysDate (Field3)
  • Recommendation (Field4)
  • PriceTarget (Field5)

FINANCIAL DATA (Untitled2)

  • FinancialData_id (Key) — Primary key — NOT NULL
  • Cash Flow Statement_id (Key2) — Foreign key → Cash Flow Statement Items.Key — NOT NULL
  • I/S_id (Key3) — Foreign key → I/S.Key — NOT NULL
  • B/S_id (Key4) — Foreign key → B/S.Key — NOT NULL
  • Company_id (Ticker) — Foreign key → STOCK.Ticker — NOT NULL
  • Key (Key7) — Foreign key → STOCK.FinancialData_id — NOT NULL
  • FiscalYear (Field)
  • ReportType (Annual, Quarterly) (Field2)
  • Date (Field3)

I/S (CopyOfUntitled6)

  • Key — Primary key — NOT NULL
  • Total Revenue (Field)
  • CostOfGoodsSold (Field2)
  • GrossProfit (Field3)
  • OperatingExpenses (Field4)
  • OperatingIncome (Field5)
  • NetIncome (Field6)

INDUSTRY (Untitled)

  • key — Primary key — NOT NULL
  • RegulatoryEnvironment_id (Key) — Foreign key → RegulatoryEnvironment.Key — NOT NULL
  • CompetitiveLandscape_id (Key2) — Foreign key → CompetitiveLandscape.Key — NOT NULL
  • IndustryTrend_id (Key3) — Foreign key → IndustryTrends.Key — NOT NULL
  • Market Position (Field3)

IndustryTrends (Untitled17)

  • Key — Primary key — NOT NULL
  • TrendDescription (Field)
  • ImpactLevel (Field2)
  • Date (Field3)

Macro (Untitled3)

  • Key — Primary key — NOT NULL
  • Date (Field)
  • InterestRates (Field2)
  • InflationRate (Field3)
  • GDPGrowthRate (Field4)
  • UnemploymentRate (Field5)
  • ConsumerConfidence (Field6)
  • ManufacturingPMI (Field7)
  • RetailSales (Field8)
  • CurrencyExchangeRates (Field9)
  • CommodityPrices (Field10)

ManagementOverview (Untitled19)

  • Key — Primary key — NOT NULL
  • ExecutiveName (Field)
  • Position (Field2)
  • Background (Field3)
  • Field4

Market Position (Untitled18)

  • Key — Primary key — NOT NULL
  • MarketShare (Field)
  • CompetitiveAdvantage (Field2)
  • MarketChallenges (Field3)

MarketConsensus (Untitled7)

  • Key — Primary key — NOT NULL
  • Date (Field5)
  • AverageTargetPrice (Field)
  • SentimentIndicator (Field2)
  • NumberOfAnalysts (Field3)
  • ConsensusDetails (Field4)

News (Untitled14)

  • Key — Primary key — NOT NULL
  • Description (Field2)

NewsStock (Untitled15)

  • Company_id (Ticker) — Foreign key → STOCK.Ticker — NOT NULL
  • News_id (Key3) — Foreign key → News.Key — NOT NULL
  • Key (Key7) — Foreign key → STOCK.FinancialData_id — NOT NULL
  • InfluencingFactor (Field)

RegulatoryEnvironment (Untitled12)

  • Key — Primary key — NOT NULL
  • Description (Field)
  • Impact On Industry (Field2)
  • ComplianceRequirements (Field3)
  • ImplementationDate (Field4)

RiskAndReturn (Untitled11)

  • Key — Primary key — NOT NULL
  • Risk Free Rate (Field)
  • Market Risk Premium (Field2)
  • Company Specific Beta (Field3)
  • Cost of Debt (Field4)
  • Capital Structure (Field5)
  • Overall Risk Assessment (Field6)

STOCK

  • Ticker — Primary key — NOT NULL
  • Industry_id (ID) — Foreign key → INDUSTRY.key — NOT NULL
  • CompanyAnalysis_id (Key) — Foreign key → StockInfo.BusinessModel_id — NOT NULL
  • FinancialData_id (Key7) — Foreign key → StockInfo.RiskAndReturn_id — NOT NULL
  • Name (Field)
  • Sector (Field3)
  • Industry (Field4)
  • StockCount (Field2)

SURVEY

  • Survey_id (Key) — Primary key — NOT NULL
  • User_id (Key2) — Foreign key → USER.Key — NOT NULL
  • Stock_id (Key3) — Foreign key → STOCK.Ticker — NOT NULL
  • Valuation_id (Key5) — Foreign key → VALUATION_RESULT.Valuation_id — NOT NULL
  • Decision_id (Key4) — Foreign key → UserDecision.Decision_id — NOT NULL
  • Key (Key7) — Foreign key → STOCK.FinancialData_id — NOT NULL

SWOT (CopyOfUntitled9)

  • Key — Primary key — NOT NULL
  • Strengths (Field)
  • Weaknesses (Field2)
  • Opportunities (Field3)
  • Threats (Field4)

StockInfo (Untitled10)

  • CompanyAnalysis (Key3) — Primary key — NOT NULL
  • BusinessModel_id (Key) — Foreign key → BusinessModel.Key — NOT NULL
  • SWOT_id (Key2) — Foreign key → SWOT.Key — NOT NULL
  • MarketPosition_id (Key4) — Foreign key → Market Position.Key — NOT NULL
  • ManagementOverview_id (Key5) — Foreign key → ManagementOverview.Key — NOT NULL
  • History_id (Key6) — Foreign key → CompanyHistory.Key — NOT NULL
  • RiskAndReturn_id (Key7) — Foreign key → RiskAndReturn.Key — NOT NULL

USER (Untitled5)

  • Key — Primary key — NOT NULL
  • UserName (Field)
  • Age (Field2)
  • Email (Field3)
  • RegistrationDate (Field4)
  • LastLoginDate (Field5)

UserDecision (CopyOfSURVEY)

  • Decision_id (Key) — Primary key — NOT NULL
  • SWOTConfirmation (Field4)
  • GrowthRateOption (Field5)
  • OperatingMarginOption (Field6)
  • RiskLevel (Field7)
  • LongTermGrowthRate (Field8)
  • WACCAgreement (Field9)
  • NonOperatingItemsConfirmation (Field10)
  • DebtAndCashConfirmation (Field11)
  • ComparableAgreement (Field12)
  • FinalValuationAgreement (Field13)

UserStock (Untitled21)

  • Key — Primary key — NOT NULL
  • Ticker — Foreign key → STOCK.Ticker — NOT NULL
  • User_id (Key2) — Foreign key → USER.Key — NOT NULL
  • Key (Key7) — Foreign key → STOCK.FinancialData_id — NOT NULL

VALUATION_RESULT (CopyOfSURVEY2)

  • Valuation_id (Key) — Primary key — NOT NULL
  • DCFValues (Field)
  • EquityValue (Field2)
  • TargetPricePershare (Field3)
  • DateCalculated (Field4)
  • ScenarioID (Field5)
  • ScenarioType (Field6)
  • ScenarioValuation (Field7)
  • FinalValuationAgreement (Field13)

WACC (Untitled16)