diff options
Diffstat (limited to 'sql/serenitasdb.sql')
| -rw-r--r-- | sql/serenitasdb.sql | 8 |
1 files changed, 2 insertions, 6 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql index df6dec39..9be430cd 100644 --- a/sql/serenitasdb.sql +++ b/sql/serenitasdb.sql @@ -194,12 +194,8 @@ CREATE TABLE tranche_quotes_tranches( CREATE INDEX ON tranche_quotes_tranches USING hash(quoteset);
CREATE TABLE tranche_skew
-(id integer GENERATED ALWAYS AS IDENTITY,
- date date NOT NULL,
- INDEX index_type NOT NULL,
- series SMALLINT NOT NULL,
- VERSION SMALLINT NOT NULL,
- tenor tenor NOT NULL,
+(id integer GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
+ quoteset integer NOT NULL UNIQUE REFERENCES tranche_quotes_ref ON DELETE CASCADE,
el double PRECISION NOT NULL,
x bytea NOT NULL,
c bytea NOT NULL,
|