1 files changed, 1 insertions, 1 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql
index 358acf85..7afa1e54 100644
--- a/sql/serenitasdb.sql
+++ b/sql/serenitasdb.sql
@@ -658,7 +658,7 @@ JOIN tranche_quotes ON tranche_id=tranche_quotes.id;
 
 CREATE TABLE tranche_risk(
      id serial PRIMARY KEY,
-     tranche_id integer REFERENCES tranche_quotes(id),
+     tranche_id integer UNIQUE REFERENCES tranche_quotes(id) ON DELETE CASCADE,
      index_price float,
      index_basis float,
      index_expected_loss float,