diff options
Diffstat (limited to 'sql/serenitasdb.sql')
| -rw-r--r-- | sql/serenitasdb.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql index cdf769c2..446777af 100644 --- a/sql/serenitasdb.sql +++ b/sql/serenitasdb.sql @@ -225,3 +225,13 @@ CREATE OR REPLACE FUNCTION curve_quotes_fmt(varchar(4), date) RETURNS ON b.curve_ticker = a.curve_ticker GROUP by company_id ORDER BY t;
END;
$$ LANGUAGE plpgsql;
+
+CREATE TABLE index_quotes(
+ Date date,
+ Index index_type,
+ Series smallint,
+ Version smallint,
+ Tenor tenor,
+ Price float,
+ Spread float
+ PRIMARY KEY(Date, Index, Series, Tenor));
|