diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 2f3233c9..a6b43404 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -2711,3 +2711,13 @@ CREATE TABLE public.cds_tickets ( "Coupon" int8 NULL, CONSTRAINT cds_tickets_pk PRIMARY KEY (bbg_ticket_id, "Account", "Client FCM") ); + +CREATE TABLE public.cds_submission ( + id int4 NOT NULL GENERATED ALWAYS AS IDENTITY, + tradeid int4 NOT NULL, + "action" action NOT NULL, + submit_date timestamptz NOT NULL DEFAULT now(), + "status" status NOT NULL DEFAULT 'Pending'::status, + CONSTRAINT cds_submission_pkey PRIMARY KEY (id), + CONSTRAINT cds_submission_allocation_id_fkey FOREIGN KEY (tradeid) REFERENCES public.cds(id) ON DELETE CASCADE +); |