* id accountName pan aadhar mobileNo notes created_at updated_at

* setting_key setting_value updated_at

* id name email phone PASSWORD

* id username password_hash google_email google_sub google_name is_active is_admin created_at last_login_at

* id exchangeSegment securityId tradingSymbol rootSymbol multiplier source rawJson updated_at

* id exchangeSegment securityId tradingSymbol ltp previousClose openPrice highPrice lowPrice source feedTime updated_at

* id dhanClientId correlationId transacttype exchange producttype ordertype validity tradingSymbol securityId Quantity disclosedQuantity price triggerPrice afterMarketOrder chartid InstrumentType Strategy strategyBasketId strategyBasketCode akey strikestep drvStrikePrice multiplier created_at dhanOrderId dhanStatus orderStatus executedPrice exchangeTransactionId orderSource requestReceivedAt orderStoredAt dhanSendAt dhanAckAt dbSaveMs dhanAckMs totalAckMs statusCheckMs preSendMs tokenRefreshMs orderRetryCount rawPayload apiResponse amoTime portfolioId

* id tradeKey portfolioId dhanClientId accountName dhanOrderId tradeId exchangeTradeId exchangeOrderId tradingSymbol securityId exchangeSegment transactionType productType orderType tradedQuantity tradedPrice tradeValue tradeTime source rawJson created_at updated_at

* id brokerid name pan token maxriskopt maxriskeq capital akey totp perorderlimit pin maxinvperday maxscript minprofitpct token_generated_at

* id portfolioId dhanClientId accountName tradingSymbol securityId exchangeSegment productType side closedQty buyAvg sellAvg pnl pnlPct multiplier closedAt rawJson updated_at

* id portfolioId dhanClientId accountName tradingSymbol securityId exchangeSegment productType positionType netQty avgPrice ltp pnl pnlPct multiplier rawJson feedTime updated_at

* SEM_EXM_EXCH_ID SEM_SEGMENT SEM_SMST_SECURITY_ID SEM_INSTRUMENT_NAME SEM_EXPIRY_CODE SEM_TRADING_SYMBOL SEM_LOT_UNITS SEM_CUSTOM_SYMBOL SEM_EXPIRY_DATE SEM_STRIKE_PRICE SEM_OPTION_TYPE SEM_TICK_SIZE SEM_EXPIRY_FLAG SEM_EXCH_INSTRUMENT_TYPE SEM_SERIES SM_SYMBOL_NAME

* SEM_EXM_EXCH_ID SEM_SEGMENT SEM_SMST_SECURITY_ID SEM_INSTRUMENT_NAME SEM_EXPIRY_CODE SEM_TRADING_SYMBOL SEM_LOT_UNITS SEM_CUSTOM_SYMBOL SEM_EXPIRY_DATE SEM_STRIKE_PRICE SEM_OPTION_TYPE SEM_TICK_SIZE SEM_EXPIRY_FLAG SEM_EXCH_INSTRUMENT_TYPE SEM_SERIES SM_SYMBOL_NAME

* id basket_code strategy_code portfolioId dhanClientId accountName basket_name strategy_type underlying_symbol exchangeSegment status max_profit max_loss auto_squareoff expiry_date notes created_at closed_at updated_at

* id basket_id strategy_code source_type source_table source_id portfolioId dhanClientId tradingSymbol securityId exchangeSegment side productType quantity entry_price exit_price status linked_at

* id strategy_code strategy_name strategy_type max_scripts max_investment_per_script max_investment_per_day max_loss_per_day max_open_trades max_trade_value allow_short allow_intraday sl_tp_required is_active created_at updated_at

* id status pid started_at heartbeat_at stop_requested last_message updated_at

* job_key job_name enabled interval_seconds last_run_at next_run_at last_status last_message last_duration_ms locked_until created_at updated_at

* id stage remote_ip raw_body payload_json context_json created_at

* id status attempts remote_ip raw_body received_at response_code response_json last_error created_at updated_at processed_at

select table account_master app_settings customers dashboard_users instrument_multipliers market_feed_prices ordertb order_trades portfoliotb portfolio_closed_positions_snapshot portfolio_positions_snapshot script_tb script_tb_backup strategy_baskets strategy_basket_legs strategy_master system_sync_daemon system_sync_jobs webhook_alerts webhook_jobs . select column
Show

criteria

Sort	Ascending	Descending
Add as	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	Text Another column
	select table account_master app_settings customers dashboard_users instrument_multipliers market_feed_prices ordertb order_trades portfoliotb portfolio_closed_positions_snapshot portfolio_positions_snapshot script_tb script_tb_backup strategy_baskets strategy_basket_legs strategy_master system_sync_daemon system_sync_jobs webhook_alerts webhook_jobs .	select column