BANNER_COURSEOFFERING

Owned by Thomas Amsler
Last updated: Sept 22, 2007Version comment
2 min read
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