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