diff options
| -rw-r--r-- | python/Dawn/models.py | 4 | ||||
| -rw-r--r-- | sql/dawn.sql | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/python/Dawn/models.py b/python/Dawn/models.py index badfde90..d71a520e 100644 --- a/python/Dawn/models.py +++ b/python/Dawn/models.py @@ -237,8 +237,8 @@ class SwaptionDeal(db.Model): initial_margin_percentage = db.Column(db.Float) index_ref = db.Column(db.Float) security_id = db.Column(db.String(12), nullable=False) - security_desc = db.Column(db.String(32), nullable=False) - fixed_rate = db.Column(db.Float, nullable=False) + security_desc = db.Column(db.String(32)) + fixed_rate = db.Column(db.Float) maturity = db.Column(db.Date, nullable=False) currency = db.Column(CCY, nullable=False) termination_date = db.Column(db.Date) diff --git a/sql/dawn.sql b/sql/dawn.sql index b81f8e56..4fcf451b 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -203,10 +203,10 @@ CREATE TABLE swaptions(id serial PRIMARY KEY, expiration_date date NOT NULL, initial_margin_percentage float, security_id varchar(12) NOT NULL, - security_desc varchar(32) NOT NULL, + security_desc varchar(32), maturity date NOT NULL, currency currency NOT NULL, - fixed_rate float NOT NULL, + fixed_rate float, termination_date date, termination_amount float, termination_cp varchar(12) REFERENCES counterparties(code) ON UPDATE CASCADE); |