1 files changed, 21 insertions, 5 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql
index 5cb8f4e2..1490fa21 100644
--- a/sql/serenitasdb.sql
+++ b/sql/serenitasdb.sql
@@ -1234,9 +1234,25 @@ CREATE TABLE dtcc_corrections(
     dissemination_id bigint,
     correction bytea)
 
-CREATE TABLE markit_quote_details (
-       id int8 primary key,
+CREATE TYPE markit_asset_class AS ENUM('SN');
+CREATE TYPE quote_firmness AS ENUM('FIRM', 'INDICATIVE');
+
+CREATE TABLE markit_quotes (
+       quoteid int8 primary key,
+       asset_class markit_asset_class,
+       redcode text,
+       ticker text, 
+       maturity date,
+       tenor tenor,
+       running_coupon int,
+       bid_spread float,
+       bid_upfront float,
+       bid_size float,
+       ask_spread float,
+       ask_upfront float,
+       ask_size float,
+       msg_id text,
+       source text,
        quotetime timestamptz NULL,
-       quote_source varchar(4) NULL,
-       sender text NULL,
-);
-\ No newline at end of file
+       quote_source varchar(4) NULL
+       );
+\ No newline at end of file