1 files changed, 8 insertions, 0 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql
index 509eceee..be668225 100644
--- a/sql/dawn.sql
+++ b/sql/dawn.sql
@@ -521,6 +521,8 @@ CREATE TABLE subscription_and_fee(
        management_fee float,
        PRIMARY KEY (fund, date));
 
+CREATE TYPE LS AS ENUM('L', 'S');
+
 CREATE TABLE bbh_val(
        accounting_date date NOT NULL,
        row integer NOT NULL,
@@ -544,6 +546,12 @@ CREATE TABLE bbh_val(
        total_current_assets float,
        total_current_liabilities float,
        total_net_assets float,
+       interest_rate float,
+       quantity float,
+       quantity_scale float,
+       long_short_indicator LS,
+       fx_rate float,
+       maturity_date date,
        PRIMARY KEY (accounting_date, row));
 
 CREATE TABLE bbh_pnl(