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)