CREATE TABLE SAKAI_EXTERNAL.BANNER_MEETING (
EID VARCHAR2(181) NULL,
SECTION_EID VARCHAR2(91) NULL,
STARTTIME TIMESTAMP(9) NULL,
ENDTIME TIMESTAMP(9) NULL,
LOCATION VARCHAR2(49) NULL,
SUNDAY VARCHAR2(3) NULL,
MONDAY VARCHAR2(3) NULL,
TUESDAY VARCHAR2(3) NULL,
WEDNESDAY VARCHAR2(3) NULL,
THURSDAY VARCHAR2(3) NULL,
FRIDAY VARCHAR2(3) NULL,
SATURDAY VARCHAR2(3) NULL,
NOTES VARCHAR2(255) NULL,
CREATEDBY CHAR(6) NULL,
CREATEDDATE DATE NOT NULL,
LASTMODIFIEDBY CHAR(6) NULL,
LASTMODIFIEDDATE DATE NOT NULL
)
TABLESPACE DATA_TS PCTFREE 10 INITRANS 1 MAXTRANS 255
STORAGE( INITIAL 19922944 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING
NOCACHE
MONITORING
GO
CREATE INDEX SAKAI_EXTERNAL.BANNER_MEETING_PIDX
ON SAKAI_EXTERNAL.BANNER_MEETING(SECTION_EID, STARTTIME, ENDTIME, LOCATION)
TABLESPACE DATA_TS PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE( INITIAL 24117248 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING
GO
GRANT SELECT ON SAKAI_EXTERNAL.BANNER_MEETING TO SAKAI_EXTERNAL_SELECT
GO