diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/quantifi.sql | 34 |
1 files changed, 17 insertions, 17 deletions
diff --git a/sql/quantifi.sql b/sql/quantifi.sql index 838baa4a..1191c589 100644 --- a/sql/quantifi.sql +++ b/sql/quantifi.sql @@ -1,4 +1,4 @@ -CREATE TABLE qf_bespokes ( +CREATE TABLE bespokes ( "date" date NOT NULL, "row" int8 NOT NULL, tradeid text NULL, @@ -16,7 +16,7 @@ CREATE TABLE qf_bespokes ( CONSTRAINT qf_bespokes_pk PRIMARY KEY (date, "row") ); -CREATE TABLE qf_bondbetas ( +CREATE TABLE bondbetas ( "date" date NOT NULL, "row" int8 NOT NULL, productname text NULL, @@ -26,7 +26,7 @@ CREATE TABLE qf_bondbetas ( CONSTRAINT qf_bondbetas_pk PRIMARY KEY (date, "row") ); -CREATE TABLE qf_bonds ( +CREATE TABLE bonds ( "date" date NOT NULL, "row" int8 NOT NULL, productname text NULL, @@ -46,7 +46,7 @@ CREATE TABLE qf_bonds ( CONSTRAINT qf_bonds_pk PRIMARY KEY (date, "row") ); -CREATE TABLE qf_cdx ( +CREATE TABLE cdx ( "date" date NOT NULL, "row" int8 NOT NULL, productname text NULL, @@ -66,7 +66,7 @@ CREATE TABLE qf_cdx ( CONSTRAINT qf_cdx_pk PRIMARY KEY (date, "row") ); -CREATE TABLE qf_cdxoption ( +CREATE TABLE cdxoption ( "date" date NOT NULL, "row" int8 NOT NULL, productname text NULL, @@ -89,7 +89,7 @@ CREATE TABLE qf_cdxoption ( CONSTRAINT qf_cdxoption_pk PRIMARY KEY (date, "row") ); -CREATE TABLE qf_cdxqf ( +CREATE TABLE cdxqf ( "date" date NOT NULL, "row" int8 NOT NULL, tradeid text NULL, @@ -113,7 +113,7 @@ CREATE TABLE qf_cdxqf ( CONSTRAINT qf_cdxqf_pk PRIMARY KEY (date, "row") ); -CREATE TABLE qf_cdxtranche ( +CREATE TABLE cdxtranche ( "date" date NOT NULL, "row" int8 NOT NULL, productname text NULL, @@ -135,7 +135,7 @@ CREATE TABLE qf_cdxtranche ( CONSTRAINT qf_cdxtranche_pk PRIMARY KEY (date, "row") ); -CREATE TABLE qf_fxforwards ( +CREATE TABLE fxforwards ( "date" date NOT NULL, "row" int8 NOT NULL, tradeid text NULL, @@ -149,7 +149,7 @@ CREATE TABLE qf_fxforwards ( CONSTRAINT qf_fxforwards_pk PRIMARY KEY (date, "row") ); -CREATE TABLE qf_hvardata ( +CREATE TABLE hvardata ( "date" date NOT NULL, "row" text NOT NULL, tradeid text NULL, @@ -161,7 +161,7 @@ CREATE TABLE qf_hvardata ( CONSTRAINT qf_hvardata_pk PRIMARY KEY (date, "row") ); -CREATE TABLE qf_hvardatacdxoptions ( +CREATE TABLE hvardatacdxoptions ( "date" date NOT NULL, "row" int8 NOT NULL, tradeid text NULL, @@ -173,7 +173,7 @@ CREATE TABLE qf_hvardatacdxoptions ( CONSTRAINT qf_hvardatacdxoptions_pk PRIMARY KEY (date, "row") ); -CREATE TABLE qf_indicatives ( +CREATE TABLE indicatives ( "date" date NOT NULL, "row" int8 NOT NULL, productname text NULL, @@ -188,7 +188,7 @@ CREATE TABLE qf_indicatives ( CONSTRAINT qf_indicatives_pk PRIMARY KEY (date, "row") ); -CREATE TABLE qf_jtd ( +CREATE TABLE jtd ( "date" date NOT NULL, "row" int8 NOT NULL, referenceentity_longname text NULL, @@ -200,7 +200,7 @@ CREATE TABLE qf_jtd ( CONSTRAINT qf_jtd_pk PRIMARY KEY (date, "row") ); -CREATE TABLE qf_pnlexplainbytrade ( +CREATE TABLE pnlexplainbytrade ( "date" date NOT NULL, "row" int8 NOT NULL, tradeid text NULL, @@ -249,7 +249,7 @@ CREATE TABLE qf_pnlexplainbytrade ( CONSTRAINT qf_pnlexplainbytrade_pk PRIMARY KEY (date, "row") ); -CREATE TABLE qf_proxies ( +CREATE TABLE proxies ( "date" date NOT NULL, "row" int8 NOT NULL, tradeid text NULL, @@ -264,7 +264,7 @@ CREATE TABLE qf_proxies ( CONSTRAINT qf_proxies_pk PRIMARY KEY (date, "row") ); -CREATE TABLE qf_ratefutures ( +CREATE TABLE ratefutures ( "date" date NOT NULL, "row" text NOT NULL, bookingentity_name text NULL, @@ -277,7 +277,7 @@ CREATE TABLE qf_ratefutures ( CONSTRAINT qf_ratefutures_pk PRIMARY KEY (date, "row") ); -CREATE TABLE qf_sensitivities ( +CREATE TABLE sensitivities ( "date" date NOT NULL, "row" int8 NOT NULL, tradeid text NULL, @@ -304,7 +304,7 @@ CREATE TABLE qf_sensitivities ( CONSTRAINT qf_sensitivities_pk PRIMARY KEY (date, "row") ); -CREATE TABLE qf_swaptions ( +CREATE TABLE swaptions ( "date" date NOT NULL, "row" int8 NOT NULL, tradeid text NULL, |