diff options
| -rw-r--r-- | sql/dawn.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index cc8cc948..21fb2ef9 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -3937,3 +3937,11 @@ CREATE TABLE cash_balances ( balance float8 NULL, CONSTRAINT cash_balances_pkey PRIMARY KEY (date, account_number, currency_code) ); + +CREATE TABLE bond_submission( + id integer generated always as identity primary key, + dealid text not null, + settle_date date not null, + status status NOT NULL DEFAULT 'Pending', + CONSTRAINT futures_dealid_key UNIQUE (dealid, settle_date), +); |