Oracle
-- Added discount percent to allocations table
ALTER TABLE ALLOCATIONS ADD DISCOUNT_CATEGORY VARCHAR2(50) null;
-- Added discount percent to preallocations table
ALTER TABLE PREALLOCATIONS ADD DISCOUNT_CATEGORY VARCHAR2(50) null;
-- Added the potfolio ssn to the portfolios table
ALTER TABLE PORTFOLIOS ADD PORTFOLIO_SSN VARCHAR2(50) NULL;
-- Added the default discount category to the portfolios table
ALTER TABLE PORTFOLIOS ADD DEFAULT_DISCOUNT_CATEGORY VARCHAR2(50) NULL;
-- Added the account ssn to the accounts table
ALTER TABLE ACCOUNTS ADD ACCOUNT_SSN VARCHAR2(50) NULL;
-- Discount Category table.
create sequence DISCOUNT_CATEGORY_SEQ;
create table DISCOUNT_CATEGORY (
ID_DISCOUNT_CATEGORY NUMBER(10,0) not null,
REFERENCE_KEY VARCHAR2(50),
DISCOUNT_PERCENT FLOAT,
DESCRIPTION VARCHAR2(255) null,
primary key (ID_DISCOUNT_CATEGORY)
);
-- Added discount percent to allocations table
ALTER TABLE ALLOCATIONS ADD BACKOFFICE_ID VARCHAR2(50) null;