tengda/path/20260304/SQL脚本/CreateTable.sql

Create Table CT_ENT_DataCSFE (
    FID VARCHAR(44) DEFAULT '' NOT NULL,
    FSeq INT DEFAULT 0 NOT NULL,
    FParentID VARCHAR(44) DEFAULT '' NOT NULL,
    CFSeq INT,
    CFDataType VARCHAR(100),
    CFFieldKey NVARCHAR(2000),
    CFDatabaseName NVARCHAR(2000),
    CFFieldName NVARCHAR(100),
    CFMappingKey NVARCHAR(2000),
    CFDataEntry NVARCHAR(100),
    CONSTRAINT CPK_ENT_DataCSFcsb PRIMARY KEY (FID)
);
Create Table CT_ENT_DataConfig (
    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),
    CFOsfName NVARCHAR(100),
    CFRemarks NVARCHAR(100),
    CFSqlStr NVARCHAR(255),
    CONSTRAINT CPK_ENT_DataCIDvs9 PRIMARY KEY (FID)
);
Create Table CT_ENT_DataConfigEntry (
    FSeq INT,
    FID VARCHAR(44) DEFAULT '' NOT NULL,
    FParentID VARCHAR(44),
    CFEntryName NVARCHAR(100),
    CFEntryFull NVARCHAR(2000),
    CFAlias NVARCHAR(100),
    CFRelationFeild NVARCHAR(2000),
    CFTableName NVARCHAR(100),
    CFRelationship VARCHAR(100),
    CONSTRAINT CPK_ENT_DataCEIuv9 PRIMARY KEY (FID)
);
Create Table CT_ENT_DataConfigFieldEntry (
    FID VARCHAR(44) DEFAULT '' NOT NULL,
    FSeq INT DEFAULT 0 NOT NULL,
    FParentID VARCHAR(44) DEFAULT '' NOT NULL,
    CFSeq INT,
    CFDataType VARCHAR(100),
    CFFieldKey NVARCHAR(2000),
    CFDatabaseName NVARCHAR(2000),
    CFFieldName NVARCHAR(100),
    CFMappingKey NVARCHAR(2000),
    CFDataEntry NVARCHAR(100),
    CONSTRAINT CPK_ENT_DataCFE6lb 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)
);