BANNER_MEETING

Owned by Thomas Amsler
Last updated: Sept 22, 2007Version comment
2 min read
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