BANNER_ENROLLMENTSET

Owned by Thomas Amsler
Last updated: Sept 22, 2007Version comment
2 min read
CREATE TABLE SAKAI_EXTERNAL.BANNER_ENROLLMENTSET ( 
    EID                     	VARCHAR2(74) NULL,
    TITLE                   	VARCHAR2(90) NULL,
    DESCRIPTION             	VARCHAR2(90) NULL,
    COURSEOFFERING_EID      	VARCHAR2(82) NULL,
    DEFAULTENROLLMENTCREDITS	NUMBER(7,3) NULL,
    CATEGORY                	VARCHAR2(25) NULL,
    CREATEDBY               	VARCHAR2(25) NULL,
    CREATEDDATE             	DATE NOT NULL,
    LASTMODIFIEDBY          	VARCHAR2(25) NULL,
    LASTMODIFIEDDATE        	DATE NOT NULL,
    TERM_CODE               	VARCHAR2(18) NOT NULL,
    CRN                     	VARCHAR2(15) NOT NULL,
    CONSTRAINT PK_SSBSECT2 PRIMARY KEY(TERM_CODE,CRN)
USING INDEX 
TABLESPACE DATA_TS PCTFREE 10 INITRANS 2 MAXTRANS 255 
STORAGE( INITIAL 12582912 MINEXTENTS 1 MAXEXTENTS 2147483645 )
LOGGING 
)
TABLESPACE DATA_TS PCTFREE 10 INITRANS 1 MAXTRANS 255 
STORAGE( INITIAL 92274688 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING 
NOCACHE 
MONITORING 
GO
CREATE UNIQUE INDEX SAKAI_EXTERNAL.BANNER_ENROLLMENTSET_PIDX
    ON SAKAI_EXTERNAL.BANNER_ENROLLMENTSET(EID)
TABLESPACE DATA_TS PCTFREE 10 INITRANS 2 MAXTRANS 255 
STORAGE( INITIAL 45088768 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING 
GO
CREATE INDEX SAKAI_EXTERNAL.BANNER_ENROLLMENTSET_CO_INDEX
    ON SAKAI_EXTERNAL.BANNER_ENROLLMENTSET(COURSEOFFERING_EID)
TABLESPACE DATA_TS PCTFREE 10 INITRANS 2 MAXTRANS 255 
STORAGE( INITIAL 36700160 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING 
GO
GRANT SELECT ON SAKAI_EXTERNAL.BANNER_ENROLLMENTSET TO SAKAI_EXTERNAL_SELECT
GO