Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

BANNER_CM_SECTION

  • CREATE TABLE SAKAI_EXTERNAL.BANNER_CM_SECTION ( 
    EID               	VARCHAR2(91) NULL,
    TITLE             	VARCHAR2(40) NULL,
    DESCRIPTION       	VARCHAR2(90) NULL,
    CATEGORY          	VARCHAR2(9) NOT NULL,
    COURSEOFFERING_EID	VARCHAR2(82) NULL,
    ENROLLMENTSET_EID 	VARCHAR2(74) NULL,
    MAXSIZE           	NUMBER(4,0) NOT NULL,
    PARENT            	VARCHAR2(255) 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,
    COURSECODE        	VARCHAR2(27) NULL,
    CONSTRAINT PK_SSBSECT1 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 134217728 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING 
NOCACHE 
MONITORING 
GO
COMMENT ON COLUMN SAKAI_EXTERNAL.BANNER_CM_SECTION.EID IS 'http://ucdavis.edu/course/section/SSBSECT_SUBJ_CODE/SSBSECT_CRSE_NUMB/SSBSECT_SEQ_NUMB/SSBSECT_TERM_CODE'
GO
COMMENT ON COLUMN SAKAI_EXTERNAL.BANNER_CM_SECTION.TITLE IS 'SSBSECT_SUBJ_CODE SSBSECT_CRSE_NUMB SSBSECT_SEQ_NUMB'
GO
COMMENT ON COLUMN SAKAI_EXTERNAL.BANNER_CM_SECTION.DESCRIPTION IS 'nvl(SSBSECT_CRSE_TITLE,(Description Unavailable))'
GO
COMMENT ON COLUMN SAKAI_EXTERNAL.BANNER_CM_SECTION.CATEGORY IS 'SSBSECT_SCHD_CODE'
GO
COMMENT ON COLUMN SAKAI_EXTERNAL.BANNER_CM_SECTION.COURSEOFFERING_EID IS 'http://ucdavis.edu/course/offering/bs.SSBSECT_SUBJ_CODE/SSBSECT_CRSE_NUMB/SBSECT_TERM_CODE'
GO
COMMENT ON COLUMN SAKAI_EXTERNAL.BANNER_CM_SECTION.ENROLLMENTSET_EID IS 'http://ucdavis.edu/course/enrollmentset/bs.SSBSECT_CRN/SBSECT_TERM_CODE'
GO
COMMENT ON COLUMN SAKAI_EXTERNAL.BANNER_CM_SECTION.MAXSIZE IS 'SSBSECT_MAX_ENRL'
GO
COMMENT ON COLUMN SAKAI_EXTERNAL.BANNER_CM_SECTION.CREATEDDATE IS 'SSBSECT_ACTIVITY_DATE'
GO
COMMENT ON COLUMN SAKAI_EXTERNAL.BANNER_CM_SECTION.LASTMODIFIEDDATE IS 'SSBSECT_ACTIVITY_DATE'
GO
COMMENT ON COLUMN SAKAI_EXTERNAL.BANNER_CM_SECTION.TERM_CODE IS 'SSBSECT_TERM_CODE'
GO
COMMENT ON COLUMN SAKAI_EXTERNAL.BANNER_CM_SECTION.CRN IS 'SSBSECT_CRN'
GO
COMMENT ON COLUMN SAKAI_EXTERNAL.BANNER_CM_SECTION.COURSECODE IS 'SSBSECT_SUBJ_CODE||SSBSECT_CRSE_NUMB'
GO
CREATE INDEX SAKAI_EXTERNAL.BANNER_CM_SECTION_DN_INDEX
    ON SAKAI_EXTERNAL.BANNER_CM_SECTION(TERM_CODE, COURSECODE)
TABLESPACE DATA_TS PCTFREE 10 INITRANS 2 MAXTRANS 255 
STORAGE( INITIAL 13631488 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING 
GO
CREATE INDEX SAKAI_EXTERNAL.BANNER_CM_SECTION_CAT_INDEX
    ON SAKAI_EXTERNAL.BANNER_CM_SECTION(CATEGORY)
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_CM_SECTION_ES_INDEX
    ON SAKAI_EXTERNAL.BANNER_CM_SECTION(ENROLLMENTSET_EID)
TABLESPACE DATA_TS PCTFREE 10 INITRANS 2 MAXTRANS 255 
STORAGE( INITIAL 33554432 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING 
GO
CREATE INDEX SAKAI_EXTERNAL.BANNER_CM_SECTION_CO_INDEX
    ON SAKAI_EXTERNAL.BANNER_CM_SECTION(COURSEOFFERING_EID)
TABLESPACE DATA_TS PCTFREE 10 INITRANS 2 MAXTRANS 255 
STORAGE( INITIAL 32505856 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING 
GO
CREATE INDEX SAKAI_EXTERNAL.BANNER_CM_SECTION_PIDX
    ON SAKAI_EXTERNAL.BANNER_CM_SECTION(EID)
TABLESPACE DATA_TS PCTFREE 10 INITRANS 2 MAXTRANS 255 
STORAGE( INITIAL 33554432 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING 
GO
GRANT SELECT ON SAKAI_EXTERNAL.BANNER_CM_SECTION TO SAKAI_EXTERNAL_SELECT
GO
  • No labels