diff options
| -rw-r--r-- | sql/dawn.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 8c6f4e44..5626b5e7 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -3953,3 +3953,9 @@ CREATE TABLE cash_balances ( balance float8 NULL, CONSTRAINT cash_balances_pkey PRIMARY KEY (date, account_number, currency_code) ); + +CREATE TYPE priced_at_market_discounting_reference_rate_t AS enum('1-month LIBOR','SOFR'); +CREATE TYPE priced_at_market_ccf_engine_t AS enum('btm','serenitas'); +CREATE TYPE beta_estimates_bond_type_t AS enum('FCF','pre-COVID LCF','post-COVID LCF','pre-SSRA B1','pre-COVID SSRA B1','early post-COVID B1','2021 non-5-year-call B1','5-year call B1','pre-COVID OGB and B2','early post-COVID B2','2021 non-5-year-call B2','5-year call B2','IO'); +CREATE TYPE bond_types_bond_type_t AS enum('FCF','pre-COVID LCF','post-COVID LCF','pre-SSRA B1','pre-COVID SSRA B1','early post-COVID B1','early post-COVID B2','2021 non-5-year-call B2','2021 non-5-year-call B1','5-year call B1','5-year call B2','pre-COVID OGB and B2','IO'); +IMPORT FOREIGN SCHEMA crt LIMIT TO (priced_at_market, map_cusip, bond_types, beta_estimates) FROM SERVER mysql_server INTO public; |