diff options
Diffstat (limited to 'sql/dawn.sql')
| -rw-r--r-- | sql/dawn.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index e67d6260..77f78ad8 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -3192,5 +3192,7 @@ CREATE TABLE public.citco_instruments ( strike float NULL, expiration date NULL, callput bool NULL, - commited bool NOT NULL default False + commited bool NOT NULL default False, + CONSTRAINT swaption UNIQUE (expiration, strike, underlying_security_id, serenitas_product, callput), + CONSTRAINT tranche UNIQUE (serenitas_product, underlying_security_id, attach, detach) );
\ No newline at end of file |