| 123456789 |
- -- 提报套打模板主表
- If not exists (select 1 from KSQL_USERTABLES where KSQL_TABNAME='CT_COM_SubmitShemeTemplate')
- Create Table CT_COM_SubmitShemeTemplate ( CFCalSubmitScheme VARCHAR(44),CFState INT DEFAULT 0,CFHrOrgUnitID VARCHAR(44),CFSelectItemCol CLOB(2000),CFBillProperties CLOB(2000),CFEntryProperties CLOB(2000),CFSchemeItems CLOB(2000),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_SubmitShemeTemp PRIMARY KEY (FID));
- -- 提报套打模板分录
- If not exists (select 1 from KSQL_USERTABLES where KSQL_TABNAME='CT_COM_SubmitSTE')
- Create Table CT_COM_SubmitSTE ( FID VARCHAR(44) DEFAULT '' NOT NULL ,FSeq INT DEFAULT 0 NOT NULL ,FParentID VARCHAR(44) DEFAULT '' NOT NULL ,CFSeq INT,CFColumn NVARCHAR(100),CFAlias NVARCHAR(100),CFTemplateField NVARCHAR(100),CFState INT,CFSorttype NVARCHAR(100),CONSTRAINT CPK_COM_SubmitS7b1 PRIMARY KEY (FID));
|
