1 CREATE TABLE T_CHAT_UPDATE_LOOKUP 2 ( 3 ID NUMBER, 4 OPERATOR_NAME VARCHAR2(100 BYTE) NOT NULL, 5 SCENARIO_LIST VARCHAR2(1000 BYTE) NOT NULL, 6 OG_ROUTE_LIST VARCHAR2(1000 BYTE) NOT NULL, 7 START_DATE DATE NOT NULL, 8 END_DATE DATE DEFAULT to_date('31.12.9999','dd.mm.yyyy'), 9 CREATED_DATE DATE DEFAULT SYSDATE, 10 CREATED_BY VARCHAR2(50 CHAR) DEFAULT USER NOT NULL, 11 MODIFIED_DATE DATE, 12 MODIFIED_BY VARCHAR2(50 CHAR) 13 ); 14