CREATE TABLE SAKAI_EXTERNAL.BANNER_COURSEOFFERING (
EID VARCHAR2(82) NULL,
TITLE VARCHAR2(121) NULL,
DESCRIPTION VARCHAR2(90) NULL,
STATUS CHAR(6) NULL,
ACADEMICSESSION_EID VARCHAR2(60) NULL,
CANONICALCOURSE_EID VARCHAR2(64) NULL,
STARTDATE DATE NOT NULL,
ENDDATE DATE NOT NULL,
CREATEDBY CHAR(6) NULL,
CREATEDDATE DATE NULL,
LASTMODIFIEDBY CHAR(6) NULL,
LASTMODIFIEDDATE DATE NULL,
SUBJ_CODE VARCHAR2(12) NOT NULL,
CRSE_NUMB VARCHAR2(15) NOT NULL,
TERM_CODE VARCHAR2(18) NOT NULL,
COURSECODE VARCHAR2(27) NULL
)
TABLESPACE DATA_TS PCTFREE 10 INITRANS 1 MAXTRANS 255
STORAGE( INITIAL 18874368 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING
NOCACHE
MONITORING
GO
CREATE INDEX SAKAI_EXTERNAL.BANNER_COURSEOFFERING_DN_INDEX
ON SAKAI_EXTERNAL.BANNER_COURSEOFFERING(TERM_CODE, COURSECODE)
TABLESPACE DATA_TS PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE( INITIAL 4194304 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING
GO
CREATE UNIQUE INDEX SAKAI_EXTERNAL.BANNER_COURSEOFFERING_PIDX
ON SAKAI_EXTERNAL.BANNER_COURSEOFFERING(EID)
TABLESPACE DATA_TS PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE( INITIAL 7340032 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING
GO
CREATE INDEX SAKAI_EXTERNAL.BANNER_COURSEOFFERING_CC_INDEX
ON SAKAI_EXTERNAL.BANNER_COURSEOFFERING(CANONICALCOURSE_EID)
TABLESPACE DATA_TS PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE( INITIAL 10485760 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING
GO
CREATE INDEX SAKAI_EXTERNAL.BANNER_COURSEOFFERING_AS_INDEX
ON SAKAI_EXTERNAL.BANNER_COURSEOFFERING(ACADEMICSESSION_EID)
TABLESPACE DATA_TS PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE( INITIAL 11534336 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING
GO
GRANT SELECT ON SAKAI_EXTERNAL.BANNER_COURSEOFFERING TO SAKAI_EXTERNAL_SELECT
GO