tengda/path/20260304/SQL脚本/e签宝/CreateTable.sql

Create Table CT_ESI_AttachmentSPC ( 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),FID VARCHAR(44) DEFAULT '' NOT NULL ,FCreatorID VARCHAR(44),FCreateTime DateTime,FLastUpdateUserID VARCHAR(44),FLastUpdateTime DateTime,FControlUnitID VARCHAR(44) DEFAULT '11111111-1111-1111-1111-111111111111CCE7AED4',CFFirstCategory NVARCHAR(100),CFSecondCategory NVARCHAR(100),CFComponentId NVARCHAR(100),CFState INT,CONSTRAINT CPK_ESI_AtxmntSoov PRIMARY KEY (FID));

Create Table CT_ESI_ESGSO ( 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,CFPersonID VARCHAR(44),CFOperatorID VARCHAR(44),CFSendStatus INT,CFEsignStatus INT,CFApiNumber NVARCHAR(200),CFErrorMsg NCLOB(4000),CFRequestParams NCLOB(4000),CFSignFlowId NVARCHAR(200),CFFileName NVARCHAR(500),CFEfileId NVARCHAR(200),CFEsignName VARCHAR(100),CFFiesign INT,CFNowOperator NVARCHAR(500),CONSTRAINT CPK_ESI_ESGSOIDiee PRIMARY KEY (FID));

Create Table CT_ESI_ESignTemplate ( 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),FID VARCHAR(44) DEFAULT '' NOT NULL ,FCreatorID VARCHAR(44),FCreateTime DateTime,FLastUpdateUserID VARCHAR(44),FLastUpdateTime DateTime,FControlUnitID VARCHAR(44) DEFAULT '11111111-1111-1111-1111-111111111111CCE7AED4',CFState INT,CFUipkID VARCHAR(44),CFESignTemplateNum NVARCHAR(100),CFPositionX NUMERIC(28,10),CONSTRAINT CPK_ESI_ESTIDi308p PRIMARY KEY (FID));

Create Table CT_ESI_ESignTemplateFields ( FID VARCHAR(44) DEFAULT '' NOT NULL ,FSeq INT DEFAULT 0 NOT NULL ,FParentID VARCHAR(44) DEFAULT '' NOT NULL ,CFSeq INT,CFTemplateFieldId NVARCHAR(100),CFTemplateFieldKey NVARCHAR(100),CFTemplateFieldName NVARCHAR(100),CFRequired INT DEFAULT 0,CFInvalid INT DEFAULT 0,CFComponentType INT,CFDataFormat NVARCHAR(255),CFPositionX NUMERIC(28,10),CFPositionY NUMERIC(28,10),CFPageNum INT,CFPageRange NVARCHAR(100),CFRelatedControlID VARCHAR(44),CFSigningParty NVARCHAR(100),CONSTRAINT CPK_ESI_ESTFIDk2ft PRIMARY KEY (FID));

Create Table CT_ESI_ESignTemplateFileEntry ( FID VARCHAR(44) DEFAULT '' NOT NULL ,FSeq INT DEFAULT 0 NOT NULL ,FParentID VARCHAR(44) DEFAULT '' NOT NULL ,CFSeq INT,CFName NVARCHAR(100),CFESignTemplateId NVARCHAR(100),CFAttachmentCatego VARCHAR(44),CFState INT,CFSyncStatus INT,CFSyncResult NVARCHAR(2000),CFSyncTime DateTime,CONSTRAINT CPK_ESI_ESTFEIDcjt PRIMARY KEY (FID));

Create Table CT_ESI_EsignLog ( 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),FID VARCHAR(44) DEFAULT '' NOT NULL ,FCreatorID VARCHAR(44),FCreateTime DateTime,FLastUpdateUserID VARCHAR(44),FLastUpdateTime DateTime,FControlUnitID VARCHAR(44) DEFAULT '11111111-1111-1111-1111-111111111111CCE7AED4',CFAdminOrgUnitID VARCHAR(44),CFUrl NVARCHAR(800),CFEsiginName VARCHAR(100),CFRequestData NCLOB(8000),CFResponseData NCLOB(8000),CFSource NVARCHAR(100),CFMsg NVARCHAR(500),CFRequestState NVARCHAR(100),CONSTRAINT CPK_ESI_EsignLo835 PRIMARY KEY (FID));

Create Table CT_ESI_FieldMapping ( 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,CFName NVARCHAR(100),CFDataSourceID VARCHAR(44),CFESignFileID VARCHAR(44),CFDataInterface NVARCHAR(100),CONSTRAINT CPK_ESI_FieldMIjr0 PRIMARY KEY (FID));

Create Table CT_ESI_FieldMappingEntry ( FSeq INT,FID VARCHAR(44) DEFAULT '' NOT NULL ,FParentID VARCHAR(44),CFTemplateID VARCHAR(44),CFEFieldID VARCHAR(44),CFDataSourceFieldI VARCHAR(44),CFEFieldMark NVARCHAR(100),CFEFieldName NVARCHAR(100),CONSTRAINT CPK_ESI_FieldMEru0 PRIMARY KEY (FID));

Create Table CT_ESI_FileTab ( FPersonID VARCHAR(44),FCreatorID VARCHAR(44),FCreateTime DateTime,FLastUpdateUserID VARCHAR(44),FLastUpdateTime DateTime,FControlUnitID VARCHAR(44),FID VARCHAR(44) DEFAULT '' NOT NULL ,CFNumber NVARCHAR(100),CONSTRAINT PK_FileTab PRIMARY KEY (FID));

Create Table CT_ESI_GeneralESignBill ( 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,CFPersonID VARCHAR(44),CFAdminOrgID VARCHAR(44),CFPositionID VARCHAR(44),CFESignFileTemplat VARCHAR(44),CFIssueStatus INT,CFESignMappingID VARCHAR(44),CONSTRAINT CPK_ESI_JnrlESBrm8 PRIMARY KEY (FID));

Create Table CT_ESI_Seal ( 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),FID VARCHAR(44) DEFAULT '' NOT NULL ,FCreatorID VARCHAR(44),FCreateTime DateTime,FLastUpdateUserID VARCHAR(44),FLastUpdateTime DateTime,FControlUnitID VARCHAR(44) DEFAULT '11111111-1111-1111-1111-111111111111CCE7AED4',CFOrgId NVARCHAR(255),CFSealId NVARCHAR(255),CFSealName NVARCHAR(100),CFSealCreateTime DateTime,CFDefaultSealFlag INT,CFSealHeight INT,CFSealWidth INT,CFSealBizType VARCHAR(100),CFSealBizTypeDescription NVARCHAR(1000),CFSealStyle INT,CFEffectiveTime DateTime,CFExpireTime DateTime,CFSealAuthBizId NVARCHAR(200),CFAuthorizerOrgName NVARCHAR(100),CFAuthorizerOrgId NVARCHAR(200),CFAuthorizer INT,CFSealStatus INT,CONSTRAINT CPK_ESI_SealID26d2 PRIMARY KEY (FID));