近期访问
`mysql`.`procs_priv`
`NorenDBCompanyData`.`AnnualStandaloneAggregateFinanceData`
`NorenDBCompanyData`.`HalfY_StandaloneBalanceSheet`
`NorenInstiVwap`.`TpNseDataOneMin`
`NorenDionNewsData`.`RatiosNonBankingVI`
`NorenDBCompanyData`.`IpoBioData`
`NorenTPDB`.`DeliveryPositions`
`NorenDBCompanyData`.`IpoSubscriptionData`
`NorenDBCompanyData`.`AnnualConsolidatedAggregateFinanceData`
`performance_schema`.`events_waits_history_long`
表收藏夹
`mysql`.`time_zone_transition`
新建
cm9vdA==.YWNjZXNzX2RhdGFfbWFyaWFkYg==
cm9vdA==.YWNjZXNzX2RhdGFfbWFyaWFkYg==
0
access_data_mariadb
cm9vdA==.Q2hhaW5z
cm9vdA==.Q2hhaW5z
0
Chains
cm9vdA==.RXhjaENvcnBEYXRh
cm9vdA==.RXhjaENvcnBEYXRh
0
ExchCorpData
cm9vdA==.RXhjaE5ld3NEYXRh
cm9vdA==.RXhjaE5ld3NEYXRh
0
ExchNewsData
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h
0
information_schema
cm9vdA==.TGljZW5zZUFwcA==
cm9vdA==.TGljZW5zZUFwcA==
0
LicenseApp
cm9vdA==.bXlzcWw=
cm9vdA==.bXlzcWw=
0
mysql
cm9vdA==.Tm9yZW5BY2NvcmRDb21hcG55RGF0YQ==
cm9vdA==.Tm9yZW5BY2NvcmRDb21hcG55RGF0YQ==
0
NorenAccordComapnyData
cm9vdA==.Tm9yZW5CbG9ja0Z1bmRzQVNCQQ==
cm9vdA==.Tm9yZW5CbG9ja0Z1bmRzQVNCQQ==
0
NorenBlockFundsASBA
cm9vdA==.Tm9yZW5EQg==
cm9vdA==.Tm9yZW5EQg==
0
NorenDB
cm9vdA==.Tm9yZW5EQkNvbXBhbnlEYXRh
cm9vdA==.Tm9yZW5EQkNvbXBhbnlEYXRh
0
NorenDBCompanyData
cm9vdA==.Tm9yZW5EQklwb0RhdGE=
cm9vdA==.Tm9yZW5EQklwb0RhdGE=
0
NorenDBIpoData
cm9vdA==.Tm9yZW5EaW9uTmV3c0RhdGE=
cm9vdA==.Tm9yZW5EaW9uTmV3c0RhdGE=
0
NorenDionNewsData
cm9vdA==.Tm9yZW5GZWVkRGF0YQ==
cm9vdA==.Tm9yZW5GZWVkRGF0YQ==
0
NorenFeedData
cm9vdA==.Tm9yZW5JbnN0aVZ3YXA=
cm9vdA==.Tm9yZW5JbnN0aVZ3YXA=
0
NorenInstiVwap
cm9vdA==.Tm9yZW5Mc05ld3M=
cm9vdA==.Tm9yZW5Mc05ld3M=
0
NorenLsNews
cm9vdA==.Tm9yZW5UUERC
cm9vdA==.Tm9yZW5UUERC
0
NorenTPDB
cm9vdA==.Tm9yZW5VcGxEQl90ZXN0
cm9vdA==.Tm9yZW5VcGxEQl90ZXN0
0
NorenUplDB_test
cm9vdA==.Tm9yZW5Vc2VyQXBpS2V5
cm9vdA==.Tm9yZW5Vc2VyQXBpS2V5
0
NorenUserApiKey
cm9vdA==.Tm9yZW5VdGlsZXNfdGVzdA==
cm9vdA==.Tm9yZW5VdGlsZXNfdGVzdA==
0
NorenUtiles_test
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h
0
performance_schema
cm9vdA==.cGhwbXlhZG1pbg==
cm9vdA==.cGhwbXlhZG1pbg==
0
phpmyadmin
cm9vdA==.dGVzdA==
cm9vdA==.dGVzdA==
0
test
导航面板
导航树
服务器
数据库
表
导航面板
自定义导航面板。
以树状显示数据库导航面板
导航栏使用数据库选择器替代树形列表
与主面板链接
高亮当前数据库或表链接到主面板。
显示徽标
在导航面板中显示图示。
徽标链接地址
导航面板中图示指向的链接地址。
徽标链接目标
在主窗口(
main
)或新窗口(
new
)打开目标页面。
main
new
启用高亮
高亮鼠标指针所在位置的服务器。
第一层节点的最大项数
每页导航树所能显示的第一层的最大项数。
显示筛选框的最少项数
设置达到多少个项(表、视图、程序和事件)时将显示筛选框。
最近使用的表
最近使用的表的最大数量;设为 0 为禁用。
表收藏夹
收藏表的最大数量;设为 0 为禁用。
导航面板宽度
设置为0以折叠导航面板。
导航树
自定义导航树。
节点中最大项数
每页导航树所能显示的最大项数。
分组树中的项
将导航树中的项分组(根据上面 数据库与数据表 页面设置的分隔符分组)。
启用表导航条展开功能
是否允许在导航栏中展开导航树。
在导航树显示表
在导航树是否在数据库下显示数据表节点
在导航树显示视图
在导航树中是否在数据库下显示视图节点
在导航树显示函数
是否显示导航树中数据库下级功能
在导航树显示进程
是否在导航树中显示数据库进程
在导航树显示事件
在导航树中数据库下是否显示事件节点
展开单个数据库
是否自动在导航树中展开单个数据库。
服务器
服务器显示选项。
显示服务器选择
在导航面板顶部显示可选的服务器。
列表显示服务器
直接显示服务器列表而不使用下拉框。
数据库
数据库显示选项。
设置达到多少个数据库时将显示数据库筛选框
数据库树分隔符
将数据库分为不同层级的字符串。
表
表显示选项。
快速访问图标的目标
结构
SQL
搜索
插入
浏览
第二快速访问图标的目标页面
结构
SQL
搜索
插入
浏览
表树分隔符
将表分为不同层级的字符串。
表树最大深度
将文件拖动至此
SQL 上传 (
0
)
x
-
该处必须启用 Javascript!
服务器: localhost
»
数据库: NorenUplDB_test
结构
SQL
搜索
查询
导出
导入
操作
权限
程序
事件
触发器
追踪
设计器
文本框列
控制台
清除
历史
选项
书签
调试 SQL
按 Ctrl+Enter 键执行查询
按 Enter 执行查询
递增排序
递减排序
命令:
调试 SQL
数量
运行顺序
用时
排序条件:
联合查询
不使用联合查询
崩溃
扩展
显示跟踪
隐藏跟踪
数量
用时
书签
刷新
添加
没有书签
添加书签
标签:
目标数据库:
共享和谐书签
确定
选项
恢复默认
总是扩展查询消息
在开始时显示查询历史
显示当前浏览查询
浏览设置,使按Shift+Enter键执行输入和插入新行作为永久设置。
切换到黑色主题
崩溃
扩展
重新查询
编辑
解析
性能分析
书签
查询失败
数据库 :
查询时间 :
多表查询
通过示例查询
切换到
可视化查询生成器
搜索已经保存的书签:
新建书签
字段:
`ClientDealerMapping`.*
`ClientDealerMapping`.`SlNo`
`ClientDealerMapping`.`UserId`
`ClientDealerMapping`.`AccountId`
`ClientDealerMapping`.`Validated`
`ClientDealerMapping`.`ValidationText`
`ClientDealerMapping`.`DtTime`
`HoldingsWithCollateralQty`.*
`HoldingsWithCollateralQty`.`SlNo`
`HoldingsWithCollateralQty`.`AccountId`
`HoldingsWithCollateralQty`.`BSEScripcode`
`HoldingsWithCollateralQty`.`NSESymbol`
`HoldingsWithCollateralQty`.`NSESeries`
`HoldingsWithCollateralQty`.`MCX_SX_EQ_Symbol`
`HoldingsWithCollateralQty`.`MCX_SX_EQ_Series`
`HoldingsWithCollateralQty`.`ISINCode`
`HoldingsWithCollateralQty`.`Holdings_Qty`
`HoldingsWithCollateralQty`.`ISCollateral`
`HoldingsWithCollateralQty`.`EvaluationMethod`
`HoldingsWithCollateralQty`.`CollateralQty`
`HoldingsWithCollateralQty`.`Haircut`
`HoldingsWithCollateralQty`.`CollateralUpdateQty`
`HoldingsWithCollateralQty`.`HoldingUpdateQty`
`HoldingsWithCollateralQty`.`CLosingPrice`
`HoldingsWithCollateralQty`.`WithheldHoldQty`
`HoldingsWithCollateralQty`.`WithheldCollQty`
`HoldingsWithCollateralQty`.`Product`
`HoldingsWithCollateralQty`.`TargetProduct`
`HoldingsWithCollateralQty`.`AddOrIncr`
`HoldingsWithCollateralQty`.`Validated`
`HoldingsWithCollateralQty`.`ValidationText`
`HoldingsWithCollateralQty`.`DtTime`
`HoldingsWithCollateralQty`.`BORefStr`
`InvestorClient`.*
`InvestorClient`.`SlNo`
`InvestorClient`.`AccountId`
`InvestorClient`.`AccountName`
`InvestorClient`.`UserId`
`InvestorClient`.`BranchId`
`InvestorClient`.`Password`
`InvestorClient`.`TransactionPassword`
`InvestorClient`.`EmailID`
`InvestorClient`.`ResidenceAddr`
`InvestorClient`.`OfficeAddr`
`InvestorClient`.`OfficePhoneNo`
`InvestorClient`.`CellNo`
`InvestorClient`.`FamilyId`
`InvestorClient`.`DPId`
`InvestorClient`.`DPName`
`InvestorClient`.`DPAccountNo`
`InvestorClient`.`DecimalPreference`
`InvestorClient`.`PanNumber`
`InvestorClient`.`ClientType`
`InvestorClient`.`BankAccountNo`
`InvestorClient`.`MICRNumber`
`InvestorClient`.`BankName`
`InvestorClient`.`BankAddress`
`InvestorClient`.`ClientStatus`
`InvestorClient`.`ClientRMSCategory`
`InvestorClient`.`UserRoleName`
`InvestorClient`.`ClientType2`
`InvestorClient`.`UserAccessType`
`InvestorClient`.`MarketWatchCount`
`InvestorClient`.`MarketWatchScripCount`
`InvestorClient`.`DPAccountType`
`InvestorClient`.`Depository`
`InvestorClient`.`UserRights`
`InvestorClient`.`BrokerId`
`InvestorClient`.`ProductsEnabled`
`InvestorClient`.`BankAccountNo2`
`InvestorClient`.`BankName2`
`InvestorClient`.`BankAddress2`
`InvestorClient`.`BankAccountNo3`
`InvestorClient`.`BankName3`
`InvestorClient`.`BankAddress3`
`InvestorClient`.`AutoPwdReset`
`InvestorClient`.`AutoTransactionPwdReset`
`InvestorClient`.`AccountCustId`
`InvestorClient`.`ClientDOB`
`InvestorClient`.`2FAEnabled`
`InvestorClient`.`ResetAnswerFlag`
`InvestorClient`.`UserStatus`
`InvestorClient`.`AddOrModify`
`InvestorClient`.`Validated`
`InvestorClient`.`ValidationText`
`InvestorClient`.`DtTime`
`InvestorClient`.`mail_sms_event`
`InvestorClient`.`mail_sms_frequency`
`InvestorClient`.`mailsms_event`
`InvestorClient`.`AccountType`
`InvestorClient`.`BranchName`
`InvestorClient`.`CustomerId`
`InvestorClient`.`GENDER`
`InvestorClient`.`OCCUPATION`
`InvestorClient`.`TaxStatus`
`InvestorClient`.`KYCcomplaint`
`InvestorClient`.`CITY`
`InvestorClient`.`STATE`
`InvestorClient`.`PINCODE`
`InvestorClient`.`PreferredDiv`
`InvestorClient`.`PaymentMechanismCODE`
`InvestorClient`.`GuardianDOB`
`InvestorClient`.`GuardianName`
`InvestorClient`.`GuardianPANNo`
`InvestorClient`.`StatementCommunicationMode`
`InvestorClient`.`MobileNo`
`InvestorClient`.`ARNNo`
`InvestorClient`.`ResidencePhoneNo`
`InvestorClient`.`DPAcctNo2`
`InvestorClient`.`DPAcctNo3`
`InvestorClient`.`DPAcctNo4`
`InvestorClient`.`DPAcctNo5`
`InvestorClient`.`DPAcctNo6`
`InvestorClient`.`BankBranchName2`
`InvestorClient`.`BankBranchName3`
`InvestorClient`.`BankName4`
`InvestorClient`.`BankBranchName4`
`InvestorClient`.`BankAccountNumber4`
`InvestorClient`.`BankAddress4`
`InvestorClient`.`BankName5`
`InvestorClient`.`BankBranchName5`
`InvestorClient`.`BankAccountNumber5`
`InvestorClient`.`BankAddress5`
`InvestorClient`.`BankName6`
`InvestorClient`.`BankBranchName6`
`InvestorClient`.`BankAccountNumber6`
`InvestorClient`.`BankAddress6`
`InvestorClient`.`EnableSOR`
`InvestorClient`.`LoginSequence`
`InvestorClient`.`ExposureLimit`
`InvestorClient`.`TurnoverLimit`
`InvestorClient`.`GrossExposureDerivativeLimit`
`InvestorClientProductsEnable`.*
`InvestorClientProductsEnable`.`SlNo`
`InvestorClientProductsEnable`.`UserId`
`InvestorClientProductsEnable`.`AccountId`
`InvestorClientProductsEnable`.`Products`
`InvestorClientProductsEnable`.`Validated`
`InvestorClientProductsEnable`.`ValidationText`
`InvestorClientProductsEnable`.`DtTime`
`InvestorClientSegmentEnable`.*
`InvestorClientSegmentEnable`.`SlNo`
`InvestorClientSegmentEnable`.`UserId`
`InvestorClientSegmentEnable`.`AccountId`
`InvestorClientSegmentEnable`.`Segment`
`InvestorClientSegmentEnable`.`ExchangeUserId`
`InvestorClientSegmentEnable`.`ExpiryDate`
`InvestorClientSegmentEnable`.`ExchangeUserInfo`
`InvestorClientSegmentEnable`.`EnabledFlag`
`InvestorClientSegmentEnable`.`Validated`
`InvestorClientSegmentEnable`.`ValidationText`
`InvestorClientSegmentEnable`.`DtTime`
`RMSCategoryAssign`.*
`RMSCategoryAssign`.`SlNo`
`RMSCategoryAssign`.`Level`
`RMSCategoryAssign`.`AccountId`
`RMSCategoryAssign`.`Category_name`
`RMSCategoryAssign`.`Exchange`
`RMSCategoryAssign`.`Segment`
`RMSCategoryAssign`.`Product`
`RMSCategoryAssign`.`Validated`
`RMSCategoryAssign`.`ValidationText`
`RMSCategoryAssign`.`DtTime`
`RMSCategoryAssign`.`ExpLimit`
`RMSCategoryAssign`.`TurnoverLimit`
`RMSCategoryAssign`.`GrossExpoDerivativeLimit`
`SchedRMSAdHocUpdates`.*
`SchedRMSAdHocUpdates`.`SlNo`
`SchedRMSAdHocUpdates`.`AccountId`
`SchedRMSAdHocUpdates`.`AdHocMargin`
`SchedRMSAdHocUpdates`.`NotionalCash`
`SchedRMSAdHocUpdates`.`BCastStatus`
`SchedRMSAdHocUpdates`.`DtTime`
`SchedRMSAdHocUpdates`.`Exchange`
`SchedRMSAdHocUpdates`.`Segment`
`SchedRMSAdHocUpdates`.`Broker`
`SchedRMSAdHocUpdates`.`COMNRMLAdHocMarginCOMNRMLAdHocMargin`
`SchedRMSAdHocUpdates`.`COMMISAdHocMargin`
`SchedRMSAdHocUpdates`.`CollateralValue`
`SchedRMSAdHocUpdates`.`CURNRMLAdHocMargin`
`SchedRMSAdHocUpdates`.`CURMISAdHocMargin`
`SchedRMSAdHocUpdates`.`OPTNRMLAdHoc`
`SchedRMSAdHocUpdates`.`OPTMISAdHoc`
`SchedRMSAdHocUpdates`.`CUROPTNRMLAdHoc`
`SchedRMSAdHocUpdates`.`CUROPTMISAdHoc`
`SchedRMSAdHocUpdates`.`CASHNRMLAdHocMargin`
`SchedRMSAdHocUpdates`.`CASHMISAdHocMargin`
`SchedRMSAdHocUpdates`.`CASHCNCAdHocMargin`
`SchedRMSAdHocUpdates`.`FONRMLAdHocMargin`
`SchedRMSAdHocUpdates`.`FOMISAdHocMargin`
`SchedRMSAdHocUpdates`.`Product`
`SchedRMSAdHocUpdates`.`BORefStr`
`SchedRMSAdHocUpdates`.`SourceUser`
`SchedRMSAdHocUpdates`.`RMSCollateral`
`SchedRMSAdHocUpdates`.`RemarksText`
`SchedRMSAdHocUpdates`.`RemarksAmount`
`SchedRMSPayInOutUpdates`.*
`SchedRMSPayInOutUpdates`.`SlNo`
`SchedRMSPayInOutUpdates`.`UserId`
`SchedRMSPayInOutUpdates`.`AccountId`
`SchedRMSPayInOutUpdates`.`Exchange`
`SchedRMSPayInOutUpdates`.`Segment`
`SchedRMSPayInOutUpdates`.`Product`
`SchedRMSPayInOutUpdates`.`Amount`
`SchedRMSPayInOutUpdates`.`Validated`
`SchedRMSPayInOutUpdates`.`ValidationText`
`SchedRMSPayInOutUpdates`.`DtTime`
`SchedRMSPayInOutUpdates`.`BORefStr`
`SchedRMSUpdates`.*
`SchedRMSUpdates`.`SlNo`
`SchedRMSUpdates`.`AccountId`
`SchedRMSUpdates`.`Exchange`
`SchedRMSUpdates`.`Segment`
`SchedRMSUpdates`.`Symbol`
`SchedRMSUpdates`.`Product`
`SchedRMSUpdates`.`Amount`
`SchedRMSUpdates`.`Validated`
`SchedRMSUpdates`.`ValidationText`
`SchedRMSUpdates`.`DtTime`
`SchedRMSUpdates`.`Broker`
`SchedRMSUpdates`.`BORefStr`
`SchedRMSUpdates`.`SourceUser`
`UserApiKeys`.*
`UserApiKeys`.`SlNo`
`UserApiKeys`.`VendorCode`
`UserApiKeys`.`ApiKey`
`UserApiKeys`.`ExpiryDate`
`UserApiKeys`.`Validated`
`UserApiKeys`.`ValidationText`
`UserApiKeys`.`DtTime`
`UserApiKeys`.`UserId`
`ClientDealerMapping`.*
`ClientDealerMapping`.`SlNo`
`ClientDealerMapping`.`UserId`
`ClientDealerMapping`.`AccountId`
`ClientDealerMapping`.`Validated`
`ClientDealerMapping`.`ValidationText`
`ClientDealerMapping`.`DtTime`
`HoldingsWithCollateralQty`.*
`HoldingsWithCollateralQty`.`SlNo`
`HoldingsWithCollateralQty`.`AccountId`
`HoldingsWithCollateralQty`.`BSEScripcode`
`HoldingsWithCollateralQty`.`NSESymbol`
`HoldingsWithCollateralQty`.`NSESeries`
`HoldingsWithCollateralQty`.`MCX_SX_EQ_Symbol`
`HoldingsWithCollateralQty`.`MCX_SX_EQ_Series`
`HoldingsWithCollateralQty`.`ISINCode`
`HoldingsWithCollateralQty`.`Holdings_Qty`
`HoldingsWithCollateralQty`.`ISCollateral`
`HoldingsWithCollateralQty`.`EvaluationMethod`
`HoldingsWithCollateralQty`.`CollateralQty`
`HoldingsWithCollateralQty`.`Haircut`
`HoldingsWithCollateralQty`.`CollateralUpdateQty`
`HoldingsWithCollateralQty`.`HoldingUpdateQty`
`HoldingsWithCollateralQty`.`CLosingPrice`
`HoldingsWithCollateralQty`.`WithheldHoldQty`
`HoldingsWithCollateralQty`.`WithheldCollQty`
`HoldingsWithCollateralQty`.`Product`
`HoldingsWithCollateralQty`.`TargetProduct`
`HoldingsWithCollateralQty`.`AddOrIncr`
`HoldingsWithCollateralQty`.`Validated`
`HoldingsWithCollateralQty`.`ValidationText`
`HoldingsWithCollateralQty`.`DtTime`
`HoldingsWithCollateralQty`.`BORefStr`
`InvestorClient`.*
`InvestorClient`.`SlNo`
`InvestorClient`.`AccountId`
`InvestorClient`.`AccountName`
`InvestorClient`.`UserId`
`InvestorClient`.`BranchId`
`InvestorClient`.`Password`
`InvestorClient`.`TransactionPassword`
`InvestorClient`.`EmailID`
`InvestorClient`.`ResidenceAddr`
`InvestorClient`.`OfficeAddr`
`InvestorClient`.`OfficePhoneNo`
`InvestorClient`.`CellNo`
`InvestorClient`.`FamilyId`
`InvestorClient`.`DPId`
`InvestorClient`.`DPName`
`InvestorClient`.`DPAccountNo`
`InvestorClient`.`DecimalPreference`
`InvestorClient`.`PanNumber`
`InvestorClient`.`ClientType`
`InvestorClient`.`BankAccountNo`
`InvestorClient`.`MICRNumber`
`InvestorClient`.`BankName`
`InvestorClient`.`BankAddress`
`InvestorClient`.`ClientStatus`
`InvestorClient`.`ClientRMSCategory`
`InvestorClient`.`UserRoleName`
`InvestorClient`.`ClientType2`
`InvestorClient`.`UserAccessType`
`InvestorClient`.`MarketWatchCount`
`InvestorClient`.`MarketWatchScripCount`
`InvestorClient`.`DPAccountType`
`InvestorClient`.`Depository`
`InvestorClient`.`UserRights`
`InvestorClient`.`BrokerId`
`InvestorClient`.`ProductsEnabled`
`InvestorClient`.`BankAccountNo2`
`InvestorClient`.`BankName2`
`InvestorClient`.`BankAddress2`
`InvestorClient`.`BankAccountNo3`
`InvestorClient`.`BankName3`
`InvestorClient`.`BankAddress3`
`InvestorClient`.`AutoPwdReset`
`InvestorClient`.`AutoTransactionPwdReset`
`InvestorClient`.`AccountCustId`
`InvestorClient`.`ClientDOB`
`InvestorClient`.`2FAEnabled`
`InvestorClient`.`ResetAnswerFlag`
`InvestorClient`.`UserStatus`
`InvestorClient`.`AddOrModify`
`InvestorClient`.`Validated`
`InvestorClient`.`ValidationText`
`InvestorClient`.`DtTime`
`InvestorClient`.`mail_sms_event`
`InvestorClient`.`mail_sms_frequency`
`InvestorClient`.`mailsms_event`
`InvestorClient`.`AccountType`
`InvestorClient`.`BranchName`
`InvestorClient`.`CustomerId`
`InvestorClient`.`GENDER`
`InvestorClient`.`OCCUPATION`
`InvestorClient`.`TaxStatus`
`InvestorClient`.`KYCcomplaint`
`InvestorClient`.`CITY`
`InvestorClient`.`STATE`
`InvestorClient`.`PINCODE`
`InvestorClient`.`PreferredDiv`
`InvestorClient`.`PaymentMechanismCODE`
`InvestorClient`.`GuardianDOB`
`InvestorClient`.`GuardianName`
`InvestorClient`.`GuardianPANNo`
`InvestorClient`.`StatementCommunicationMode`
`InvestorClient`.`MobileNo`
`InvestorClient`.`ARNNo`
`InvestorClient`.`ResidencePhoneNo`
`InvestorClient`.`DPAcctNo2`
`InvestorClient`.`DPAcctNo3`
`InvestorClient`.`DPAcctNo4`
`InvestorClient`.`DPAcctNo5`
`InvestorClient`.`DPAcctNo6`
`InvestorClient`.`BankBranchName2`
`InvestorClient`.`BankBranchName3`
`InvestorClient`.`BankName4`
`InvestorClient`.`BankBranchName4`
`InvestorClient`.`BankAccountNumber4`
`InvestorClient`.`BankAddress4`
`InvestorClient`.`BankName5`
`InvestorClient`.`BankBranchName5`
`InvestorClient`.`BankAccountNumber5`
`InvestorClient`.`BankAddress5`
`InvestorClient`.`BankName6`
`InvestorClient`.`BankBranchName6`
`InvestorClient`.`BankAccountNumber6`
`InvestorClient`.`BankAddress6`
`InvestorClient`.`EnableSOR`
`InvestorClient`.`LoginSequence`
`InvestorClient`.`ExposureLimit`
`InvestorClient`.`TurnoverLimit`
`InvestorClient`.`GrossExposureDerivativeLimit`
`InvestorClientProductsEnable`.*
`InvestorClientProductsEnable`.`SlNo`
`InvestorClientProductsEnable`.`UserId`
`InvestorClientProductsEnable`.`AccountId`
`InvestorClientProductsEnable`.`Products`
`InvestorClientProductsEnable`.`Validated`
`InvestorClientProductsEnable`.`ValidationText`
`InvestorClientProductsEnable`.`DtTime`
`InvestorClientSegmentEnable`.*
`InvestorClientSegmentEnable`.`SlNo`
`InvestorClientSegmentEnable`.`UserId`
`InvestorClientSegmentEnable`.`AccountId`
`InvestorClientSegmentEnable`.`Segment`
`InvestorClientSegmentEnable`.`ExchangeUserId`
`InvestorClientSegmentEnable`.`ExpiryDate`
`InvestorClientSegmentEnable`.`ExchangeUserInfo`
`InvestorClientSegmentEnable`.`EnabledFlag`
`InvestorClientSegmentEnable`.`Validated`
`InvestorClientSegmentEnable`.`ValidationText`
`InvestorClientSegmentEnable`.`DtTime`
`RMSCategoryAssign`.*
`RMSCategoryAssign`.`SlNo`
`RMSCategoryAssign`.`Level`
`RMSCategoryAssign`.`AccountId`
`RMSCategoryAssign`.`Category_name`
`RMSCategoryAssign`.`Exchange`
`RMSCategoryAssign`.`Segment`
`RMSCategoryAssign`.`Product`
`RMSCategoryAssign`.`Validated`
`RMSCategoryAssign`.`ValidationText`
`RMSCategoryAssign`.`DtTime`
`RMSCategoryAssign`.`ExpLimit`
`RMSCategoryAssign`.`TurnoverLimit`
`RMSCategoryAssign`.`GrossExpoDerivativeLimit`
`SchedRMSAdHocUpdates`.*
`SchedRMSAdHocUpdates`.`SlNo`
`SchedRMSAdHocUpdates`.`AccountId`
`SchedRMSAdHocUpdates`.`AdHocMargin`
`SchedRMSAdHocUpdates`.`NotionalCash`
`SchedRMSAdHocUpdates`.`BCastStatus`
`SchedRMSAdHocUpdates`.`DtTime`
`SchedRMSAdHocUpdates`.`Exchange`
`SchedRMSAdHocUpdates`.`Segment`
`SchedRMSAdHocUpdates`.`Broker`
`SchedRMSAdHocUpdates`.`COMNRMLAdHocMarginCOMNRMLAdHocMargin`
`SchedRMSAdHocUpdates`.`COMMISAdHocMargin`
`SchedRMSAdHocUpdates`.`CollateralValue`
`SchedRMSAdHocUpdates`.`CURNRMLAdHocMargin`
`SchedRMSAdHocUpdates`.`CURMISAdHocMargin`
`SchedRMSAdHocUpdates`.`OPTNRMLAdHoc`
`SchedRMSAdHocUpdates`.`OPTMISAdHoc`
`SchedRMSAdHocUpdates`.`CUROPTNRMLAdHoc`
`SchedRMSAdHocUpdates`.`CUROPTMISAdHoc`
`SchedRMSAdHocUpdates`.`CASHNRMLAdHocMargin`
`SchedRMSAdHocUpdates`.`CASHMISAdHocMargin`
`SchedRMSAdHocUpdates`.`CASHCNCAdHocMargin`
`SchedRMSAdHocUpdates`.`FONRMLAdHocMargin`
`SchedRMSAdHocUpdates`.`FOMISAdHocMargin`
`SchedRMSAdHocUpdates`.`Product`
`SchedRMSAdHocUpdates`.`BORefStr`
`SchedRMSAdHocUpdates`.`SourceUser`
`SchedRMSAdHocUpdates`.`RMSCollateral`
`SchedRMSAdHocUpdates`.`RemarksText`
`SchedRMSAdHocUpdates`.`RemarksAmount`
`SchedRMSPayInOutUpdates`.*
`SchedRMSPayInOutUpdates`.`SlNo`
`SchedRMSPayInOutUpdates`.`UserId`
`SchedRMSPayInOutUpdates`.`AccountId`
`SchedRMSPayInOutUpdates`.`Exchange`
`SchedRMSPayInOutUpdates`.`Segment`
`SchedRMSPayInOutUpdates`.`Product`
`SchedRMSPayInOutUpdates`.`Amount`
`SchedRMSPayInOutUpdates`.`Validated`
`SchedRMSPayInOutUpdates`.`ValidationText`
`SchedRMSPayInOutUpdates`.`DtTime`
`SchedRMSPayInOutUpdates`.`BORefStr`
`SchedRMSUpdates`.*
`SchedRMSUpdates`.`SlNo`
`SchedRMSUpdates`.`AccountId`
`SchedRMSUpdates`.`Exchange`
`SchedRMSUpdates`.`Segment`
`SchedRMSUpdates`.`Symbol`
`SchedRMSUpdates`.`Product`
`SchedRMSUpdates`.`Amount`
`SchedRMSUpdates`.`Validated`
`SchedRMSUpdates`.`ValidationText`
`SchedRMSUpdates`.`DtTime`
`SchedRMSUpdates`.`Broker`
`SchedRMSUpdates`.`BORefStr`
`SchedRMSUpdates`.`SourceUser`
`UserApiKeys`.*
`UserApiKeys`.`SlNo`
`UserApiKeys`.`VendorCode`
`UserApiKeys`.`ApiKey`
`UserApiKeys`.`ExpiryDate`
`UserApiKeys`.`Validated`
`UserApiKeys`.`ValidationText`
`UserApiKeys`.`DtTime`
`UserApiKeys`.`UserId`
`ClientDealerMapping`.*
`ClientDealerMapping`.`SlNo`
`ClientDealerMapping`.`UserId`
`ClientDealerMapping`.`AccountId`
`ClientDealerMapping`.`Validated`
`ClientDealerMapping`.`ValidationText`
`ClientDealerMapping`.`DtTime`
`HoldingsWithCollateralQty`.*
`HoldingsWithCollateralQty`.`SlNo`
`HoldingsWithCollateralQty`.`AccountId`
`HoldingsWithCollateralQty`.`BSEScripcode`
`HoldingsWithCollateralQty`.`NSESymbol`
`HoldingsWithCollateralQty`.`NSESeries`
`HoldingsWithCollateralQty`.`MCX_SX_EQ_Symbol`
`HoldingsWithCollateralQty`.`MCX_SX_EQ_Series`
`HoldingsWithCollateralQty`.`ISINCode`
`HoldingsWithCollateralQty`.`Holdings_Qty`
`HoldingsWithCollateralQty`.`ISCollateral`
`HoldingsWithCollateralQty`.`EvaluationMethod`
`HoldingsWithCollateralQty`.`CollateralQty`
`HoldingsWithCollateralQty`.`Haircut`
`HoldingsWithCollateralQty`.`CollateralUpdateQty`
`HoldingsWithCollateralQty`.`HoldingUpdateQty`
`HoldingsWithCollateralQty`.`CLosingPrice`
`HoldingsWithCollateralQty`.`WithheldHoldQty`
`HoldingsWithCollateralQty`.`WithheldCollQty`
`HoldingsWithCollateralQty`.`Product`
`HoldingsWithCollateralQty`.`TargetProduct`
`HoldingsWithCollateralQty`.`AddOrIncr`
`HoldingsWithCollateralQty`.`Validated`
`HoldingsWithCollateralQty`.`ValidationText`
`HoldingsWithCollateralQty`.`DtTime`
`HoldingsWithCollateralQty`.`BORefStr`
`InvestorClient`.*
`InvestorClient`.`SlNo`
`InvestorClient`.`AccountId`
`InvestorClient`.`AccountName`
`InvestorClient`.`UserId`
`InvestorClient`.`BranchId`
`InvestorClient`.`Password`
`InvestorClient`.`TransactionPassword`
`InvestorClient`.`EmailID`
`InvestorClient`.`ResidenceAddr`
`InvestorClient`.`OfficeAddr`
`InvestorClient`.`OfficePhoneNo`
`InvestorClient`.`CellNo`
`InvestorClient`.`FamilyId`
`InvestorClient`.`DPId`
`InvestorClient`.`DPName`
`InvestorClient`.`DPAccountNo`
`InvestorClient`.`DecimalPreference`
`InvestorClient`.`PanNumber`
`InvestorClient`.`ClientType`
`InvestorClient`.`BankAccountNo`
`InvestorClient`.`MICRNumber`
`InvestorClient`.`BankName`
`InvestorClient`.`BankAddress`
`InvestorClient`.`ClientStatus`
`InvestorClient`.`ClientRMSCategory`
`InvestorClient`.`UserRoleName`
`InvestorClient`.`ClientType2`
`InvestorClient`.`UserAccessType`
`InvestorClient`.`MarketWatchCount`
`InvestorClient`.`MarketWatchScripCount`
`InvestorClient`.`DPAccountType`
`InvestorClient`.`Depository`
`InvestorClient`.`UserRights`
`InvestorClient`.`BrokerId`
`InvestorClient`.`ProductsEnabled`
`InvestorClient`.`BankAccountNo2`
`InvestorClient`.`BankName2`
`InvestorClient`.`BankAddress2`
`InvestorClient`.`BankAccountNo3`
`InvestorClient`.`BankName3`
`InvestorClient`.`BankAddress3`
`InvestorClient`.`AutoPwdReset`
`InvestorClient`.`AutoTransactionPwdReset`
`InvestorClient`.`AccountCustId`
`InvestorClient`.`ClientDOB`
`InvestorClient`.`2FAEnabled`
`InvestorClient`.`ResetAnswerFlag`
`InvestorClient`.`UserStatus`
`InvestorClient`.`AddOrModify`
`InvestorClient`.`Validated`
`InvestorClient`.`ValidationText`
`InvestorClient`.`DtTime`
`InvestorClient`.`mail_sms_event`
`InvestorClient`.`mail_sms_frequency`
`InvestorClient`.`mailsms_event`
`InvestorClient`.`AccountType`
`InvestorClient`.`BranchName`
`InvestorClient`.`CustomerId`
`InvestorClient`.`GENDER`
`InvestorClient`.`OCCUPATION`
`InvestorClient`.`TaxStatus`
`InvestorClient`.`KYCcomplaint`
`InvestorClient`.`CITY`
`InvestorClient`.`STATE`
`InvestorClient`.`PINCODE`
`InvestorClient`.`PreferredDiv`
`InvestorClient`.`PaymentMechanismCODE`
`InvestorClient`.`GuardianDOB`
`InvestorClient`.`GuardianName`
`InvestorClient`.`GuardianPANNo`
`InvestorClient`.`StatementCommunicationMode`
`InvestorClient`.`MobileNo`
`InvestorClient`.`ARNNo`
`InvestorClient`.`ResidencePhoneNo`
`InvestorClient`.`DPAcctNo2`
`InvestorClient`.`DPAcctNo3`
`InvestorClient`.`DPAcctNo4`
`InvestorClient`.`DPAcctNo5`
`InvestorClient`.`DPAcctNo6`
`InvestorClient`.`BankBranchName2`
`InvestorClient`.`BankBranchName3`
`InvestorClient`.`BankName4`
`InvestorClient`.`BankBranchName4`
`InvestorClient`.`BankAccountNumber4`
`InvestorClient`.`BankAddress4`
`InvestorClient`.`BankName5`
`InvestorClient`.`BankBranchName5`
`InvestorClient`.`BankAccountNumber5`
`InvestorClient`.`BankAddress5`
`InvestorClient`.`BankName6`
`InvestorClient`.`BankBranchName6`
`InvestorClient`.`BankAccountNumber6`
`InvestorClient`.`BankAddress6`
`InvestorClient`.`EnableSOR`
`InvestorClient`.`LoginSequence`
`InvestorClient`.`ExposureLimit`
`InvestorClient`.`TurnoverLimit`
`InvestorClient`.`GrossExposureDerivativeLimit`
`InvestorClientProductsEnable`.*
`InvestorClientProductsEnable`.`SlNo`
`InvestorClientProductsEnable`.`UserId`
`InvestorClientProductsEnable`.`AccountId`
`InvestorClientProductsEnable`.`Products`
`InvestorClientProductsEnable`.`Validated`
`InvestorClientProductsEnable`.`ValidationText`
`InvestorClientProductsEnable`.`DtTime`
`InvestorClientSegmentEnable`.*
`InvestorClientSegmentEnable`.`SlNo`
`InvestorClientSegmentEnable`.`UserId`
`InvestorClientSegmentEnable`.`AccountId`
`InvestorClientSegmentEnable`.`Segment`
`InvestorClientSegmentEnable`.`ExchangeUserId`
`InvestorClientSegmentEnable`.`ExpiryDate`
`InvestorClientSegmentEnable`.`ExchangeUserInfo`
`InvestorClientSegmentEnable`.`EnabledFlag`
`InvestorClientSegmentEnable`.`Validated`
`InvestorClientSegmentEnable`.`ValidationText`
`InvestorClientSegmentEnable`.`DtTime`
`RMSCategoryAssign`.*
`RMSCategoryAssign`.`SlNo`
`RMSCategoryAssign`.`Level`
`RMSCategoryAssign`.`AccountId`
`RMSCategoryAssign`.`Category_name`
`RMSCategoryAssign`.`Exchange`
`RMSCategoryAssign`.`Segment`
`RMSCategoryAssign`.`Product`
`RMSCategoryAssign`.`Validated`
`RMSCategoryAssign`.`ValidationText`
`RMSCategoryAssign`.`DtTime`
`RMSCategoryAssign`.`ExpLimit`
`RMSCategoryAssign`.`TurnoverLimit`
`RMSCategoryAssign`.`GrossExpoDerivativeLimit`
`SchedRMSAdHocUpdates`.*
`SchedRMSAdHocUpdates`.`SlNo`
`SchedRMSAdHocUpdates`.`AccountId`
`SchedRMSAdHocUpdates`.`AdHocMargin`
`SchedRMSAdHocUpdates`.`NotionalCash`
`SchedRMSAdHocUpdates`.`BCastStatus`
`SchedRMSAdHocUpdates`.`DtTime`
`SchedRMSAdHocUpdates`.`Exchange`
`SchedRMSAdHocUpdates`.`Segment`
`SchedRMSAdHocUpdates`.`Broker`
`SchedRMSAdHocUpdates`.`COMNRMLAdHocMarginCOMNRMLAdHocMargin`
`SchedRMSAdHocUpdates`.`COMMISAdHocMargin`
`SchedRMSAdHocUpdates`.`CollateralValue`
`SchedRMSAdHocUpdates`.`CURNRMLAdHocMargin`
`SchedRMSAdHocUpdates`.`CURMISAdHocMargin`
`SchedRMSAdHocUpdates`.`OPTNRMLAdHoc`
`SchedRMSAdHocUpdates`.`OPTMISAdHoc`
`SchedRMSAdHocUpdates`.`CUROPTNRMLAdHoc`
`SchedRMSAdHocUpdates`.`CUROPTMISAdHoc`
`SchedRMSAdHocUpdates`.`CASHNRMLAdHocMargin`
`SchedRMSAdHocUpdates`.`CASHMISAdHocMargin`
`SchedRMSAdHocUpdates`.`CASHCNCAdHocMargin`
`SchedRMSAdHocUpdates`.`FONRMLAdHocMargin`
`SchedRMSAdHocUpdates`.`FOMISAdHocMargin`
`SchedRMSAdHocUpdates`.`Product`
`SchedRMSAdHocUpdates`.`BORefStr`
`SchedRMSAdHocUpdates`.`SourceUser`
`SchedRMSAdHocUpdates`.`RMSCollateral`
`SchedRMSAdHocUpdates`.`RemarksText`
`SchedRMSAdHocUpdates`.`RemarksAmount`
`SchedRMSPayInOutUpdates`.*
`SchedRMSPayInOutUpdates`.`SlNo`
`SchedRMSPayInOutUpdates`.`UserId`
`SchedRMSPayInOutUpdates`.`AccountId`
`SchedRMSPayInOutUpdates`.`Exchange`
`SchedRMSPayInOutUpdates`.`Segment`
`SchedRMSPayInOutUpdates`.`Product`
`SchedRMSPayInOutUpdates`.`Amount`
`SchedRMSPayInOutUpdates`.`Validated`
`SchedRMSPayInOutUpdates`.`ValidationText`
`SchedRMSPayInOutUpdates`.`DtTime`
`SchedRMSPayInOutUpdates`.`BORefStr`
`SchedRMSUpdates`.*
`SchedRMSUpdates`.`SlNo`
`SchedRMSUpdates`.`AccountId`
`SchedRMSUpdates`.`Exchange`
`SchedRMSUpdates`.`Segment`
`SchedRMSUpdates`.`Symbol`
`SchedRMSUpdates`.`Product`
`SchedRMSUpdates`.`Amount`
`SchedRMSUpdates`.`Validated`
`SchedRMSUpdates`.`ValidationText`
`SchedRMSUpdates`.`DtTime`
`SchedRMSUpdates`.`Broker`
`SchedRMSUpdates`.`BORefStr`
`SchedRMSUpdates`.`SourceUser`
`UserApiKeys`.*
`UserApiKeys`.`SlNo`
`UserApiKeys`.`VendorCode`
`UserApiKeys`.`ApiKey`
`UserApiKeys`.`ExpiryDate`
`UserApiKeys`.`Validated`
`UserApiKeys`.`ValidationText`
`UserApiKeys`.`DtTime`
`UserApiKeys`.`UserId`
别名:
显示:
排序:
递增
递减
递增
递减
递增
递减
排序规则:
1
2
3
1
2
3
1
2
3
条件:
插入:
且:
删除:
或:
修改:
或:
且:
插入
删除
或:
且:
插入
删除
插入
删除
添加/删除标准行:
-3
-2
-1
0
1
2
3
添加/删除字段:
-3
-2
-1
0
1
2
3
使用表
ClientDealerMapping
HoldingsWithCollateralQty
InvestorClient
InvestorClientProductsEnable
InvestorClientSegmentEnable
RMSCategoryAssign
SchedRMSAdHocUpdates
SchedRMSPayInOutUpdates
SchedRMSUpdates
UserApiKeys
在数据库
NorenUplDB_test
执行 SQL 语句: