1 files changed, 3 insertions, 1 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql
index 5306ea7f..09e50ab8 100644
--- a/sql/dawn.sql
+++ b/sql/dawn.sql
@@ -571,6 +571,7 @@ CREATE TABLE spots (
     initial_margin_percentage float8,
     cpty_id text,
     globeop_id text,
+    bbg_ticket_id text UNIQUE REFERENCES fx_tickets(bbg_ticket_id),
 	CONSTRAINT spots_pkey PRIMARY KEY (id),
 );
 
@@ -607,6 +608,7 @@ CREATE TABLE fx_swaps (
 	far_sell_amount float8 NOT NULL,
 	near_cpty_id text NULL,
 	far_cpty_id text NULL,
+    bbg_ticket_id text UNIQUE REFERENCES fx_tickets(bbg_ticket_id),
 );
 
 
@@ -3054,4 +3056,4 @@ CREATE TABLE public.fx_tickets (
 	"Trade Reporting Indicator" text NULL,
 	"Country of Membership" text NULL,
 	CONSTRAINT fx_tickets_pk PRIMARY KEY (bbg_ticket_id)
-);
-\ No newline at end of file
+);