BANNER_INSTRUCTORS

Owned by Thomas Amsler
Last updated: Sept 22, 2007Version comment
CREATE TABLE SAKAI_EXTERNAL.BANNER_INSTRUCTORS ( 
    ENROLLMENTSET_EID	VARCHAR2(74) NULL,
    SECTION_EID      	VARCHAR2(91) NULL,
    PIDM             	NUMBER(8,0) NOT NULL,
    ROLE             	CHAR(10) NULL,
    STATUS           	CHAR(6) NULL,
    TERM_CODE        	VARCHAR2(18) NOT NULL,
    CRN              	VARCHAR2(15) NOT NULL,
    CATEGORY         	VARCHAR2(6) NOT NULL,
    SIRASGN_ROW      	ROWID NOT NULL,
    SSBSECT_ROW      	ROWID NOT NULL 
    )
TABLESPACE DATA_TS PCTFREE 10 INITRANS 1 MAXTRANS 255 
STORAGE( INITIAL 83886080 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING 
NOCACHE 
MONITORING 
GO
CREATE INDEX SAKAI_EXTERNAL.BANNER_INSTRUCTORS_ES_IDX
    ON SAKAI_EXTERNAL.BANNER_INSTRUCTORS(ENROLLMENTSET_EID, PIDM)
TABLESPACE DATA_TS PCTFREE 10 INITRANS 2 MAXTRANS 255 
STORAGE( INITIAL 34603008 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING 
GO
CREATE INDEX SAKAI_EXTERNAL.BANNER_INSTRUCTORS_S_IDX
    ON SAKAI_EXTERNAL.BANNER_INSTRUCTORS(SECTION_EID, PIDM)
TABLESPACE DATA_TS PCTFREE 10 INITRANS 2 MAXTRANS 255 
STORAGE( INITIAL 34603008 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING 
GO
GRANT SELECT ON SAKAI_EXTERNAL.BANNER_INSTRUCTORS TO SAKAI_EXTERNAL_SELECT
GO