diff options
| -rw-r--r-- | sql/serenitasdb.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql index 41557de9..1e72dfc4 100644 --- a/sql/serenitasdb.sql +++ b/sql/serenitasdb.sql @@ -1237,7 +1237,7 @@ CREATE TABLE dtcc_corrections( CREATE TYPE markit_asset_class AS ENUM('CD');
CREATE TYPE quote_firmness AS ENUM('FIRM', 'INDICATIVE');
-CREATE TABLE markit_quotes (
+CREATE TABLE cd_markit_quotes (
quoteid int8 primary key,
assetclass markit_asset_class,
redcode text,
@@ -1254,5 +1254,6 @@ CREATE TABLE markit_quotes ( firmness quote_firmness,
msg_id text,
quotedate timestamptz NULL,
- quotesource varchar(4) NULL
+ quotesource text,
+ confidence int
);
\ No newline at end of file |