Z-Archive » Maybank Projects » M2U UPASS Project

Rem =====================================================================

Rem   NAME

Rem     <ib_td_term.sql>

Rem   DESCRIPTION

Rem     <IB TD Term Content Table>

Rem   MODULE

Rem     <IB Module>

Rem   MODIFIED  (MM/DD/YYYY)

Rem        Danniell   03/12/2010 - Creation

Rem        xxxxxx           mm/dd/yyyy - Modify

Rem =====================================================================

CREATE TABLE IB_TD_TERM

(

  OID                       NUMBER              NOT NULL,

  PRODUCT_ID                NUMBER              NOT NULL,

  TERM_PRODUCT_CODE         VARCHAR2(16 BYTE),

  TERM_DISPLAY              VARCHAR2(64 BYTE),

  TERM_CODE                 VARCHAR2(1 BYTE),

  INTEREST_PAYMENT_MODE     VARCHAR2(1 BYTE),

  DEFAULT_INTEREST_PAYMENT  VARCHAR2(32 BYTE),

  AUTO_RENEWAL_MODE         VARCHAR2(1 BYTE),

  MIN_AMOUNT                NUMBER,

  PAY_FREQ_CODE             VARCHAR2(1 BYTE),

  PAY_FREQ_DISPLAY          VARCHAR2(64 BYTE)

)

TABLESPACE USERS

PCTUSED    0

PCTFREE    10

INITRANS   1

MAXTRANS   255

STORAGE    (

            INITIAL          64K

            MINEXTENTS       1

            MAXEXTENTS       UNLIMITED

            PCTINCREASE      0

            BUFFER_POOL      DEFAULT

           )

LOGGING

NOCOMPRESS

NOCACHE

NOPARALLEL

MONITORING;

CREATE UNIQUE INDEX IB_TD_TERM_PK ON IB_TD_TERM

(OID)

LOGGING

TABLESPACE USERS

PCTFREE    10

INITRANS   2

MAXTRANS   255

STORAGE    (

            INITIAL          64K

            MINEXTENTS       1

            MAXEXTENTS       UNLIMITED

            PCTINCREASE      0

            BUFFER_POOL      DEFAULT

           )

NOPARALLEL;

ALTER TABLE IB_TD_TERM ADD (

  CONSTRAINT IB_TD_TERM_PK

 PRIMARY KEY

 (OID)

    USING INDEX

    TABLESPACE USERS

    PCTFREE    10

    INITRANS   2

    MAXTRANS   255

    STORAGE    (

                INITIAL          64K

                MINEXTENTS       1

                MAXEXTENTS       UNLIMITED

                PCTINCREASE      0

               ));

ALTER TABLE IB_TD_TERM ADD (

  CONSTRAINT IB_TD_TERM_R01

 FOREIGN KEY (PRODUCT_ID)

 REFERENCES IB_PRODUCT_TYPE (OID)

    ON DELETE CASCADE);