diff options
| -rw-r--r-- | sql/dawn.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index fa9d5f8b..e172c649 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -321,6 +321,11 @@ CREATE TABLE marks(date date, price float, PRIMARY KEY(identifier, date)); +CREATE TABLE external_marks_deriv(date date NOT NULL, + identifier text NOT NULL, + nav float, + PRIMARY KEY(identifier, date)); + CREATE TABLE cashflow_history( identifier varchar(12) REFERENCES securities ON UPDATE CASCADE, date date, |