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