1 files changed, 22 insertions, 0 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql
index f740c30b..5db7674e 100644
--- a/sql/serenitasdb.sql
+++ b/sql/serenitasdb.sql
@@ -1233,3 +1233,25 @@ CREATE TABLE rates(
 CREATE TABLE dtcc_corrections(
     dissemination_id bigint,
     correction bytea)
+
+CREATE TYPE quote_firmness AS ENUM('FIRM', 'INDICATIVE');
+
+CREATE TABLE markit_singlename_quotes (
+       quoteid int8 primary key,
+       redcode text,
+       ticker text, 
+       maturity date,
+       tenor text,
+       runningcoupon int,
+       bidconventionalspread float,
+       bidupfront float,
+       bidsize float,
+       askconventionalspread float,
+       askupfront float,
+       asksize float,
+       firmness quote_firmness,
+       msg_id text,
+       quotedate timestamptz NULL,
+       quotesource text,
+       confidence int
+       );
+\ No newline at end of file