diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/serenitasdb.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql index bb136c39..79b11fd8 100644 --- a/sql/serenitasdb.sql +++ b/sql/serenitasdb.sql @@ -871,3 +871,10 @@ CREATE OR REPLACE VIEW public.on_the_run AS FROM index_quotes
WHERE index_quotes.tenor = '5yr'::tenor
ORDER BY index_quotes.date, index_quotes.index, index_quotes.series DESC, index_quotes.version;
+
+
+CREATE TABLE defaulted(
+ id integer REFERENCES bbg_issuers(company_id) PRIMARY KEY,
+ event_date date,
+ auction_date date,
+ recovery float)
|