CREATE TABLE BO_OWNER_INST_10274_1.ACCOUNT_SUMMARY
(
  ACT_ID                 VARCHAR2(20 BYTE)      NOT NULL,
  ACT_OPEN_DT            DATE,
  ACT_TYPE               NUMBER(8),
  BRANCH_CODE            VARCHAR2(20 BYTE),
  DISCR_TRADING_CODE     VARCHAR2(1 BYTE),
  FEE_BASED_YN           VARCHAR2(1 BYTE),
  NEW_MONEY              NUMBER,
  PCT_INVESTOR_ACCTS     NUMBER,
  PCT_HH_ACCTS           NUMBER,
  PCT_REP_ACCTS          NUMBER,
  MARKET_VALUE           NUMBER,
  CASH_VALUE             NUMBER,
  LONG_VALUE             NUMBER,
  SHORT_VALUE            NUMBER,
  BEGIN_YR_VALUE         NUMBER,
  LAST_MTH_VALUE         NUMBER,
  MTD_VALUE_CHANGE       NUMBER,
  MTD_VALUE_CHANGE_PCT   NUMBER,
  OPTION_TRADE_CODE      NUMBER(2),
  PLAN_ID                VARCHAR2(8 BYTE),
  MGR_ID                 VARCHAR2(8 BYTE),
  MGR_NAME               VARCHAR2(20 BYTE),
  AA_PLAN_YN             VARCHAR2(1 BYTE),
  FP_PLAN_YN             VARCHAR2(1 BYTE),
  ACCT_NAME              VARCHAR2(200 BYTE),
  LAST_UPDATE_DATE       DATE,
  TA_HH_ID               NUMBER,
  TA_INV_ID              NUMBER,
  ACT_TYPE_DESCR         VARCHAR2(30 BYTE),
  ACCT_NO_REF            VARCHAR2(100 BYTE),
  ACCT_NO                VARCHAR2(100 BYTE),
  REP_CODE               VARCHAR2(50 BYTE),
  ATTR1                  VARCHAR2(3 BYTE),
  ATTR2                  VARCHAR2(50 BYTE),
  PRODUCT_TYPE           VARCHAR2(50 BYTE),
  PROPOSAL_PLAN_ACT_YN   VARCHAR2(1 BYTE),
  TAX_STATUS_ID          NUMBER,
  WM_PROGRAM_ID          VARCHAR2(50 BYTE),
  TARGET_PORTFOLIO_YN    VARCHAR2(1 BYTE),
  REBAL_DATE             DATE,
  OUT_OF_TOLERANCE_YN    VARCHAR2(1 BYTE),
  REBAL_EVENT_TYPE_ID    NUMBER,
  GAIN_LOSS_REALIZED     NUMBER,
  GAIN_LOSS_UNREALIZED   NUMBER,
  GAIN_UNREALIZED        NUMBER,
  LOSS_UNREALIZED        NUMBER,
  GAIN_LOSS_REALIZED_PY  NUMBER,
  TARGET_ID              VARCHAR2(50 BYTE),
  MMF_SEC_ID             VARCHAR2(50 BYTE),
  PENDING_TRADES_YN      VARCHAR2(1 BYTE),
  MODEL_ID               VARCHAR2(50 BYTE),
  MODEL_FIRM_YN          VARCHAR2(1 BYTE),
  POR_PLAN_YN            VARCHAR2(1 BYTE)
)
TABLESPACE BO_OWNER_INST_10274_1
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE INDEX BO_OWNER_INST_10274_1.ACCOUNT_SUMMARY_INV_ID_I ON BO_OWNER_INST_10274_1.ACCOUNT_SUMMARY
(TA_INV_ID)
LOGGING
TABLESPACE BO_OWNER_INST_10274_1
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOPARALLEL;


CREATE INDEX BO_OWNER_INST_10274_1.ACCOUNT_SUMMARY_I_ACT_TAHHID ON BO_OWNER_INST_10274_1.ACCOUNT_SUMMARY
(ACT_ID, TA_HH_ID)
LOGGING
TABLESPACE BO_OWNER_INST_10274_1
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOPARALLEL;


CREATE INDEX BO_OWNER_INST_10274_1.ACCOUNT_SUMMARY_I_ATTR2 ON BO_OWNER_INST_10274_1.ACCOUNT_SUMMARY
(ATTR2)
LOGGING
TABLESPACE BO_OWNER_INST_10274_1
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOPARALLEL;


CREATE INDEX BO_OWNER_INST_10274_1.ACCOUNT_SUMMARY_I_TAHHID ON BO_OWNER_INST_10274_1.ACCOUNT_SUMMARY
(TA_HH_ID)
LOGGING
TABLESPACE BO_OWNER_INST_10274_1
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOPARALLEL;


CREATE UNIQUE INDEX BO_OWNER_INST_10274_1.ACCOUNT_SUMMARY_PK_ACT_ID ON BO_OWNER_INST_10274_1.ACCOUNT_SUMMARY
(ACT_ID)
LOGGING
TABLESPACE BO_OWNER_INST_10274_1
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOPARALLEL;


CREATE INDEX BO_OWNER_INST_10274_1.ACCOUNT_SUMM_I_ATT_MAR_ACT_ID ON BO_OWNER_INST_10274_1.ACCOUNT_SUMMARY
(ATTR2, MARKET_VALUE, ACT_ID)
LOGGING
TABLESPACE BO_OWNER_INST_10274_1
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOPARALLEL;


CREATE INDEX BO_OWNER_INST_10274_1.ACCT_IDX_HH_ID_ATTR2 ON BO_OWNER_INST_10274_1.ACCOUNT_SUMMARY
(TA_HH_ID, ATTR2)
LOGGING
TABLESPACE BO_OWNER_INST_10274_1
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOPARALLEL;


CREATE INDEX BO_OWNER_INST_10274_1.ACCT_SUMM_INV_IDX ON BO_OWNER_INST_10274_1.ACCOUNT_SUMMARY
(ACT_ID, TA_INV_ID)
LOGGING
TABLESPACE BO_OWNER_INST_10274_1
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOPARALLEL;


CREATE INDEX BO_OWNER_INST_10274_1.ACCT_SUMM_INV_ID_PROPOSAL_I ON BO_OWNER_INST_10274_1.ACCOUNT_SUMMARY
(TA_INV_ID, PROPOSAL_PLAN_ACT_YN)
LOGGING
TABLESPACE BO_OWNER_INST_10274_1
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOPARALLEL;


CREATE INDEX BO_OWNER_INST_10274_1.ACCT_SUMM_I_ACTNOREF ON BO_OWNER_INST_10274_1.ACCOUNT_SUMMARY
(ACCT_NO_REF)
LOGGING
TABLESPACE BO_OWNER_INST_10274_1
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOPARALLEL;


CREATE INDEX BO_OWNER_INST_10274_1.ACCT_SUMM_I_PRODTYPE ON BO_OWNER_INST_10274_1.ACCOUNT_SUMMARY
(PRODUCT_TYPE)
LOGGING
TABLESPACE BO_OWNER_INST_10274_1
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOPARALLEL;


ALTER TABLE BO_OWNER_INST_10274_1.ACCOUNT_SUMMARY ADD (
  CONSTRAINT ACCOUNT_SUMMARY_PK_ACT_ID
 PRIMARY KEY
 (ACT_ID)
    USING INDEX 
    TABLESPACE BO_OWNER_INST_10274_1
    PCTFREE    10
    INITRANS   2
    MAXTRANS   255
    STORAGE    (
                INITIAL          64K
                NEXT             1M
                MINEXTENTS       1
                MAXEXTENTS       UNLIMITED
                PCTINCREASE      0
               ));
               
               

***********************************************************************************************************

CREATE TABLE BO_OWNER_INST_10274_1.WEB_TEAM_X_ACCOUNT
(
  ACCOUNT_ID  VARCHAR2(50 CHAR)                 NOT NULL,
  TEAM_ID     VARCHAR2(50 CHAR)                 NOT NULL
)
TABLESPACE BO_OWNER_INST_10274_1
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE INDEX BO_OWNER_INST_10274_1.BTXA_ACT_IDX ON BO_OWNER_INST_10274_1.WEB_TEAM_X_ACCOUNT
(ACCOUNT_ID)
NOLOGGING
TABLESPACE BO_OWNER_INST_10274_1
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
PARALLEL ( DEGREE 4 INSTANCES 1 );


CREATE UNIQUE INDEX BO_OWNER_INST_10274_1.WTT_PK ON BO_OWNER_INST_10274_1.WEB_TEAM_X_ACCOUNT
(ACCOUNT_ID, TEAM_ID)
NOLOGGING
TABLESPACE BO_OWNER_INST_10274_1
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
PARALLEL ( DEGREE 4 INSTANCES 1 );


CREATE UNIQUE INDEX BO_OWNER_INST_10274_1.WTT_U_TEAM_ACCOUNT ON BO_OWNER_INST_10274_1.WEB_TEAM_X_ACCOUNT
(TEAM_ID, ACCOUNT_ID)
NOLOGGING
TABLESPACE BO_OWNER_INST_10274_1
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
PARALLEL ( DEGREE 4 INSTANCES 1 );


CREATE INDEX BO_OWNER_INST_10274_1.WTT_U_X_TEAM_ID ON BO_OWNER_INST_10274_1.WEB_TEAM_X_ACCOUNT
(TEAM_ID)
NOLOGGING
TABLESPACE BO_OWNER_INST_10274_1
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
PARALLEL ( DEGREE 4 INSTANCES 1 );

***********************************************************************************************************

CREATE TABLE WEB_OWNER.WEB_BROKER_X_TEAM
(
  BROKER_ID  NUMBER(8)                          NOT NULL,
  RLS_ID     NUMBER,
  TEAM_ID    VARCHAR2(50 CHAR)
)
TABLESPACE WEB_DATA
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE INDEX WEB_OWNER.WBXT_I_RLS_BRK_REM ON WEB_OWNER.WEB_BROKER_X_TEAM
(RLS_ID, BROKER_ID, TEAM_ID)
LOGGING
TABLESPACE WEB_DATA
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOPARALLEL;


CREATE INDEX WEB_OWNER.WBXT_I_RLS_TEAM_BRK ON WEB_OWNER.WEB_BROKER_X_TEAM
(RLS_ID, TEAM_ID, BROKER_ID)
LOGGING
TABLESPACE WEB_DATA
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOPARALLEL;


CREATE UNIQUE INDEX WEB_OWNER.WBXT_PK_BROKER_TEAM_ID1 ON WEB_OWNER.WEB_BROKER_X_TEAM
(BROKER_ID, TEAM_ID)
LOGGING
TABLESPACE WEB_DATA
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOPARALLEL;


ALTER TABLE WEB_OWNER.WEB_BROKER_X_TEAM ADD (
  CONSTRAINT WBXT_PK_BROKER_TEAM_ID1
 PRIMARY KEY
 (BROKER_ID, TEAM_ID)
    USING INDEX 
    TABLESPACE WEB_DATA
    PCTFREE    10
    INITRANS   2
    MAXTRANS   255
    STORAGE    (
                INITIAL          64K
                NEXT             1M
                MINEXTENTS       1
                MAXEXTENTS       UNLIMITED
                PCTINCREASE      0
               ));