xugu_license/internal/module/capture/CREATE TABLE XUGU.sql

CREATE  TABLE  XUGU.formtable_main_146(
"ID" INTEGER NOT NULL ,
"REQUESTID" INTEGER,
"GLXM" INTEGER,
"SQSJ" CHAR(10),
"XSJSYX" VARCHAR(100),
"JFJSYX" VARCHAR(100),
"SYDW" VARCHAR(100),
"XMXXMS" VARCHAR(4000), 
"JDS" INTEGER,
"JFRY" CLOB,
"XSRY" CLOB,
CONSTRAINT"PK_S9071172173383367" PRIMARY KEY ("ID")
);

CREATE TABLE "XUGU"."FORMTABLE_MAIN_146_DT1" (
"ID" INTEGER NOT NULL ,
"MAINID" INTEGER,
"CPMC" INTEGER,
"BB" INTEGER,
"CLQ" VARCHAR(100),
"CZXT" VARCHAR(100),
"IP" VARCHAR(50),
"MAC" VARCHAR(100),
"JDS" INTEGER, CONSTRAINT"PK_S1967172181702375" PRIMARY KEY ("ID")
);


CREATE TABLE "XUGU"."HRMRESOURCE" (
"ID" INTEGER NOT NULL ,
"LASTNAME" VARCHAR(120)
);

CREATE TABLE "XUGU"."WORKFLOW_SELECTITEM" (
"SELECTVALUE" INTEGER,
"SELECTNAME" VARCHAR(1000),
"FIELDID" INTEGER
);

CREATE TABLE "XUGU"."WORKFLOW_REQUESTBASE" (
    "REQUESTNAME" VARCHAR(1000),
    "REQUESTNAMENEW" VARCHAR(4000),
    "REQUESTNAMEHTMLNEW" VARCHAR(4000),
    "REQUESTID" INTEGER,
"CREATEDATE" CHAR(10),
"CREATETIME" CHAR(8),
"LASTOPERATEDATE" CHAR(10),
"LASTOPERATETIME" CHAR(8),
CONSTRAINT"UK_S790416945985278" UNIQUE ("REQUESTID")
);

CREATE TABLE "XUGU"."PRJ_PROJECTINFO" (
 "ID" BIGINT IDENTITY(162,1) NOT NULL ,
"NAME" VARCHAR(1000),
 CONSTRAINT"PK_S29291170022985212260" PRIMARY KEY ("ID")
);