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

Version 1 Next »

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

  • No labels