BANNER_ACADEMICSESSION

CREATE TABLE SAKAI_EXTERNAL.BANNER_ACADEMICSESSION ( 
    EID             	VARCHAR2(60) NULL,
    TITLE           	VARCHAR2(90) NOT NULL,
    DESCRIPTION     	VARCHAR2(17) NULL,
    STARTDATE       	DATE NOT NULL,
    ENDDATE         	DATE NOT NULL,
    CREATEDBY       	CHAR(6) NULL,
    CREATEDDATE     	DATE NOT NULL,
    LASTMODIFIEDBY  	CHAR(6) NULL,
    LASTMODIFIEDDATE	DATE NOT NULL,
    TERM_CODE       	VARCHAR2(18) NOT NULL,
    CONSTRAINT PK_STVTERM1 PRIMARY KEY(TERM_CODE)
USING INDEX 
TABLESPACE DATA_TS PCTFREE 10 INITRANS 2 MAXTRANS 255 
STORAGE( INITIAL 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 )
LOGGING 
)
TABLESPACE DATA_TS PCTFREE 10 INITRANS 1 MAXTRANS 255 
STORAGE( INITIAL 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING 
NOCACHE 
MONITORING 
GO