diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/serenitasdb.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql index fec2e126..bb136c39 100644 --- a/sql/serenitasdb.sql +++ b/sql/serenitasdb.sql @@ -136,7 +136,7 @@ CREATE TABLE tranche_quotes ( CorrAtDetachment real,
Basis real,
QuoteSource varchar(4),
- markit_id integer
+ markit_id integer UNIQUE,
UNIQUE (QuoteDate, Index, Series, Version, Tenor, Attach, Detach, QuoteSource, trancherunningmid, markit_id)
);
|