BANNER_ENROLLMENT

Owned by Thomas Amsler
Last updated: Sept 22, 2007Version comment
2 min read
CREATE TABLE SAKAI_EXTERNAL.BANNER_ENROLLMENT ( 
    ENROLLMENTSET_EID	VARCHAR2(74) NULL,
    PIDM             	NUMBER(8,0) NOT NULL,
    ENROLLMENTSTATUS 	VARCHAR2(6) NULL,
    DROPPED          	NUMBER NULL,
    CREDITS          	NUMBER(7,3) NULL,
    GRADINGSCHEME    	VARCHAR2(3) 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_SFRSTCR1 PRIMARY KEY(TERM_CODE,PIDM,CRN)
USING INDEX 
TABLESPACE DATA_TS PCTFREE 10 INITRANS 2 MAXTRANS 255 
STORAGE( INITIAL 46137344 MINEXTENTS 1 MAXEXTENTS 2147483645 )
LOGGING 
)
TABLESPACE DATA_TS PCTFREE 10 INITRANS 1 MAXTRANS 255 
STORAGE( INITIAL 184549376 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING 
NOCACHE 
MONITORING 
GO
CREATE UNIQUE INDEX SAKAI_EXTERNAL.BANNER_ENROLLMENT_PIDX
    ON SAKAI_EXTERNAL.BANNER_ENROLLMENT(ENROLLMENTSET_EID, PIDM)
TABLESPACE DATA_TS PCTFREE 10 INITRANS 2 MAXTRANS 255 
STORAGE( INITIAL 117440512 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING 
GO
CREATE UNIQUE INDEX SAKAI_EXTERNAL.BANNER_ENROLLMENT_PIDX2
    ON SAKAI_EXTERNAL.BANNER_ENROLLMENT(PIDM, ENROLLMENTSET_EID)
TABLESPACE DATA_TS PCTFREE 10 INITRANS 2 MAXTRANS 255 
STORAGE( INITIAL 109051904 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING 
GO
CREATE INDEX SAKAI_EXTERNAL.BANNER_ENROLLMENT_ES_IDX
    ON SAKAI_EXTERNAL.BANNER_ENROLLMENT(ENROLLMENTSET_EID)
TABLESPACE DATA_TS PCTFREE 10 INITRANS 2 MAXTRANS 255 
STORAGE( INITIAL 109051904 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING 
GO
GRANT SELECT ON SAKAI_EXTERNAL.BANNER_ENROLLMENT TO SAKAI_EXTERNAL_SELECT
GO