diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/serenitasdb.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql index b2a8660b..d9d31a1c 100644 --- a/sql/serenitasdb.sql +++ b/sql/serenitasdb.sql @@ -513,7 +513,8 @@ CREATE TABLE swaption_quotes( gamma float,
tail float,
quote_source varchar(4),
- PRIMARY KEY(quotedate, index, series, expiry, strike))
+ PRIMARY KEY(quotedate, index, series, expiry, strike),
+ FOREIGN KEY(quotedate, index, series, expiry) REFERENCES swaption_ref_quotes)
CREATE TABLE swaption_ref_quotes(
quotedate timestamptz,
|