泛微OA集成.sql 2.0 KB

123456
  1. Create Table CT_WEA_WeaverOAAITL ( FID VARCHAR(44) DEFAULT '' NOT NULL ,FSeq INT DEFAULT 0 NOT NULL ,FParentID VARCHAR(44) DEFAULT '' NOT NULL ,CFSeq INT,CFFlowid NVARCHAR(255),CFRequestname NVARCHAR(512),CFWorkflowname NVARCHAR(255),CFNodename NVARCHAR(100),CFPcurl NVARCHAR(1000),CFAppurl NVARCHAR(1000),CFOperType VARCHAR(100),CFOperResult VARCHAR(100),CFMessage NVARCHAR(1000),CFDataType VARCHAR(100),CFReceivedatetime DateTime,CFReceiverID VARCHAR(44),CFCreatedatetime DateTime,CFCreatorID VARCHAR(44),CFViewtype VARCHAR(100),CFIsremark VARCHAR(100),CFSyncStatus VARCHAR(100),CFSyncResult NVARCHAR(1000),CONSTRAINT CPK_WEA_WvrOAAI3v4 PRIMARY KEY (FID));
  2. Create Table CT_WEA_WeaverOAAI ( FCreatorID VARCHAR(44),FCreateTime DateTime,FLastUpdateUserID VARCHAR(44),FLastUpdateTime DateTime,FControlUnitID VARCHAR(44),FNumber NVARCHAR(80),FBizDate DateTime,FHandlerID VARCHAR(44),FDescription NVARCHAR(80),FHasEffected INT,FAuditorID VARCHAR(44),FSourceBillID NVARCHAR(80),FSourceFunction NVARCHAR(80),FID VARCHAR(44) DEFAULT '' NOT NULL ,FFivouchered INT,CFSyscode NVARCHAR(100),CFInstanceId NVARCHAR(255),CFBillType NVARCHAR(100),CFInstanceStatus VARCHAR(100),CFTitle NVARCHAR(255),CFHrOrgUnitID VARCHAR(44),CFSenderID VARCHAR(44),CONSTRAINT CPK_WEA_WvrOAAItg0 PRIMARY KEY (FID));
  3. Create Table CT_WEA_WeaverOAConfig ( CFSHRServerName VARCHAR(255),CFDefaultConfig INT,CFMEid VARCHAR(255),CFStartProcessPush INT,CFStartMessagePush INT,CFOAServerName VARCHAR(255),CFUserMappingField VARCHAR(100),CFSyscode VARCHAR(100),FShrBasicItemID VARCHAR(44),FUsePolicy INT,FIsSysPreset INT DEFAULT 0,FState INT DEFAULT 0 NOT NULL ,FIndex INT,FHrOrgUnitId VARCHAR(44),FName_l1 NVARCHAR(255),FName_l2 NVARCHAR(255),FName_l3 NVARCHAR(255),FNumber NVARCHAR(80),FDescription_l1 NVARCHAR(255),FDescription_l2 NVARCHAR(255),FDescription_l3 NVARCHAR(255),FSimpleName NVARCHAR(80),FCreatorID VARCHAR(44),FCreateTime DateTime,FLastUpdateUserID VARCHAR(44),FLastUpdateTime DateTime,FControlUnitID VARCHAR(44),FID VARCHAR(44) DEFAULT '' NOT NULL ,CONSTRAINT PK_WeaverOAConfig PRIMARY KEY (FID));