diff options
Diffstat (limited to 'sql/dawn.sql')
| -rw-r--r-- | sql/dawn.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index c7db7a88..38459245 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -288,6 +288,7 @@ CREATE TABLE cds(id serial primary key, full_globeop_id text GENERATED ALWAYS AS ('CDS'||lpad(cast(globeop_id as text), 6, '0')|| 'K00SCLMA') STORED, stale bool default true, traded_level numeric(9, 5) NULL, + exercised_from text REFERENCES swaptions(dealid), CONSTRAINT tranche_check CHECK (( swap_type IN ('CD_INDEX_TRANCHE', 'BESPOKE') AND (orig_attach IS NOT NULL AND orig_detach IS NOT NULL AND clearing_facility IS NULL)) |