diff options
| -rw-r--r-- | sql/dawn.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 5626b5e7..1636d9cd 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -3959,3 +3959,12 @@ 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; + +CREATE TABLE bbh_infuse_upload( + id int4 NOT NULL GENERATED ALWAYS AS IDENTITY, + tradeid int NOT NULL, + cusip int NOT NULL, + principal decimal NOT NULL, + interest decimal NOT NULL, + CONSTRAINT unique_upload_check UNIQUE (tradeid, cusip, principal, interest) + );
\ No newline at end of file |