diff options
Diffstat (limited to 'python/Dawn/models.py')
| -rw-r--r-- | python/Dawn/models.py | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/python/Dawn/models.py b/python/Dawn/models.py index a80feae2..f650732e 100644 --- a/python/Dawn/models.py +++ b/python/Dawn/models.py @@ -139,8 +139,11 @@ class CDSDeal(db.Model): lastupdate = db.Column(db.DateTime, server_default=db.func.now(), onupdate=db.func.now()) action = db.Column(ACTION) folder = db.Column(CDS_STRAT, nullable=False) - custodian = db.Column(db.String(12), default='SGFCM', nullable=False) - cashaccount = db.Column(db.String(10), default='SGNSCLMASW', nullable=False) + account_code = db.Column(db.String(5), db.ForeignKey('accounts.code'), + info={'choices': [(None,'')], + 'label': 'fcm_account'}, nullable=False) + custodian = db.Column(db.String(12), default='NONE', nullable=False) + cashaccount = db.Column(db.String(10), default='V0NSCLMFCM', nullable=False) cp_code = db.Column(db.String(12), db.ForeignKey('counterparties.code'), info={'choices': [(None, '')], 'label': 'counterparty'}, nullable=False) @@ -175,6 +178,7 @@ class CDSDeal(db.Model): 'label': 'termination_counterparty'}) counterparty = db.relationship(Counterparties, foreign_keys=[cp_code]) termination_counterparty = db.relationship(Counterparties, foreign_keys=[termination_cp]) + fcm_account = db.relationship(Accounts, foreign_keys=[account_code]) __table_args__ = (db.CheckConstraint("swap_type!='CD_INDEX_TRANCHE' or " \ "(attach is not NULL and detach is not NULL AND " \ "clearing_facility is NULL)"),) |