diff options
Diffstat (limited to 'sql/serenitasdb.sql')
| -rw-r--r-- | sql/serenitasdb.sql | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql index 25b70504..45ddaa36 100644 --- a/sql/serenitasdb.sql +++ b/sql/serenitasdb.sql @@ -824,6 +824,29 @@ CREATE TABLE EUR_rates( "25Y" real,
"30Y" real);
+CREATE TABLE JPY_rates(
+ effective_date date PRIMARY KEY,
+ "1M" real,
+ "2M" real,
+ "3M" real,
+ "6M" real,
+ "9M" real,
+ "1Y" real,
+ "2Y" real,
+ "3Y" real,
+ "4Y" real,
+ "5Y" real,
+ "6Y" real,
+ "7Y" real,
+ "8Y" real,
+ "9Y" real,
+ "10Y" real,
+ "12Y" real,
+ "15Y" real,
+ "20Y" real,
+ "25Y" real,
+ "30Y" real);
+
CREATE TABLE USD_curves(
effective_date date PRIMARY KEY,
curve bytea);
@@ -832,6 +855,10 @@ CREATE TABLE EUR_curves( effective_date date PRIMARY KEY,
curve bytea);
+CREATE TABLE JPY_curves(
+ effective_date date PRIMARY KEY,
+ curve bytea);
+
CREATE TABLE USD_swap_fixings(
fixing_date date PRIMARY KEY,
"1y" numeric(5, 3),
|