diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 215 |
1 files changed, 215 insertions, 0 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index d33c737f..5306ea7f 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -2840,3 +2840,218 @@ LEFT JOIN index_maturity_markit imm ON (a.SECURITY_id, a.maturity) = (imm.redind end; $function$ ; + +CREATE TABLE public.fx_tickets ( + bbg_ticket_id text NOT NULL, + "Message Type" text NULL, + "Deal Type" text NULL, + "Side" text NULL, + "Product" text NULL, + "Trans Type" text NULL, + "Revision Version" text NULL, + "Trade ID" text NULL, + "Batch ID" text NULL, + "Trader Deal Code" text NULL, + "Trader UUID" text NULL, + "Trader Name" text NULL, + "Counterparty UUID" text NULL, + "Counterparty Trader Name" text NULL, + "Date Of Deal" text NULL, + "Time Of Deal" text NULL, + "Trade Date" text NULL, + "Date Confirmed" text NULL, + "Time Confirmed" text NULL, + "Counterparty Deal Code" text NULL, + "Counterparty Name" text NULL, + "User Identifier 1" text NULL, + "User Identifier 2" text NULL, + "User Identifier 3" text NULL, + "User Identifier 4" text NULL, + "Currency 1" text NULL, + "Currency 2" text NULL, + "Amount Dealt" text NULL, + "Dealt Currency" text NULL, + "Counter Amount" text NULL, + "Counter Currency" text NULL, + "Forward Points Near" text NULL, + "Far Amount Dealt" text NULL, + "Far Currency Dealt" text NULL, + "Far Counter Amount" text NULL, + "Far Counter Currency" text NULL, + "Forward Points Far" text NULL, + "Spot Basis Rate" text NULL, + "Deposit Rate" text NULL, + "Day Count Type" text NULL, + "New or Roll" text NULL, + "Volume Of Interest" text NULL, + "Exchange Rate Period 1" text NULL, + "Value Date Period 1 Currency 1" text NULL, + "Tenor Period 1" text NULL, + "Fixing Date Period 1" text NULL, + "Fixing Source Period 1" text NULL, + "Settle Currency" text NULL, + "Swap Rate" text NULL, + "Exchange Rate Period 2" text NULL, + "Value Date Period 2 Currency 1" text NULL, + "Tenor Period 2" text NULL, + "Fixing Date Period 2" text NULL, + "Fixing Source Period 2" text NULL, + "Split Tenor Currency 1" text NULL, + "Split Value Date Currency 1" text NULL, + "Split Tenor Currency 2" text NULL, + "Split Value Date Currency 2" text NULL, + "Comment Text" text NULL, + "Note Name 1" text NULL, + "Note Text 1" text NULL, + "Note Name 2" text NULL, + "Note Text 2" text NULL, + "Note Name 3" text NULL, + "Note Text 3" text NULL, + "Note Name 4" text NULL, + "Note Text 4" text NULL, + "Note Name 5" text NULL, + "Note Text 5" text NULL, + "Comp Quote 1" text NULL, + "Comp Deal Code 1" text NULL, + "Supplementary Cost 1" text NULL, + "Comp Quote 2" text NULL, + "Comp Deal Code 2" text NULL, + "Supplementary Cost 2" text NULL, + "Comp Quote 3" text NULL, + "Comp Deal Code 3" text NULL, + "Supplementary Cost 3" text NULL, + "Comp Quote 4" text NULL, + "Comp Deal Code 4" text NULL, + "Supplementary Cost 4" text NULL, + "Comp Quote 5" text NULL, + "Comp Deal Code 5" text NULL, + "Supplementary Cost 5" text NULL, + "Buyer Near Trader UUID" text NULL, + "Buyer Near Deal Code" text NULL, + "Seller Near Trader UUID" text NULL, + "Seller Near Deal Code" text NULL, + "Buyer Far Trader UUID" text NULL, + "Buyer Far Deal Code" text NULL, + "Seller Far Trader UUID" text NULL, + "Seller Far Deal Code" text NULL, + "Broker Trader UUID" text NULL, + "Broker Deal Code" text NULL, + "Broker Name" text NULL, + "Portfolio" text NULL, + "ALOC Account 1" text NULL, + "ALOC Amount 1" text NULL, + "ALOC Direction 1" text NULL, + "ALOC Custodian 1" text NULL, + "ALOC Prime Broker 1" text NULL, + "ALOC Account 2" text NULL, + "ALOC Amount 2" text NULL, + "ALOC Direction 2" text NULL, + "ALOC Custodian 2" text NULL, + "ALOC Prime Broker 2" text NULL, + "ALOC Account 3" text NULL, + "ALOC Amount 3" text NULL, + "ALOC Direction 3" text NULL, + "ALOC Custodian 3" text NULL, + "ALOC Prime Broker 3" text NULL, + "ALOC Account 4" text NULL, + "ALOC Amount 4" text NULL, + "ALOC Direction 4" text NULL, + "ALOC Custodian 4" text NULL, + "ALOC Prime Broker 4" text NULL, + "ALOC Account 5" text NULL, + "ALOC Amount 5" text NULL, + "ALOC Direction 5" text NULL, + "ALOC Custodian 5" text NULL, + "ALOC Prime Broker 5" text NULL, + "ALOC Account 6" text NULL, + "ALOC Amount 6" text NULL, + "ALOC Direction 6" text NULL, + "ALOC Custodian 6" text NULL, + "ALOC Prime Broker 6" text NULL, + "ALOC Account 7" text NULL, + "ALOC Amount 7" text NULL, + "ALOC Direction 7" text NULL, + "ALOC Custodian 7" text NULL, + "ALOC Prime Broker 7" text NULL, + "ALOC Account 8" text NULL, + "ALOC Amount 8" text NULL, + "ALOC Direction 8" text NULL, + "ALOC Custodian 8" text NULL, + "ALOC Prime Broker 8" text NULL, + "ALOC Account 9" text NULL, + "ALOC Amount 9" text NULL, + "ALOC Direction 9" text NULL, + "ALOC Custodian 9" text NULL, + "ALOC Prime Broker 9" text NULL, + "ALOC Account 10" text NULL, + "ALOC Amount 10" text NULL, + "ALOC Direction 10" text NULL, + "ALOC Custodian 10" text NULL, + "ALOC Prime Broker 10" text NULL, + "Reference Spot Rate" text NULL, + "Reference Rate Period 1" text NULL, + "Reference Rate Period 2" text NULL, + "Pay Currency" text NULL, + "Pay SWIFT Code" text NULL, + "Pay Account Number" text NULL, + "Pay Bank" text NULL, + "Pay Branch" text NULL, + "Pay Beneficiary" text NULL, + "Pay Special Instructions" text NULL, + "Receiving Currency" text NULL, + "Receiving SWIFT Code" text NULL, + "Receiving Account Number" text NULL, + "Receiving Bank" text NULL, + "Receiving Branch" text NULL, + "Receiving Beneficiary" text NULL, + "Receiving Special Instructions" text NULL, + "Spot Rate Mid" text NULL, + "All-in Rate Near Leg Mid" text NULL, + "Near Leg Forward Point Mid" text NULL, + "All-in Rate Far Leg Mid" text NULL, + "Far Leg Forward Point Mid" text NULL, + "USI Namespace" text NULL, + "USI ID" text NULL, + "USI ID Near" text NULL, + "USI ID Swap" text NULL, + "Delivery Date" text NULL, + "Banknote Rate Type" text NULL, + "Commission" text NULL, + "Order Type Name" text NULL, + "Order Strategy Name" text NULL, + "Execution Venue MIC" text NULL, + "Market Segment ID" text NULL, + "Group ID" text NULL, + "Group Type" text NULL, + "Trade Method" text NULL, + "Execution Method" text NULL, + "Sub Type" text NULL, + "Supplementary Sub Type" text NULL, + "External Reference ID" text NULL, + "Execution Venue LEI" text NULL, + "ISIN Near" text NULL, + "ISIN Far" text NULL, + "ISIN Swap" text NULL, + "Execution within Firm Algo ID" text NULL, + "Execution within Firm GPI" text NULL, + "Execution within Firm Identifier" text NULL, + "Investment Decision within Firm Algo ID" text NULL, + "Investment Decision within Firm GPI" text NULL, + "Investment Decision within Firm Short Code" text NULL, + "Trading Capacity" text NULL, + "Package ID" text NULL, + "Pre-Trade Transparency Type" text NULL, + "Pre-Trade Transparency Reason" text NULL, + "Post-Trade Transparency Type" text NULL, + "Post-Trade Transparency Reason" text NULL, + "Commodities Derivative Indicator" text NULL, + "Securities Financing Transaction" text NULL, + "Maker Algo ID" text NULL, + "Ord Reg Timestamp" text NULL, + "Ord Reg Timestamp Type" text NULL, + "Trd Reg Timestamp" text NULL, + "Trd Reg Timestamp Type" text NULL, + "Trade Reporting Indicator" text NULL, + "Country of Membership" text NULL, + CONSTRAINT fx_tickets_pk PRIMARY KEY (bbg_ticket_id) +);
\ No newline at end of file |