Open eunja511005 opened 9 months ago
CREATE TABLE ZTHH_CHAT ( id VARCHAR2(255), ROOM_ID VARCHAR2(30), SENDER VARCHAR2(30), MESSAGE VARCHAR2(200), TIMESTAMP VARCHAR2(30), del_yn CHAR(1), create_id VARCHAR2(50), create_dt TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP, update_id VARCHAR2(50), update_dt TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP, CONSTRAINT ZTHH_CHAT PRIMARY KEY (id) );
CREATE INDEX idx_room_id ON ZTHH_CHAT (ROOM_ID);
AutoCoding 기능 이용하여 신규 테이블 및 기본 소스 생성 후 참조