Home Explore Help
Sign In
project
/
tengda
5
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: bf0e26559b
Branches Tags
tengda
/
path
/
20260304
/
SQL脚本
/
e签宝
/
CreateTable.sql

CreateTable.sql 10 KB
History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566 
  1. drop Table CT_ESI_AttachmentSPC;
    2. 

  2. Create Table CT_ESI_AttachmentSPC ( FName_l1 NVARCHAR(255) COLLATE Chinese_PRC_CS_AS,
    3. 

  3. FName_l2 NVARCHAR(255) COLLATE Chinese_PRC_CS_AS,
    4. 

  4. FName_l3 NVARCHAR(255) COLLATE Chinese_PRC_CS_AS,
    5. 

  5. FNumber NVARCHAR(80) COLLATE Chinese_PRC_CS_AS,
    6. 

  6. FDescription_l1 NVARCHAR(255) COLLATE Chinese_PRC_CS_AS,
    7. 

  7. FDescription_l2 NVARCHAR(255) COLLATE Chinese_PRC_CS_AS,
    8. 

  8. FDescription_l3 NVARCHAR(255) COLLATE Chinese_PRC_CS_AS,
    9. 

  9. FSimpleName NVARCHAR(80) COLLATE Chinese_PRC_CS_AS,
    10. 

  10. FID VARCHAR(44) DEFAULT '' NOT NULL  COLLATE Chinese_PRC_CS_AS,
    11. 

  11. FCreatorID VARCHAR(44) COLLATE Chinese_PRC_CS_AS,
    12. 

  12. FCreateTime DateTime,
    13. 

  13. FLastUpdateUserID VARCHAR(44) COLLATE Chinese_PRC_CS_AS,
    14. 

  14. FLastUpdateTime DateTime,
    15. 

  15. FControlUnitID VARCHAR(44) DEFAULT '11111111-1111-1111-1111-111111111111CCE7AED4' COLLATE Chinese_PRC_CS_AS,
    16. 

  16. CFFirstCategory NVARCHAR(100) COLLATE Chinese_PRC_CS_AS,
    17. 

  17. CFSecondCategory NVARCHAR(100) COLLATE Chinese_PRC_CS_AS,
    18. 

  18. CFComponentId NVARCHAR(100) COLLATE Chinese_PRC_CS_AS,
    19. 

  19. CFState INT,CONSTRAINT CPK_ESI_AtxmntSoov PRIMARY KEY (FID));
    20. 

  20. 

  21. drop Table CT_ESI_ESGSO;
    22. 

  22. Create Table CT_ESI_ESGSO ( 
    23. 

  23.     FCreatorID VARCHAR(44) COLLATE Chinese_PRC_CS_AS,
    24. 

  24.     FCreateTime DateTime,FLastUpdateUserID VARCHAR(44) COLLATE Chinese_PRC_CS_AS,
    25. 

  25.     FLastUpdateTime DateTime,FControlUnitID VARCHAR(44) COLLATE Chinese_PRC_CS_AS,
    26. 

  26.     FNumber NVARCHAR(80) COLLATE Chinese_PRC_CS_AS,FBizDate DateTime,
    27. 

  27.     FHandlerID VARCHAR(44) COLLATE Chinese_PRC_CS_AS,FDescription NVARCHAR(580) COLLATE Chinese_PRC_CS_AS,
    28. 

  28.     FHasEffected INT,FAuditorID VARCHAR(44) COLLATE Chinese_PRC_CS_AS,
    29. 

  29.     FSourceBillID NVARCHAR(80) COLLATE Chinese_PRC_CS_AS,FSourceFunction NVARCHAR(80) COLLATE Chinese_PRC_CS_AS,
    30. 

  30.     FID VARCHAR(44) DEFAULT '' NOT NULL COLLATE Chinese_PRC_CS_AS,
    31. 

  31.     FFivouchered INT,CFPersonID VARCHAR(44)  COLLATE Chinese_PRC_CS_AS,
    32. 

  32.     CFOperatorID VARCHAR(44) COLLATE Chinese_PRC_CS_AS,CFSendStatus INT,CFEsignStatus INT,
    33. 

  33.     CFApiNumber NVARCHAR(200)  COLLATE Chinese_PRC_CS_AS,
    34. 

  34.     CFErrorMsg NText COLLATE Chinese_PRC_CS_AS,CFRequestParams NText COLLATE Chinese_PRC_CS_AS,
    35. 

  35.     CFSignFlowId NVARCHAR(200)  COLLATE Chinese_PRC_CS_AS,CFFileName NVARCHAR(500)  COLLATE Chinese_PRC_CS_AS,
    36. 

  36.     CFEfileId NVARCHAR(200),CFEsignName VARCHAR(100) COLLATE Chinese_PRC_CS_AS,CFFiesign INT,
    37. 

  37.     CFNowOperator NVARCHAR(500) COLLATE Chinese_PRC_CS_AS,CONSTRAINT CPK_ESI_ESGSOIDiee PRIMARY KEY (FID));
    38. 

  38. 

  39. drop Table CT_ESI_ESignTemplate;
    40. 

  40. Create Table CT_ESI_ESignTemplate ( FName_l1 NVARCHAR(255) COLLATE Chinese_PRC_CS_AS ,FName_l2 NVARCHAR(255) COLLATE Chinese_PRC_CS_AS ,FName_l3 NVARCHAR(255) COLLATE Chinese_PRC_CS_AS ,FNumber NVARCHAR(80) COLLATE Chinese_PRC_CS_AS ,FDescription_l1 NVARCHAR(255) COLLATE Chinese_PRC_CS_AS ,FDescription_l2 NVARCHAR(255) COLLATE Chinese_PRC_CS_AS ,FDescription_l3 NVARCHAR(255) COLLATE Chinese_PRC_CS_AS ,FSimpleName NVARCHAR(80) COLLATE Chinese_PRC_CS_AS ,FID VARCHAR(44) DEFAULT '' NOT NULL COLLATE Chinese_PRC_CS_AS,FCreatorID VARCHAR(44) COLLATE Chinese_PRC_CS_AS ,FCreateTime DateTime,FLastUpdateUserID VARCHAR(44) COLLATE Chinese_PRC_CS_AS ,FLastUpdateTime DateTime,FControlUnitID VARCHAR(44) COLLATE Chinese_PRC_CS_AS  DEFAULT '11111111-1111-1111-1111-111111111111CCE7AED4',CFState INT,CFUipkID VARCHAR(44) COLLATE Chinese_PRC_CS_AS ,CFESignTemplateNum NVARCHAR(100) COLLATE Chinese_PRC_CS_AS ,CFPositionX NUMERIC(28,10),CONSTRAINT CPK_ESI_ESTIDi308p PRIMARY KEY (FID));
    41. 

  41. 

  42. drop Table CT_ESI_ESignTemplateFields;
    43. 

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

  44. 

  45. drop Table CT_ESI_ESignTemplateFileEntry;
    46. 

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

  47. 

  48. drop Table CT_ESI_EsignLog;
    49. 

  49. Create Table CT_ESI_EsignLog ( FName_l1 NVARCHAR(255) COLLATE Chinese_PRC_CS_AS ,FName_l2 NVARCHAR(255) COLLATE Chinese_PRC_CS_AS ,FName_l3 NVARCHAR(255) COLLATE Chinese_PRC_CS_AS ,FNumber NVARCHAR(80) COLLATE Chinese_PRC_CS_AS ,FDescription_l1 NVARCHAR(255) COLLATE Chinese_PRC_CS_AS ,FDescription_l2 NVARCHAR(255) COLLATE Chinese_PRC_CS_AS ,FDescription_l3 NVARCHAR(255) COLLATE Chinese_PRC_CS_AS ,FSimpleName NVARCHAR(80) COLLATE Chinese_PRC_CS_AS ,FID VARCHAR(44)  DEFAULT '' NOT NULL COLLATE Chinese_PRC_CS_AS ,FCreatorID VARCHAR(44) COLLATE Chinese_PRC_CS_AS ,FCreateTime DateTime,FLastUpdateUserID VARCHAR(44) COLLATE Chinese_PRC_CS_AS ,FLastUpdateTime DateTime,FControlUnitID VARCHAR(44) COLLATE Chinese_PRC_CS_AS  DEFAULT '11111111-1111-1111-1111-111111111111CCE7AED4',CFAdminOrgUnitID VARCHAR(44) COLLATE Chinese_PRC_CS_AS ,CFUrl NVARCHAR(800) COLLATE Chinese_PRC_CS_AS,CFEsiginName NVARCHAR(1000) COLLATE Chinese_PRC_CS_AS ,CFRequestData NText  COLLATE Chinese_PRC_CS_AS ,CFResponseData NText  COLLATE Chinese_PRC_CS_AS ,CFSource NVARCHAR(100) COLLATE Chinese_PRC_CS_AS ,CFMsg NVARCHAR(500) COLLATE Chinese_PRC_CS_AS ,CFRequestState NVARCHAR(100) COLLATE Chinese_PRC_CS_AS ,CONSTRAINT CPK_ESI_EsignLo835 PRIMARY KEY (FID));
    50. 

  50. 

  51. drop Table CT_ESI_FieldMapping;
    52. 

  52. Create Table CT_ESI_FieldMapping ( FCreatorID VARCHAR(44) COLLATE Chinese_PRC_CS_AS ,FCreateTime DateTime,FLastUpdateUserID VARCHAR(44) COLLATE Chinese_PRC_CS_AS ,FLastUpdateTime DateTime,FControlUnitID VARCHAR(44) COLLATE Chinese_PRC_CS_AS ,FNumber NVARCHAR(80) COLLATE Chinese_PRC_CS_AS ,FBizDate DateTime,FHandlerID VARCHAR(44) COLLATE Chinese_PRC_CS_AS ,FDescription NVARCHAR(80) COLLATE Chinese_PRC_CS_AS ,FHasEffected INT,FAuditorID VARCHAR(44) COLLATE Chinese_PRC_CS_AS ,FSourceBillID NVARCHAR(80) COLLATE Chinese_PRC_CS_AS ,FSourceFunction NVARCHAR(80) COLLATE Chinese_PRC_CS_AS ,FID VARCHAR(44) DEFAULT '' NOT NULL COLLATE Chinese_PRC_CS_AS,FFivouchered INT,CFName NVARCHAR(100) COLLATE Chinese_PRC_CS_AS ,CFDataSourceID VARCHAR(44) COLLATE Chinese_PRC_CS_AS ,CFESignFileID VARCHAR(44) COLLATE Chinese_PRC_CS_AS ,CFDataInterface NVARCHAR(100) COLLATE Chinese_PRC_CS_AS ,CONSTRAINT CPK_ESI_FieldMIjr0 PRIMARY KEY (FID));
    53. 

  53. 

  54. drop Table CT_ESI_FieldMappingEntry;
    55. 

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

  56. 

  57. drop Table CT_ESI_FileTab;
    58. 

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

  59. 

  60. drop Table CT_ESI_GeneralESignBill;
    61. 

  61. Create Table CT_ESI_GeneralESignBill ( FCreatorID VARCHAR(44) COLLATE Chinese_PRC_CS_AS ,FCreateTime DateTime,FLastUpdateUserID VARCHAR(44) COLLATE Chinese_PRC_CS_AS ,FLastUpdateTime DateTime,FControlUnitID VARCHAR(44) COLLATE Chinese_PRC_CS_AS ,FNumber NVARCHAR(80) COLLATE Chinese_PRC_CS_AS ,FBizDate DateTime,FHandlerID VARCHAR(44) COLLATE Chinese_PRC_CS_AS ,FDescription NVARCHAR(80) COLLATE Chinese_PRC_CS_AS ,FHasEffected INT,FAuditorID VARCHAR(44) COLLATE Chinese_PRC_CS_AS ,FSourceBillID NVARCHAR(80) COLLATE Chinese_PRC_CS_AS ,FSourceFunction NVARCHAR(80) COLLATE Chinese_PRC_CS_AS ,FID VARCHAR(44) DEFAULT '' NOT NULL COLLATE Chinese_PRC_CS_AS,FFivouchered INT,CFPersonID VARCHAR(44) COLLATE Chinese_PRC_CS_AS ,CFAdminOrgID VARCHAR(44) COLLATE Chinese_PRC_CS_AS ,CFPositionID VARCHAR(44) COLLATE Chinese_PRC_CS_AS ,CFESignFileTemplat VARCHAR(44) COLLATE Chinese_PRC_CS_AS ,CFIssueStatus INT,CFESignMappingID VARCHAR(44) COLLATE Chinese_PRC_CS_AS ,CONSTRAINT CPK_ESI_JnrlESBrm8 PRIMARY KEY (FID));
    62. 

  62. 

  63. drop Table CT_ESI_Seal;
    64. 

  64. Create Table CT_ESI_Seal ( FName_l1 NVARCHAR(255) COLLATE Chinese_PRC_CS_AS ,FName_l2 NVARCHAR(255) COLLATE Chinese_PRC_CS_AS ,FName_l3 NVARCHAR(255) COLLATE Chinese_PRC_CS_AS ,FNumber NVARCHAR(80) COLLATE Chinese_PRC_CS_AS ,FDescription_l1 NVARCHAR(255) COLLATE Chinese_PRC_CS_AS ,FDescription_l2 NVARCHAR(255) COLLATE Chinese_PRC_CS_AS ,FDescription_l3 NVARCHAR(255) COLLATE Chinese_PRC_CS_AS ,FSimpleName NVARCHAR(80) COLLATE Chinese_PRC_CS_AS ,FID VARCHAR(44) DEFAULT '' NOT NULL COLLATE Chinese_PRC_CS_AS,FCreatorID VARCHAR(44) COLLATE Chinese_PRC_CS_AS ,FCreateTime DateTime,FLastUpdateUserID VARCHAR(44) COLLATE Chinese_PRC_CS_AS ,FLastUpdateTime DateTime,FControlUnitID VARCHAR(44) COLLATE Chinese_PRC_CS_AS  DEFAULT '11111111-1111-1111-1111-111111111111CCE7AED4',CFOrgId NVARCHAR(255) COLLATE Chinese_PRC_CS_AS ,CFSealId NVARCHAR(255) COLLATE Chinese_PRC_CS_AS ,CFSealName NVARCHAR(100) COLLATE Chinese_PRC_CS_AS ,CFSealCreateTime DateTime,CFDefaultSealFlag INT,CFSealHeight INT,CFSealWidth INT,CFSealBizType NVARCHAR(1000) COLLATE Chinese_PRC_CS_AS ,CFSealBizTypeDescription NVARCHAR(1000) COLLATE Chinese_PRC_CS_AS ,CFSealStyle INT,CFEffectiveTime DateTime,CFExpireTime DateTime,CFSealAuthBizId NVARCHAR(200) COLLATE Chinese_PRC_CS_AS ,CFAuthorizerOrgName NVARCHAR(100) COLLATE Chinese_PRC_CS_AS ,CFAuthorizerOrgId NVARCHAR(200) COLLATE Chinese_PRC_CS_AS ,CFAuthorizer INT,CFSealStatus INT,CONSTRAINT CPK_ESI_SealID26d2 PRIMARY KEY (FID));
    65. 

  65. 

  66.