CREATE TABLE "CMPROCESSING" ("PROCESS_ID" VARCHAR2(30) NOT NULL, "COOP_CONTROL" VARCHAR2(10), "COOP_ID" VARCHAR2(10), "ENTRY_ID" VARCHAR2(30) NOT NULL,"ENTRY_DATE" DATE, "START_PROCESS" NUMBER(4,0) DEFAULT 0 NOT NULL, "END_PROCESS" NUMBER(4,0) DEFAULT 0 NOT NULL, "READ_DATE" DATE, "FINISH_DATE" DATE, "RUNTIME_STATUS" NUMBER(2,0), "SHOW_FLAG" NUMBER(1,0) DEFAULT 1 NOT NULL, "RUNTIME_MESSAGE" VARCHAR2(500), "OBJECT_NAME" VARCHAR2(150), "CMD" VARCHAR2(500), "LABEL_NAME" VARCHAR2(50), "CRITERIA_XML" CLOB, "CRITERIA_XML_1" CLOB, "CRITERIA_XML_2" CLOB) ;
ALTER TABLE "CMPROCESSING" ADD ( CONSTRAINT CMP_PK PRIMARY KEY ( "PROCESS_ID", "ENTRY_ID" )) ;
ALTER TABLE CMPROCESSING ADD ( APPLICATION VARCHAR2(20), REPORT_GROUP_ID VARCHAR2(40) ,REPORT_ID VARCHAR2(40),REPORT_PATH VARCHAR2(255),PRINTER VARCHAR2(150) );
ALTER TABLE CMPROCESSING ADD ( WORKDATE DATE );
CREATE TABLE "CMPRINTER" ("PRINTER_ID" VARCHAR2(30) NOT NULL, "COOP_CONTROL" VARCHAR2(10), "COOP_ID" VARCHAR2(10) NOT NULL, "PRINTER_NAME" VARCHAR2(150) NOT NULL, "PRINTER_IP" VARCHAR2(80), "DEFAULT_FLAG" NUMBER(1,0) DEFAULT 0) ;
ALTER TABLE "CMPRINTER" ADD ( CONSTRAINT PRINTER_PK PRIMARY KEY ( "PRINTER_ID", "COOP_ID" )) ;