Etusivu Tutki Apua
Kirjaudu sisään
LiuYing
/
jiuzhoutong
1
0
Fork 0
Tiedostot Ongelmat 0 Pull-pyynnöt 0 Wiki
Haara: master
Haarat Tagit
jiuzhoutong
/
sql
/
CreateTable（日志和企业信息）.sql

CreateTable（日志和企业信息）.sql 6.9 KB
Pysyvä linkki Historia Raaka

1234567891011121314151617181920212223 
  1. --Create Table CT_INT_LogInfo ( 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,CFInterfaceAddress NVARCHAR(100),CFEntrance NVARCHAR(100),CFStatus NVARCHAR(100),CFInterfaceName NVARCHAR(100),CFInParameter NVARCHAR(255),CFOutParameter NVARCHAR(255),CFXReqNonce NVARCHAR(100),CFErrorInfo NVARCHAR(255),CONSTRAINT CPK_INT_LogInfook9 PRIMARY KEY (FID));
    2. 

  2. 

  3. --Create Table CT_TK_TaskRequestParam ( 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',CFParamContent NVARCHAR(2000),CFTaskID VARCHAR(44),CONSTRAINT CPK_TK_TaskRPIDjr0 PRIMARY KEY (FID));
    4. 

  4. 

  5. --Create Table CT_TK_TaskRequestResult ( 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',CFResultContent NVARCHAR(2000),CFTaskID VARCHAR(44),CONSTRAINT CPK_TK_TaskRRIDnfr PRIMARY KEY (FID));
    6. 

  6. 

  7. Create Table CT_REG_RegistrationInfo ( 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',CFDjxhid NVARCHAR(100),CFQymc NVARCHAR(100),CFFrxm NVARCHAR(100),CFLxdh NVARCHAR(100),CFScjydz NVARCHAR(100),CFHymc NVARCHAR(100),CFZgswjgmc NVARCHAR(100),CFZgswjg NVARCHAR(100),CFZgswjgskdm NVARCHAR(100),CFZgswjgskmc NVARCHAR(100),CFFbmba NVARCHAR(100),CFSmzh NVARCHAR(100),CFShxydm NVARCHAR(100),CFNsrsbm NVARCHAR(100),CFYzbm NVARCHAR(100),CFCwxm NVARCHAR(100),CFHydm NVARCHAR(100),CFJjlxdm NVARCHAR(100),CFJjlxmc NVARCHAR(100),CFSsglydm NVARCHAR(100),CFBsrxm NVARCHAR(100),CFJdxzdm NVARCHAR(100),CFKjywrdm NVARCHAR(100),CFDjrq NVARCHAR(100),CFSwjgdm NVARCHAR(100),CFSwjgmc NVARCHAR(100),CFSfscjyqy NVARCHAR(100),CFNsrztdm NVARCHAR(100),CFNsrztmc NVARCHAR(100),CONSTRAINT CPK_REG_Rjstrxn59h PRIMARY KEY (FID));
    8. 

  8. 

  9. --Create Table CT_TK_Task ( 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,CFUrl NVARCHAR(1500),CFRequestId NVARCHAR(100),CFRequestType VARCHAR(100),CFRequestState VARCHAR(100),CFName NVARCHAR(50),CFOrder INT,CFOsfServiceName NVARCHAR(150),CFRequestParamID VARCHAR(44),CFRequestResultID VARCHAR(44),CFCalTime DateTime,CFState INT,CFCatalog INT,CONSTRAINT CPK_TK_TaskIDsvq8q PRIMARY KEY (FID));
    10. 

  10. Create Table CT_TK_Task ( CFExecutionStatus VARCHAR(50),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,CFUrl NVARCHAR(1500),CFRequestId NVARCHAR(100),CFRequestType VARCHAR(100),CFRequestState VARCHAR(100),CFName NVARCHAR(50),CFOrder INT,CFOsfServiceName NVARCHAR(150),CFRequestParamID VARCHAR(44),CFRequestResultID VARCHAR(44),CFCalTime DateTime,CFState INT,CFCatalog INT,CFTaskPreID VARCHAR(44),CONSTRAINT CPK_TK_TaskIDsvq8q PRIMARY KEY (FID));
    11. 

  11. 

  12. Create Table CT_INT_LogInfo ( 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,CFInterfaceAddress NVARCHAR(1000),CFEntrance NVARCHAR(100),CFStatus NVARCHAR(100),CFInterfaceName NVARCHAR(100),CFInParameter NCLOB(5000),CFOutParameter NCLOB(6000),CFXReqNonce NVARCHAR(100),CFErrorInfo NVARCHAR(255),CONSTRAINT CPK_INT_LogInfook9 PRIMARY KEY (FID));
    13. 

  13. 

  14. Create Table CT_TK_TaskRequestParam ( 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',CFParamContent NCLOB(10000),CFTaskID VARCHAR(44),CONSTRAINT CPK_TK_TaskRPIDjr0 PRIMARY KEY (FID));
    15. 

  15. 

  16. Create Table CT_TK_TaskRequestResult ( 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',CFResultContent NCLOB(10000),CFTaskID VARCHAR(44),CONSTRAINT CPK_TK_TaskRRIDnfr PRIMARY KEY (FID));
    17. 

  17. 

  18. Create Table CT_IND_TaxPaymentBackCalculate ( FFivouchered INT DEFAULT 0,CFPersonID VARCHAR(44),CFPeriodMonth VARCHAR(100),CFPeriodYear VARCHAR(100),CFIndividual NUMERIC(28,10),CFSalarySum NUMERIC(28,10),CFCmpschemeID VARCHAR(44),CFTaxItemPlan VARCHAR(100),FNumber NVARCHAR(100),FBizDate DateTime,FHandlerID VARCHAR(44),FDescription VARCHAR(100),FHasEffected INT,FAuditorID VARCHAR(44),FSourceBillID VARCHAR(100),FSourceFunction VARCHAR(100),FCreatorID VARCHAR(44),FCreateTime DateTime,FLastUpdateUserID VARCHAR(44),FLastUpdateTime DateTime,FControlUnitID VARCHAR(44),FID VARCHAR(44) DEFAULT '' NOT NULL ,CONSTRAINT PK_TaxPaymentBackC PRIMARY KEY (FID));
    19. 

  19. ALTER TABLE CT_INT_LOGINFO
    20. 

  20. MODIFY (CFOUTPARAMETER NCLOB(8000));
    21. 

  21. 

  22. ALTER TABLE CT_INT_LOGINFO
    23. 

  23. MODIFY (CFINPARAMETER NCLOB(6000));
    24.