将文件拖动至此

SQL 上传 ( 0 ) x -

服务器: localhost »数据库: NorenDionNewsData
页面相关设置 点击以滚动到页面顶部
按 Ctrl+Enter 键执行查询 按 Enter 执行查询
递增排序
递减排序
命令：
调试 SQL
数量
运行顺序
用时
排序条件：
联合查询
不使用联合查询
崩溃 扩展 显示跟踪 隐藏跟踪 数量 用时
书签
刷新
添加
没有书签
添加书签
选项
恢复默认





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库 : 查询时间 :
未命名 *
v 显示/隐藏表格列表 全屏查看 从其他数据库中添加表 新页面 打开页面 保存页面 保存页面为 删除页 新建数据表 创建关系 选择要显示的字段 重新载入 帮助 折角连接 / 直接连接 对齐网格 v 全部收缩/展开 反向收缩/展开 显示/隐藏关系线 导出架构 > 移动菜单 > 固定文字
v v
数据表数量： 0
v NorenDionNewsData BackgroundInfo
* CompanyCode : double(20,2)
* ParentCompanyCode : double(20,2)
* CompanyName : varchar(75)
* ShortCompanyName : varchar(40)
* TickerName : varchar(40)
* PersonDescription : varchar(30)
* PersonName : varchar(100)
* ExecutiveDescription : varchar(30)
* ExecutiveName : varchar(100)
* ExchangeCode : varchar(30)
* ExchangeName : varchar(30)
* ExchangeGroup : varchar(30)
* Sourcetype : varchar(30)
* IncorporationDate : varchar(30)
* FirstPublicIssueDate : varchar(30)
* Auditeddate : varchar(30)
* FaceValue : double(20,2)
* Marketlot : int(10)
* IndustryCode : int(10)
* IndustryName : varchar(256)
* BusinessGroupCode : int(10)
* BusinessGroupName : varchar(256)
* MajorSector : int(10)
* LatestFinYear : varchar(50)
* ForemostFinYear : varchar(50)
* LatestHalfYear : varchar(50)
* ForemostHalfYear : varchar(50)
* LatestQtrYear : varchar(50)
* ForemostQtrYear : varchar(50)
* ModifiedDate : varchar(40)
v NorenDionNewsData BlockDeals
* SecurityCode : varchar(40)
* ExchangeCode : bigint(20)
* DealDate : varchar(40)
* DealType : varchar(10)
* ClientName : varchar(200)
* Quantity : bigint(10)
* Price : double(20,2)
* Remarks : varchar(100)
* ModifiedDate : varchar(40)
* DeleteFlag : int(1)
v NorenDionNewsData BulkDeals
* SecurityCode : varchar(40)
* ExchangeCode : bigint(20)
* DealDate : varchar(40)
* DealType : varchar(10)
* ClientName : varchar(200)
* Quantity : bigint(10)
* Price : double(20,2)
* Remarks : varchar(100)
* ModifiedDate : varchar(40)
* DeleteFlag : int(1)
v NorenDionNewsData CompanyMaster
* CompanyCode : double(12,2)
* CompanyName : varchar(255)
* ShortCompanyName : varchar(255)
* IndustryCode : int(10)
* IndustryName : varchar(255)
* BusinessGroupCode : int(10)
* BusinessGroupName : varchar(255)
* IncorporationDate : varchar(50)
* IncorporationYear : varchar(100)
* FirstPublicIssueDate : varchar(50)
* FirstPublicIssueYear : varchar(100)
* MajorSector : int(10)
* CINNo : varchar(30)
* Remarks : varchar(2550)
* ModifiedDate : varchar(50)
* DeleteFlag : int(1)
v NorenDionNewsData FiiCashDetails
* Date : varchar(20)
* Equity_Purchase_Primary : bigint(20)
* Equity_Sell_Primary : bigint(20)
* Equity_NetInvestment_Primary : bigint(20)
* Equity_Purchase_Secondary : bigint(20)
* Equity_Sell_Secondary : bigint(20)
* Equity_NetInvestment_Secondary : bigint(20)
* Debt_Purchase_Primary : bigint(20)
* Debt_Sell_Primary : bigint(20)
* Debt_NetInvestment_Primary : bigint(20)
* Debt_Purchase_Secondary : bigint(20)
* Debt_Sell_Secondary : bigint(20)
* Debt_NetInvestment_Secondary : bigint(20)
* ConversionValue : bigint(20)
* ModifiedDate : varchar(40)
* DeleteFlag : int(1)
v NorenDionNewsData FiiDerivatives
* FIIDate : varchar(20)
* InstrumentType : varchar(40)
* BuyNoOfContract : bigint(20)
* BuyValue : bigint(20)
* SellNoOfContract : bigint(20)
* SellValue : bigint(20)
* OpenInterestNoOfContract : bigint(20)
* OpenInterestValue : bigint(20)
* Denomination : bigint(20)
* ModifiedDate : varchar(40)
v NorenDionNewsData FinanceBankingVI
* CompanyCode : double(20,2)
* YearEnding : varchar(40)
* Months : int(10)
* Type : varchar(10)
* FaceValue : double(20,2)
* InterestDiscountOnAdvancesBills : double(20,2)
* IncomeFromInvestments : double(20,2)
* InterestOnBalanceWithRBIAndOtherInterBankFunds : double(20,2)
* Others : double(20,2)
* TotalInterestEarned : double(20,2)
* OtherIncome : double(20,2)
* TotalIncome : double(20,2)
* InterestExpended : double(20,2)
* PaymentsToAndProvisionsForEmployees : double(20,2)
* Depreciation : double(20,2)
* DepreciationOnLeasedAssets : double(20,2)
* OperatingExpensesExcludesEmployeeCostAndDepreciation : double(20,2)
* TotalOperatingExpenses : double(20,2)
* ProvisionTowardsIncomeTax : double(20,2)
* ProvisionTowardsDeferredTax : double(20,2)
* ProvisionTowardsOtherTaxes : double(20,2)
* OtherProvisionsAndContingencies : double(20,2)
* TotalProvisionsAndContingencies : double(20,2)
* TotalExpenditure : double(20,2)
* NetProfitLossForTheYear : double(20,2)
* PriorPeriodItems : double(20,2)
* ExtraordinaryItems : double(20,2)
* NetProfitLossForTheYearAfterEI : double(20,2)
* ProfitLossBroughtForward : double(20,2)
* TransferredOnAmalgamation : double(20,2)
* TotalProfitLoss : double(20,2)
* TransferToFromStatutoryReserve : double(20,2)
* TransferToFromReserveFund : double(20,2)
* TransferToFromSpecialReserve : double(20,2)
* TransferToFromCapitalReserve : double(20,2)
* TransferToFromGeneralReserve : double(20,2)
* TransferToFromInvestmentReserve : double(20,2)
* TransferToFromRevenueAndOtherReserves : double(20,2)
* DividendForThePreviousYear : double(20,2)
* EquityShareDividend : double(20,2)
* PreferenceShareDividend : double(20,2)
* TaxOnDividend : double(20,2)
* BalanceCarriedOverToBalanceSheet : double(20,2)
* TotalAppropriations : double(20,2)
* EquityShares : double(20,2)
* EquityCapital : double(20,2)
* PreferenceCapital : double(20,2)
* TotalShareCapital : double(20,2)
* RevaluationReserves : double(20,2)
* ReservesAndSurplus : double(20,2)
* TotalReservesAndSurplus : double(20,2)
* MoneyAgainstShareWarrants : double(20,2)
* EmployeesStockOptions : double(20,2)
* TotalShareHoldersFunds : double(20,2)
* EquityShareApplicationMoney : double(20,2)
* PrefShareApplicationMoney : double(20,2)
* ShareCapitalSuspense : double(20,2)
* Deposits : double(20,2)
* Borrowings : double(20,2)
* OtherLiabilitiesAndProvisions : double(20,2)
* TotalCapitalAndLiabilities : double(20,2)
* CashAndBalancesWithReserveBankOfIndia : double(20,2)
* BalancesWithBanksMoneyAtCallAndShortNotice : double(20,2)
* Investments : double(20,2)
* Advances : double(20,2)
* FixedAssets : double(20,2)
* OtherAssets : double(20,2)
* TotalAssets : double(20,2)
* NetProfitLossBeforeExtraordinaryItemsAndTax : double(20,2)
* NetCashFlowFromOperatingActivities : double(20,2)
* NetCashUsedInInvestingActivities : double(20,2)
* NetCashUsedFromFinancingActivities : double(20,2)
* ForeignExchangeGainsLosses : double(20,2)
* NetIncDecInCashAndCashEquivalents : double(20,2)
* CashAndCashEquivalentBeginOfYear : double(20,2)
* CashAndCashEquivalentEndOfYear : double(20,2)
* BasicEPS : double(20,2)
* DilutedEPS : double(20,2)
* NumberOfBranches : double(20,2)
* NumberOfEmployees : double(20,2)
* CapitalAdequacyRatios : double(20,2)
* KeyPerformanceTier1 : double(20,2)
* KeyPerformanceTier2 : double(20,2)
* GrossNPARs : double(20,2)
* GrossNPAPercentage : double(20,2)
* NetNPARs : double(20,2)
* NetNPAPercentage : double(20,2)
* NetNPAToAdvancesPercentage : double(20,2)
* BillsForCollection : double(20,2)
* ContingentLiabilities : double(20,2)
* EquityDividendRate : double(20,2)
* BonusEquityShareCapital : double(20,2)
* ModifiedDate : varchar(40)
v NorenDionNewsData FinanceConsolidatedBankingVI
* CompanyCode : double(20,2)
* YearEnding : varchar(40)
* Months : int(10)
* Type : varchar(10)
* FaceValue : double(20,2)
* InterestDiscountOnAdvancesBills : double(20,2)
* IncomeFromInvestments : double(20,2)
* InterestOnBalanceWithRBIAndOtherInterBankFunds : double(20,2)
* Others : double(20,2)
* TotalInterestEarned : double(20,2)
* OtherIncome : double(20,2)
* TotalIncome : double(20,2)
* InterestExpended : double(20,2)
* PaymentsToAndProvisionsForEmployees : double(20,2)
* Depreciation : double(20,2)
* DepreciationOnLeasedAssets : double(20,2)
* OperatingExpensesExcludesEmployeeCostAndDepreciation : double(20,2)
* TotalOperatingExpenses : double(20,2)
* ProvisionTowardsIncomeTax : double(20,2)
* ProvisionTowardsDeferredTax : double(20,2)
* ProvisionTowardsOtherTaxes : double(20,2)
* OtherProvisionsAndContingencies : double(20,2)
* TotalProvisionsAndContingencies : double(20,2)
* TotalExpenditure : double(20,2)
* NetProfitLossForTheYear : double(20,2)
* PriorPeriodItems : double(20,2)
* ExtraordinaryItems : double(20,2)
* NetProfitLossForTheYearAfterEI : double(20,2)
* IncomeMinorityInterest : double(20,2)
* ShareOfProfitLossFromAssociate : double(20,2)
* ProfitLossAfterMIAndAssociates : double(20,2)
* ProfitLossBroughtForward : double(20,2)
* TransferredOnAmalgamation : double(20,2)
* TotalProfitLoss : double(20,2)
* TransferToFromStatutoryReserve : double(20,2)
* TransferToFromReserveFund : double(20,2)
* TransferToFromSpecialReserve : double(20,2)
* TransferToFromCapitalReserve : double(20,2)
* TransferToFromGeneralReserve : double(20,2)
* TransferToFromInvestmentReserve : double(20,2)
* TransferToFromRevenueAndOtherReserves : double(20,2)
* DividendForThePreviousYear : double(20,2)
* EquityShareDividend : double(20,2)
* PreferenceShareDividend : double(20,2)
* TaxOnDividend : double(20,2)
* BalanceCarriedOverToBalanceSheet : double(20,2)
* TotalAppropriations : double(20,2)
* EquityShares : double(20,2)
* EquityCapital : double(20,2)
* PreferenceCapital : double(20,2)
* TotalShareCapital : double(20,2)
* RevaluationReserves : double(20,2)
* ReservesAndSurplus : double(20,2)
* TotalReservesAndSurplus : double(20,2)
* MoneyAgainstShareWarrants : double(20,2)
* EmployeesStockOptions : double(20,2)
* TotalShareHoldersFunds : double(20,2)
* EquityShareApplicationMoney : double(20,2)
* PrefShareApplicationMoney : double(20,2)
* ShareCapitalSuspense : double(20,2)
* LiabilityMinorityInterest : double(20,2)
* PolicyHoldersFunds : double(20,2)
* LiabilityGroupShareInJointVentures : double(20,2)
* Deposits : double(20,2)
* Borrowings : double(20,2)
* OtherLiabilitiesAndProvisions : double(20,2)
* TotalCapitalAndLiabilities : double(20,2)
* CashAndBalancesWithReserveBankOfIndia : double(20,2)
* BalancesWithBanksMoneyAtCallAndShortNotice : double(20,2)
* Investments : double(20,2)
* Advances : double(20,2)
* FixedAssets : double(20,2)
* OtherAssets : double(20,2)
* AssetMinorityInterest : double(20,2)
* AssetGroupShareInJointVentures : double(20,2)
* TotalAssets : double(20,2)
* NetProfitLossBeforeExtraordinaryItemsAndTax : double(20,2)
* NetCashFlowFromOperatingActivities : double(20,2)
* NetCashUsedInInvestingActivities : double(20,2)
* NetCashUsedFromFinancingActivities : double(20,2)
* ForeignExchangeGainsLosses : double(20,2)
* NetIncDecInCashAndCashEquivalents : double(20,2)
* CashAndCashEquivalentBeginOfYear : double(20,2)
* CashAndCashEquivalentEndOfYear : double(20,2)
* BasicEPS : double(20,2)
* DilutedEPS : double(20,2)
* NumberOfBranches : double(20,2)
* NumberOfEmployees : double(20,2)
* CapitalAdequacyRatios : double(20,2)
* KeyPerformanceTier1 : double(20,2)
* KeyPerformanceTier2 : double(20,2)
* GrossNPARs : double(20,2)
* GrossNPAPercentage : double(20,2)
* NetNPARs : double(20,2)
* NetNPAPercentage : double(20,2)
* NetNPAToAdvancesPercentage : double(20,2)
* BillsForCollection : double(20,2)
* ContingentLiabilities : double(20,2)
* BonusEquityShareCapital : double(20,2)
* ModifiedDate : varchar(40)
v NorenDionNewsData FinanceConsolidatedNonBankingVI
* CompanyCode : double(20,2)
* YearEnding : varchar(40)
* Months : int(10)
* Type : varchar(10)
* FaceValue : double(20,2)
* RevenueFromOperationsGross : double(20,2)
* LessExciseSeviceTaxOtherLevies : double(20,2)
* RevenueFromOperationsNet : double(20,2)
* OtherOperatingRevenues : double(20,2)
* TotalOperatingRevenues : double(20,2)
* OtherIncome : double(20,2)
* GroupShareInJointVenturesInIncome : double(20,2)
* TotalRevenue : double(20,2)
* CostOfMaterialsConsumed : double(20,2)
* PurchaseOfStockInTrade : double(20,2)
* PurchaseOfCrudeOilAndOthers : double(20,2)
* CostOfPowerPurchased : double(20,2)
* CostOfFuel : double(20,2)
* AircraftFuelExpenses : double(20,2)
* AircraftLeaseRentals : double(20,2)
* OperatingAndDirectExpenses : double(20,2)
* ChangesIninventoriesOfFGWIPAndStockInTrade : double(20,2)
* EmployeeBenefitExpenses : double(20,2)
* FinanceCosts : double(20,2)
* ProvisionsAndContingencies : double(20,2)
* DepreciationAndAmortisationExpenses : double(20,2)
* MiscExpensesWOff : double(20,2)
* OtherExpenses : double(20,2)
* LessInterUnitSegmentDivisionTransfer : double(20,2)
* LessTransferToFromInvestmentFixedAssetsOthers : double(20,2)
* LessAmountsTransferToCapitalAccounts : double(20,2)
* LessShareOfLossFromPartnershipFirm : double(20,2)
* GroupShareInJointVenturesInExpenditure : double(20,2)
* TotalExpenses : double(20,2)
* ProfitLossBeforeExceptionalExtraOrdinaryItemsAndTax : double(20,2)
* ExceptionalItems : double(20,2)
* ProfitLossBeforeTax : double(20,2)
* CurrentTax : double(20,2)
* LessMATCredit : double(20,2)
* DeferredTax : double(20,2)
* OtherDirectTaxes : double(20,2)
* TaxForEarlierYears : double(20,2)
* TotalTaxExpensesContinuedOperations : double(20,2)
* ProfitLossAfterTaxAndBeforeExtraOrdinaryItems : double(20,2)
* PriorPeriodItems : double(20,2)
* ExtraordinaryItems : double(20,2)
* ProfitLossFromContinuingOperations : double(20,2)
* ProfitLossFromDiscontinuingOperations : double(20,2)
* TotalTaxExpensesDiscontinuingOperations : double(20,2)
* NetProfitLossFromDiscontinuingOperations : double(20,2)
* ProfitLossForThePeriod : double(20,2)
* IncomeMinorityInterest : double(20,2)
* ShareOfProfitLossOfAssociates : double(20,2)
* ProfitLossAfterMIAndAssociates : double(20,2)
* EquityShares : double(20,2)
* EquityCapital : double(20,2)
* PreferenceCapital : double(20,2)
* TotalShareCapital : double(20,2)
* RevaluationReserves : double(20,2)
* ReservesAndSurplus : double(20,2)
* TotalReservesAndSurplus : double(20,2)
* MoneyAgainstShareWarrants : double(20,2)
* EmployeesStockOptions : double(20,2)
* TotalShareHoldersFunds : double(20,2)
* PrefSharesIssuedBySubsidiaryCos : double(20,2)
* EquityShareApplicationMoney : double(20,2)
* PreferenceShareApplicationMoney : double(20,2)
* ShareCapitalSuspense : double(20,2)
* HybridDebtOtherSecurities : double(20,2)
* StatutoryConsumerReserves : double(20,2)
* SpecialApprnTowardsProjectCost : double(20,2)
* ServiceLineContributionFromConsumers : double(20,2)
* GovernmentOtherGrants : double(20,2)
* LiabilityMinorityInterest : double(20,2)
* PolicyHoldersFunds : double(20,2)
* LiabilityGroupShareInJointVentures : double(20,2)
* LongTermBorrowings : double(20,2)
* DeferredTaxLiabilities : double(20,2)
* OtherLongTermLiabilities : double(20,2)
* LongTermProvisions : double(20,2)
* TotalNonCurrentLiabilities : double(20,2)
* ForeignCurrencyMonetaryItemTranslationDifferenceLiabilityAccount : double(20,2)
* ShortTermBorrowings : double(20,2)
* TradePayables : double(20,2)
* OtherCurrentLiabilities : double(20,2)
* ShortTermProvisions : double(20,2)
* TotalCurrentLiabilities : double(20,2)
* TotalCapitalAndLiabilities : double(20,2)
* TangibleAssets : double(20,2)
* IntangibleAssets : double(20,2)
* CapitalWorkInProgress : double(20,2)
* IntangibleAssetsUnderDevelopment : double(20,2)
* OtherAssets : double(20,2)
* ConstructionStores : double(20,2)
* MiningDevelopmentExpenditure : double(20,2)
* AssetsHeldForSale : double(20,2)
* TotalFixedAssets : double(20,2)
* GoodwillOnConsolidation : double(20,2)
* NonCurrentInvestments : double(20,2)
* DeferredTaxAssets : double(20,2)
* LongTermLoansAndAdvances : double(20,2)
* OtherNonCurrentAssets : double(20,2)
* TotalNonCurrentAssets : double(20,2)
* AssetMinorityInterest : double(20,2)
* AssetGroupShareInJointVentures : double(20,2)
* ForeignCurrencyMonetaryItemTranslationDiffAcct : double(20,2)
* CurrentInvestments : double(20,2)
* Inventories : double(20,2)
* TradeReceivables : double(20,2)
* CashAndCashEquivalents : double(20,2)
* ShortTermLoansAndAdvances : double(20,2)
* OtherCurrentAssets : double(20,2)
* TotalCurrentAssets : double(20,2)
* TotalAssets : double(20,2)
* NetProfitLossBeforeExtraordinaryItemsAndTax : double(20,2)
* NetCashFlowFromOperatingActivities : double(20,2)
* NetCashUsedInInvestingActivities : double(20,2)
* NetCashUsedFromFinancingActivities : double(20,2)
* ForeignExchangeGainsLosses : double(20,2)
* AdjustmentsOnAmalgamationMergerDemergerOthers : double(20,2)
* NetIncDecInCashAndCashEquivalents : double(20,2)
* CashAndCashEquivalentBeginOfYear : double(20,2)
* CashAndCashEquivalentEndOfYear : double(20,2)
* BasicEPS : double(20,2)
* DilutedEPS : double(20,2)
* ContingentLiabilities : double(20,2)
* CIFValueOfRawMaterials : double(20,2)
* CIFValueOfStoresSparesAndLooseTools : double(20,2)
* CIFValueOfOtherGoods : double(20,2)
* CIFValueOfCapitalGoods : double(20,2)
* ExpenditureInForeignCurrency : double(20,2)
* DividendRemittanceInForeignCurrency : double(20,2)
* ForeignExchangeFOB : double(20,2)
* ForeignExchangeOtherEarnings : double(20,2)
* ImportedRawMaterials : double(20,2)
* IndigenousRawMaterials : double(20,2)
* ImportedStoresAndSpares : double(20,2)
* IndigenousStoresAndSpares : double(20,2)
* EquityShareDividend : double(20,2)
* PreferenceShareDividend : double(20,2)
* TaxOnDividend : double(20,2)
* BonusEquityShareCapital : double(20,2)
* NonCurrentInvestmentsQuotedMarketValue : double(20,2)
* NonCurrentInvestmentsUnquotedBookValue : double(20,2)
* CurrentInvestmentsQuotedMarketValue : double(20,2)
* CurrentInvestmentsUnquotedBookValue : double(20,2)
* ModifiedDate : varchar(40)
v NorenDionNewsData FinanceNonBankingVI
* CompanyCode : double(20,2)
* YearEnding : varchar(40)
* Months : int(10)
* Type : varchar(10)
* FaceValue : double(20,2)
* RevenueFromOperationsGross : double(20,2)
* LessExciseSeviceTaxOtherLevies : double(20,2)
* RevenueFromOperationsNet : double(20,2)
* OtherOperatingRevenues : double(20,2)
* TotalOperatingRevenues : double(20,2)
* OtherIncome : double(20,2)
* TotalRevenue : double(20,2)
* CostOfMaterialsConsumed : double(20,2)
* PurchaseOfStockInTrade : double(20,2)
* PurchaseOfCrudeOilAndOthers : double(20,2)
* CostOfPowerPurchased : double(20,2)
* CostOfFuel : double(20,2)
* AircraftFuelExpenses : double(20,2)
* AircraftLeaseRentals : double(20,2)
* OperatingAndDirectExpenses : double(20,2)
* ChangesIninventoriesOfFGWIPAndStockInTrade : double(20,2)
* EmployeeBenefitExpenses : double(20,2)
* FinanceCosts : double(20,2)
* ProvisionsAndContingencies : double(20,2)
* DepreciationAndAmortisationExpenses : double(20,2)
* MiscExpensesWOff : double(20,2)
* OtherExpenses : double(20,2)
* LessInterUnitSegmentDivisionTransfer : double(20,2)
* LessTransferToFromInvestmentFixedAssetsOthers : double(20,2)
* LessAmountsTransferToCapitalAccounts : double(20,2)
* LessShareOfLossFromPartnershipFirm : double(20,2)
* TotalExpenses : double(20,2)
* ProfitLossBeforeExceptionalExtraOrdinaryItemsAndTax : double(20,2)
* ExceptionalItems : double(20,2)
* ProfitLossBeforeTax : double(20,2)
* CurrentTax : double(20,2)
* LessMATCredit : double(20,2)
* DeferredTax : double(20,2)
* OtherDirectTaxes : double(20,2)
* TaxForEarlierYears : double(20,2)
* TotalTaxExpensesContinuedOperations : double(20,2)
* ProfitLossAfterTaxAndBeforeExtraOrdinaryItems : double(20,2)
* PriorPeriodItems : double(20,2)
* ExtraordinaryItems : double(20,2)
* ProfitLossFromContinuingOperations : double(20,2)
* ProfitLossFromDiscontinuingOperations : double(20,2)
* TotalTaxExpensesDiscontinuingOperations : double(20,2)
* NetProfitLossFromDiscontinuingOperations : double(20,2)
* ProfitLossForThePeriod : double(20,2)
* EquityShares : double(20,2)
* EquityCapital : double(20,2)
* PreferenceCapital : double(20,2)
* TotalShareCapital : double(20,2)
* RevaluationReserves : double(20,2)
* ReservesAndSurplus : double(20,2)
* TotalReservesAndSurplus : double(20,2)
* MoneyAgainstShareWarrants : double(20,2)
* EmployeesStockOptions : double(20,2)
* TotalShareHoldersFunds : double(20,2)
* EquityShareApplicationMoney : double(20,2)
* PreferenceShareApplicationMoney : double(20,2)
* ShareCapitalSuspense : double(20,2)
* HybridDebtOtherSecurities : double(20,2)
* StatutoryConsumerReserves : double(20,2)
* SpecialApprnTowardsProjectCost : double(20,2)
* ServiceLineContributionFromConsumers : double(20,2)
* GovernmentOtherGrants : double(20,2)
* LongTermBorrowings : double(20,2)
* DeferredTaxLiabilities : double(20,2)
* OtherLongTermLiabilities : double(20,2)
* LongTermProvisions : double(20,2)
* TotalNonCurrentLiabilities : double(20,2)
* ForeignCurrencyMonetaryItemTranslationDifferenceLiabilityAccount : double(20,2)
* ShortTermBorrowings : double(20,2)
* TradePayables : double(20,2)
* OtherCurrentLiabilities : double(20,2)
* ShortTermProvisions : double(20,2)
* TotalCurrentLiabilities : double(20,2)
* TotalCapitalAndLiabilities : double(20,2)
* TangibleAssets : double(20,2)
* IntangibleAssets : double(20,2)
* CapitalWorkInProgress : double(20,2)
* IntangibleAssetsUnderDevelopment : double(20,2)
* OtherAssets : double(20,2)
* ConstructionStores : double(20,2)
* MiningDevelopmentExpenditure : double(20,2)
* AssetsHeldForSale : double(20,2)
* TotalFixedAssets : double(20,2)
* NonCurrentInvestments : double(20,2)
* DeferredTaxAssets : double(20,2)
* LongTermLoansAndAdvances : double(20,2)
* OtherNonCurrentAssets : double(20,2)
* TotalNonCurrentAssets : double(20,2)
* ForeignCurrencyMonetaryItemTranslationDiffAcct : double(20,2)
* CurrentInvestments : double(20,2)
* Inventories : double(20,2)
* TradeReceivables : double(20,2)
* CashAndCashEquivalents : double(20,2)
* ShortTermLoansAndAdvances : double(20,2)
* OtherCurrentAssets : double(20,2)
* TotalCurrentAssets : double(20,2)
* TotalAssets : double(20,2)
* NetProfitLossBeforeExtraordinaryItemsAndTax : double(20,2)
* NetCashFlowFromOperatingActivities : double(20,2)
* NetCashUsedInInvestingActivities : double(20,2)
* NetCashUsedFromFinancingActivities : double(20,2)
* ForeignExchangeGainsLosses : double(20,2)
* AdjustmentsOnAmalgamationMergerDemergerOthers : double(20,2)
* NetIncDecInCashAndCashEquivalents : double(20,2)
* CashAndCashEquivalentBeginOfYear : double(20,2)
* CashAndCashEquivalentEndOfYear : double(20,2)
* BasicEPS : double(20,2)
* DilutedEPS : double(20,2)
* ContingentLiabilities : double(20,2)
* CIFValueOfRawMaterials : double(20,2)
* CIFValueOfStoresSparesAndLooseTools : double(20,2)
* CIFValueOfOtherGoods : double(20,2)
* CIFValueOfCapitalGoods : double(20,2)
* ExpenditureInForeignCurrency : double(20,2)
* DividendRemittanceInForeignCurrency : double(20,2)
* ForeignExchangeFOB : double(20,2)
* ForeignExchangeOtherEarnings : double(20,2)
* ImportedRawMaterials : double(20,2)
* IndigenousRawMaterials : double(20,2)
* ImportedStoresAndSpares : double(20,2)
* IndigenousStoresAndSpares : double(20,2)
* EquityShareDividend : double(20,2)
* PreferenceShareDividend : double(20,2)
* TaxOnDividend : double(20,2)
* EquityDividendRate : double(20,2)
* BonusEquityShareCapital : double(20,2)
* NonCurrentInvestmentsQuotedMarketValue : double(20,2)
* NonCurrentInvestmentsUnquotedBookValue : double(20,2)
* CurrentInvestmentsQuotedMarketValue : double(20,2)
* CurrentInvestmentsUnquotedBookValue : double(20,2)
* ModifiedDate : varchar(40)
v NorenDionNewsData HalfYearlyResults
* CompanyCode : double(20,2)
* YearEnding : varchar(40)
* Months : int(10)
* Half : int(10)
* OperatingIncome : double(20,2)
* OtherOperatingIncome : double(20,2)
* TotalIncomeFromOperations : double(20,2)
* IntOrDiscOnAdvOrBills : double(20,2)
* IncomeOnInvestment : double(20,2)
* IntOnBalancesWithRBI : double(20,2)
* Others : double(20,2)
* OtherRecurringIncome : double(20,2)
* StockAdjustment : double(20,2)
* RawMaterialConsumed : double(20,2)
* PurchaseOfTradedGoods : double(20,2)
* PowerAndFuel : double(20,2)
* EmployeeExpenses : double(20,2)
* Excise : double(20,2)
* AdminAndSellingExpenses : double(20,2)
* ResearchAndDevlopmentExpenses : double(20,2)
* ExpensesCapitalised : double(20,2)
* OtherExpenses : double(20,2)
* PL_Before_OtherInc_Int_ExcpItem_Tax : double(20,2)
* PL_Before_Int_ExcpItem_Tax : double(20,2)
* InterestCharges : double(20,2)
* PL_Before_ExcpItem_Tax : double(20,2)
* ExceptionalItems : double(20,2)
* Depreciation : double(20,2)
* OperatingProfitBeforeProvisionsAndContingencies : double(20,2)
* BankProvisionsMade : double(20,2)
* PL_Before_Tax : double(20,2)
* TaxCharges : double(20,2)
* PL_After_TaxFromOrdineryActivities : double(20,2)
* ExtraOrdinaryItem : double(20,2)
* ReportedPAT : double(20,2)
* PriorYearAdj : double(20,2)
* ReservesWrittenBack : double(20,2)
* EquityCapital : double(20,2)
* ReservesAndSurplus : double(20,2)
* EqDividendRate : double(20,2)
* AggregateofNonPromotoNoOfShares : double(20,2)
* AggregateofNonPromotoHoldingPercent : double(20,2)
* GovernmentShare : double(20,2)
* CapitalAdequacyRatio : double(20,2)
* CapitalAdequacyBaseII : double(20,2)
* GrossNPA : double(20,2)
* NetNPA : double(20,2)
* Percentage_OfGrossNPA : double(20,2)
* Percentage_OfNetNPA : double(20,2)
* ReturnOnAssets_Per : double(20,2)
* BeforeBasicEPS : double(20,2)
* BeforeDilutedEPS : double(20,2)
* AfterBasicEPS : double(20,2)
* AfterDilutedEPS : double(20,2)
* En_NumberOfShares : double(20,2)
* En_Per_Share_As_Per_Of_Tot_Sh_Hol_of_Pro_And_Group : double(20,2)
* En_Per_Share_As_Per_Of_Tot_Sh_Cap_of_Company : double(20,2)
* NonEn_NumberOfShares : double(20,2)
* NonEn_Per_Share_As_Per_Of_Tot_Sh_Hol_of_Pro_And_Group : double(20,2)
* NonEn_Per_Share_As_Per_Of_Tot_Sh_Cap_of_Company : double(20,2)
* ModifiedDate : varchar(40)
v NorenDionNewsData IndustryMaster
* IndustryCode : int(10)
* IndustryName : varchar(256)
* BroadIndustryCode : int(10)
* BroadIndustryName : varchar(256)
* MajorSectorCode : int(10)
* MajorSectorName : varchar(256)
* ModifiedDate : varchar(40)
* DeleteFlag : int(1)
v NorenDionNewsData KeyExecutives
* CompanyCode : double(20,2)
* TitleDescription : varchar(40)
* ExecutiveName : varchar(100)
* DesignationDescription : varchar(100)
* ModifiedDate : varchar(40)
* RowId : int(10)
v NorenDionNewsData ListingMaster
* SecurityCode : varchar(40)
* ExchangeCode : int(10)
* ExchangeGroup : varchar(40)
* ScripCode1GivenByExchange : varchar(40)
* ScripCode2GivenByExchange : varchar(40)
* DateOfListing : varchar(40)
* DateOfDeListing : varchar(40)
* DateOfReEnlisting : varchar(40)
* FirstTradedDate : varchar(40)
* FirstTradedPrice : double(20,2)
* LastTradedDate : varchar(40)
* LastTradedPrice : double(20,2)
* FiftyTwoWeekHigh : double(20,2)
* FiftyTwoWeekLow : double(20,2)
* Highdate : varchar(40)
* Lowdate : varchar(40)
* CircuitLimit : int(10)
* ReasonForModification : varchar(256)
* DeleteFlag : int(1)
* ModifiedDate : varchar(40)
v NorenDionNewsData ManagementTeam
* CompanyCode : double(20,2)
* TitleDescription : varchar(40)
* PersonName : varchar(100)
* DesignationDescription : varchar(100)
* ModifiedDate : varchar(40)
* RowId : int(10)
v NorenDionNewsData News
* NewsId : int(10)
* DateTime : varchar(40)
* Headline : varchar(500)
* Category : varchar(100)
* CompanyCode : double(15,2)
* CompanyName : varchar(256)
* NewsText : varchar(10000)
v NorenDionNewsData NineMonthsResults
* CompanyCode : double(20,2)
* YearEnding : varchar(40)
* Months : int(10)
* Nine : int(10)
* OperatingIncome : double(20,2)
* OtherOperatingIncome : double(20,2)
* TotalIncomeFromOperations : double(20,2)
* IntOrDiscOnAdvOrBills : double(20,2)
* IncomeOnInvestment : double(20,2)
* IntOnBalancesWithRBI : double(20,2)
* Others : double(20,2)
* OtherRecurringIncome : double(20,2)
* StockAdjustment : double(20,2)
* RawMaterialConsumed : double(20,2)
* PurchaseOfTradedGoods : double(20,2)
* PowerAndFuel : double(20,2)
* EmployeeExpenses : double(20,2)
* Excise : double(20,2)
* AdminAndSellingExpenses : double(20,2)
* ResearchAndDevlopmentExpenses : double(20,2)
* ExpensesCapitalised : double(20,2)
* OtherExpenses : double(20,2)
* PL_Before_OtherInc_Int_ExcpItem_Tax : double(20,2)
* PL_Before_Int_ExcpItem_Tax : double(20,2)
* InterestCharges : double(20,2)
* PL_Before_ExcpItem_Tax : double(20,2)
* ExceptionalItems : double(20,2)
* Depreciation : double(20,2)
* OperatingProfitBeforeProvisionsAndContingencies : double(20,2)
* BankProvisionsMade : double(20,2)
* PL_Before_Tax : double(20,2)
* TaxCharges : double(20,2)
* PL_After_TaxFromOrdineryActivities : double(20,2)
* ExtraOrdinaryItem : double(20,2)
* ReportedPAT : double(20,2)
* PriorYearAdj : double(20,2)
* ReservesWrittenBack : double(20,2)
* EquityCapital : double(20,2)
* ReservesAndSurplus : double(20,2)
* EqDividendRate : double(20,2)
* AggregateofNonPromotoNoOfShares : double(20,2)
* AggregateofNonPromotoHoldingPercent : double(20,2)
* GovernmentShare : double(20,2)
* CapitalAdequacyRatio : double(20,2)
* CapitalAdequacyBaseII : double(20,2)
* GrossNPA : double(20,2)
* NetNPA : double(20,2)
* Percentage_OfGrossNPA : double(20,2)
* Percentage_OfNetNPA : double(20,2)
* ReturnOnAssets_Per : double(20,2)
* BeforeBasicEPS : double(20,2)
* BeforeDilutedEPS : double(20,2)
* AfterBasicEPS : double(20,2)
* AfterDilutedEPS : double(20,2)
* En_NumberOfShares : double(20,2)
* En_Per_Share_As_Per_Of_Tot_Sh_Hol_of_Pro_And_Group : double(20,2)
* En_Per_Share_As_Per_Of_Tot_Sh_Cap_of_Company : double(20,2)
* NonEn_NumberOfShares : double(20,2)
* NonEn_Per_Share_As_Per_Of_Tot_Sh_Hol_of_Pro_And_Group : double(20,2)
* NonEn_Per_Share_As_Per_Of_Tot_Sh_Cap_of_Company : double(20,2)
* ModifiedDate : varchar(40)
v NorenDionNewsData NseBseIndexConstituents
* IndexName : varchar(40)
* CompanyCode : double(20,2)
* ISINCode : varchar(40)
* Weightage : double(20,2)
* Exch : varchar(40)
v NorenDionNewsData QuarterlyResults
* CompanyCode : double(20,2)
* YearEnding : varchar(40)
* Months : int(10)
* Quarter : int(10)
* OperatingIncome : double(20,2)
* OtherOperatingIncome : double(20,2)
* TotalIncomeFromOperations : double(20,2)
* IntOrDiscOnAdvOrBills : double(20,2)
* IncomeOnInvestment : double(20,2)
* IntOnBalancesWithRBI : double(20,2)
* Others : double(20,2)
* OtherRecurringIncome : double(20,2)
* StockAdjustment : double(20,2)
* RawMaterialConsumed : double(20,2)
* PurchaseOfTradedGoods : double(20,2)
* PowerAndFuel : double(20,2)
* EmployeeExpenses : double(20,2)
* Excise : double(20,2)
* AdminAndSellingExpenses : double(20,2)
* ResearchAndDevlopmentExpenses : double(20,2)
* ExpensesCapitalised : double(20,2)
* OtherExpenses : double(20,2)
* PL_Before_OtherInc_Int_ExcpItem_Tax : double(20,2)
* PL_Before_Int_ExcpItem_Tax : double(20,2)
* InterestCharges : double(20,2)
* PL_Before_ExcpItem_Tax : double(20,2)
* ExceptionalItems : double(20,2)
* Depreciation : double(20,2)
* OperatingProfitBeforeProvisionsAndContingencies : double(20,2)
* BankProvisionsMade : double(20,2)
* PL_Before_Tax : double(20,2)
* TaxCharges : double(20,2)
* PL_After_TaxFromOrdineryActivities : double(20,2)
* ExtraOrdinaryItem : double(20,2)
* ReportedPAT : double(20,2)
* PriorYearAdj : double(20,2)
* ReservesWrittenBack : double(20,2)
* EquityCapital : double(20,2)
* ReservesAndSurplus : double(20,2)
* EqDividendRate : double(20,2)
* AggregateofNonPromotoNoOfShares : double(20,2)
* AggregateofNonPromotoHoldingPercent : double(20,2)
* GovernmentShare : double(20,2)
* CapitalAdequacyRatio : double(20,2)
* CapitalAdequacyBaseII : double(20,2)
* GrossNPA : double(20,2)
* NetNPA : double(20,2)
* Percentage_OfGrossNPA : double(20,2)
* Percentage_OfNetNPA : double(20,2)
* ReturnOnAssets_Per : double(20,2)
* BeforeBasicEPS : double(20,2)
* BeforeDilutedEPS : double(20,2)
* AfterBasicEPS : double(20,2)
* AfterDilutedEPS : double(20,2)
* En_NumberOfShares : double(20,2)
* En_Per_Share_As_Per_Of_Tot_Sh_Hol_of_Pro_And_Group : double(20,2)
* En_Per_Share_As_Per_Of_Tot_Sh_Cap_of_Company : double(20,2)
* NonEn_NumberOfShares : double(20,2)
* NonEn_Per_Share_As_Per_Of_Tot_Sh_Hol_of_Pro_And_Group : double(20,2)
* NonEn_Per_Share_As_Per_Of_Tot_Sh_Cap_of_Company : double(20,2)
* ModifiedDate : varchar(40)
v NorenDionNewsData RatiosBankingVI
* CompanyCode : double(20,2)
* YearEnding : varchar(40)
* Months : int(10)
* Type : varchar(10)
* FaceValue : double(20,2)
* BasicEPS : double(20,2)
* DilutedEPS : double(20,2)
* CashEPS : double(20,2)
* BVPerShareExclRevalReserve : double(20,2)
* BVPerShareInclRevalReserve : double(20,2)
* DividendPerShare : double(20,2)
* OperatingRevenuePerShare : double(20,2)
* NPPerShare : double(20,2)
* InterestIncomePerEmployee : double(20,2)
* NPPerEmployee : double(20,2)
* BusinessPerEmployee : double(20,2)
* InterestIncomePerBranch : double(20,2)
* NPPerBranches : double(20,2)
* BusinessPerBranches : double(20,2)
* NPM : double(20,2)
* OPM : double(20,2)
* ROA : double(20,2)
* ROE : double(20,2)
* NIM : double(20,2)
* CostToIncome : double(20,2)
* InterestIncomeByEarningAssets : double(20,2)
* NonInterestIncomeByEarningAssets : double(20,2)
* OperatingProfitByEarningAssets : double(20,2)
* OperatingExpensesByEarningAssets : double(20,2)
* InterestExpensesByEarningAssets : double(20,2)
* EnterpriseValue : double(20,2)
* EVPerNetSales : double(20,2)
* PriceToBV : double(20,2)
* PriceToSales : double(20,2)
* RetentionRatios : double(20,2)
* EarningsYield : double(20,2)
* ModifiedDate : varchar(40)
v NorenDionNewsData RatiosNonBankingVI
* CompanyCode : double(20,2)
* YearEnding : varchar(40)
* Months : int(10)
* Type : varchar(10)
* FaceValue : double(20,2)
* BasicEPS : double(20,2)
* DilutedEPS : double(20,2)
* CashEPS : double(20,2)
* BVPerShareExclRevalReserve : double(20,2)
* BVPerShareInclRevalReserve : double(20,2)
* DividendPerShare : double(20,2)
* OperatingRevenuePerShare : double(20,2)
* PBDITPerShare : double(20,2)
* PBITPerShare : double(20,2)
* PBTPerShare : double(20,2)
* NPperShare : double(20,2)
* PBDITMargin : double(20,2)
* PBITMargin : double(20,2)
* PBTMargin : double(20,2)
* NPMargin : double(20,2)
* RONW : double(20,2)
* ROCE : double(20,2)
* ReturnOnAssets : double(20,2)
* LongTermDebtEquity : double(20,2)
* DebtEquity : double(20,2)
* AssetTurnover : double(20,2)
* CurrentRatio : double(20,2)
* QuickRatio : double(20,2)
* InventoryTurnoverRatio : double(20,2)
* DividendPayoutNP : double(20,2)
* DividendPayoutCP : double(20,2)
* EarningRetention : double(20,2)
* CashEarningRetention : double(20,2)
* InterestCoverage : double(20,2)
* InterestCoveragePostTax : double(20,2)
* EnterpriseValue : double(20,2)
* EVPerNetSales : double(20,2)
* EVPerEBITDA : double(20,2)
* MarketCapPerSales : double(20,2)
* RetentionRatios : double(20,2)
* PriceToBV : double(20,2)
* PriceToSales : double(20,2)
* EarningsYield : double(20,2)
* ModifiedDate : varchar(40)
v NorenDionNewsData SecurityMaster
* CompanyCode : double(20,2)
* SecurityTypeCode : bigint(20)
* SecuritySubTypeCode : bigint(20)
* SerialNumber : int(10)
* SecurityCode : varchar(40)
* Ticker : varchar(40)
* IssuePrice : double(20,2)
* Description : varchar(200)
* DateOfIssue : varchar(40)
* DateOfExpiry : varchar(40)
* FaceValue : double(20,2)
* MarketLot : int(10)
* ISINCode : varchar(30)
* Remarks : varchar(500)
* ReasonForModification : varchar(256)
* IsItActiveSecurity : int(1)
* DeleteFlag : int(1)
* ModifiedDate : varchar(40)
v NorenDionNewsData ShareholdingDetails
* CompanyCode : double(12,2)
* HoldingDate : varchar(40)
* InstrumentDescription : varchar(50)
* Category : varchar(254)
* SubCategory : varchar(254)
* Level : varchar(254)
* ShareholderDescription : varchar(254)
* NoOfshareholders : bigint(20)
* FullyPaidUpShares : bigint(20)
* PartlyPaidUpShares : bigint(20)
* UnderlyingDR : bigint(20)
* TotalShares : bigint(20)
* PercentageSCRR : double(20,2)
* UnderlyingOutstandingConvertibleSecurities : bigint(20)
* PercentageFullConversionOfConvertibleSecurities : double(20,2)
* LockedSharesNos : bigint(20)
* LockedSharesPercentage : double(20,2)
* PledgeSharesNos : bigint(20)
* PledgeSharesPercentage : double(20,2)
* NoOfSharesDemat : bigint(20)
* NoOfVotingRightsClassX : bigint(20)
* NoOfVotingRightsClassY : bigint(20)
* NoOfVotingRightsTotal : bigint(20)
* NoOfVotingRightsPercentage : double(20,2)
* RowId : int(10)
* ModifiedDate : varchar(40)
创建关系
FOREIGN KEY
on delete
on update
删除关系