1 files changed, 3 insertions, 3 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql
index 5f0f00f3..79371b40 100644
--- a/sql/dawn.sql
+++ b/sql/dawn.sql
@@ -464,10 +464,10 @@ CREATE TABLE marks(date date,
 
 CREATE TABLE external_marks_deriv(date date NOT NULL,
        identifier text NOT NULL,
-       nav float,
+       local_nav float, --trade ccy nav
+       base_nav float, --USD nav
        cpty varchar(4),
-       trade_date
-       trade_type trade_type,
+       ia float, -- ia in USD
        PRIMARY KEY(identifier, date));
 
 CREATE OR REPLACE VIEW id_mappings AS