Database
  • Introduction
  • Database Design
    • Primary Tables
      • Accounts
      • Account Groups
      • Account Group History
      • Account Transaction History
      • Account Metrics Per Master Slave
      • Account Daily Return Detail
      • Account Introducer Map Log
      • Gateways
      • Gateway Components
      • Component-Gateway Mapping
      • Coverage Orders
      • Current Orders
      • Fund Fee Mapping
      • GlobalHealth Monitor
      • Master Fee Mapping
      • Master Broker Fee Mapping
      • Master Slave Mapping History
      • Slave Orders
      • Trade API GUID
    • Common Tables
      • Account Validation History
      • Account Group Asset Mapping
      • Application Log
      • Account Type
      • Account Transaction History For Deployment Server
      • ATT Operation
      • Activity Log
      • Account Group History
      • Account Metrics
      • Accounts History
      • ATT Trade Analysis
      • Auto Testing Logs
      • AT Configuration History
      • Application State Log
      • Account DD Audit
      • AT Instance History
      • Asset Class Type
      • Account Analytics
      • Account Equity
      • B-Book Qty Trades
      • Basket Slave Mapping
      • Basket Fund
      • Basket Master Mapping
      • Basket Cash Mapping
      • Basket Product Type
      • Broker Master Commission Mapping
      • Broker Asset Mapping
      • Basket Instrument Mapping
      • Calculation Mode
      • Currency
      • Connection State Log
      • Commission TS Security Mapping
      • Component Type
      • Current Orders Transactions
      • Commission Profile
      • Connection Setting
      • Copy Missed Reject Trades Request
      • Currency USD Conversion
      • Default Fee Setting History
      • Default Fee Setting
      • Deployment Servers
      • Database State Log
      • Error Codes
      • External Security
      • Errors Trade Analysis
      • External Internal Security Mapping
      • Fix Connection Settings
      • Fee Setting
      • Fund Type
      • Fee Type
      • Feed Server Connection Mapping
      • Group Type
      • Group Security Mapping
      • Gateway Connections
      • Gateway Type
      • HTCA Request
      • HM User Account
      • Health Monitor
      • HTCA Calculation Dump
      • Introducer Broker Mapping
      • Introducer Transaction History
      • Introducer Broker Deal Amount
      • Instruments
      • Index Accounts Mapping History
      • Introducer Rebate Profile Mapping
      • Index Accounts Mapping
      • Introducer
      • Interval
      • Introducer Multi-Level Proposal
      • Master Profit-Share Security Mapping
      • Master Slave Broker-Share Mapping
      • Master Feed Profile Mapping
      • Maintenance Logs
      • Master Profit-Share
      • Master Slave Account Mapping
      • Master Slave Mapping Snapshot
      • Mutual Fund Request
      • Mapping Allocation History
      • Manage Lots
      • Order Execution Type
      • Order Route To Gateway
      • Order Routing Trade History Table
      • Order Archive
      • Order Side
      • Order Status Types
      • Order Types
      • Participant Account Type
      • PHP Request Error Log
      • Platform
      • Risk Profile
      • Rebate Profile
      • Rebate Profile Security Mapping
      • Risk Profile Master Mapping
      • Revenues For Deployment Server
      • Server Symbol Mapping
      • Slave Orders
      • Start-Stop Copy Logs
      • Synced Orders
      • Settings
      • Swap Audit
      • Technical Support Levels
      • Trade Type
      • TS Security Global
      • TS Security Local Global Map
      • TS Security
      • Test Table
      • Trade Analysis
      • Trade History
      • Trades Synced With MySQL
      • TIF
      • User Profile
      • UDP Components
      • UDP Message Log
      • Validation Check Params
Powered by GitBook
On this page

Was this helpful?

  1. Database Design
  2. Primary Tables

Trade API GUID

The Trade API GUID table details the mapping between GUID and RHM. The fields for the Trade API GUID table are:

Table Name: TradeAPI_GUID

Column Name

Data Type

Valid Values

Allow Nulls

Description

PK_ID

int identity

No

GUID

varchar

No

FK_G_RHM_ID

int

No

PreviousSlave OrdersNextCommon Tables

Last updated 5 years ago

Was this helpful?