diff options
Diffstat (limited to 'sql/dawn.sql')
| -rw-r--r-- | sql/dawn.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 4fcf451b..8f142814 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -45,6 +45,8 @@ CREATE TYPE protection AS ENUM('Buyer', 'Seller'); CREATE TYPE call_notice AS ENUM('24H', '48H', '3D', '4D', '5D', '6D', '1W', '8D', '9D', '10D', '2W', '1M', '2M'); +CREATE TYPE settlement_type AS ENUM('Delivery', 'Cash'); + CREATE TABLE accounts( code varchar(5) PRIMARY KEY, name text, @@ -206,6 +208,7 @@ CREATE TABLE swaptions(id serial PRIMARY KEY, security_desc varchar(32), maturity date NOT NULL, currency currency NOT NULL, + settlement_type settlement_type NOT NULL, fixed_rate float, termination_date date, termination_amount float, |