diff options
| -rw-r--r-- | sql/dawn.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index af3f8e9e..fe77a187 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -653,8 +653,8 @@ CREATE OR REPLACE VIEW id_mappings AS 'TRANCHE' FROM cds WHERE attach IS NOT NULL ORDER BY trade_date; CREATE TABLE cashflow_history( - identifier varchar(12) REFERENCES securities(figi) ON UPDATE CASCADE, - date date, + identifier varchar(12) NOT NULL REFERENCES securities(figi) ON UPDATE CASCADE, + date date NOT NULL, principal_bal float, principal float, interest float, |