CDP协同开发平台 / 企业管理 / 物理模型图（4）

--建表脚本--

create table T_CDP_PublishApp(

FID int not null  comment '内码'

,FNumber nvarchar(50) default null  comment '应用简称'

,FNAME nvarchar(50) default null  comment '应用名称'

,FAPPLYTIME datetime default null  comment '申请日期'

,FAPPLIANTID int default null  comment '申请人'

,FAPPLICANTNAME nvarchar(50) default null  comment '申请人姓名'

,FPROJECTID int default null  comment '项目内码'

,FDEVELOPETYPE char(1) default null  comment '应用来源'

,FCONTACTID int default null  comment '联系人内码'

,FCONTACTIDMOBLE nvarchar(50) default null  comment '联系人手机'

,FCONTACTNAME nvarchar(50) default null  comment '联系人姓名'

,FPKGID nvarchar(50) default null  comment '构建版本'

,FPRODUCT nvarchar(50) default null  comment '产品类型'

,FVERSION nvarchar(50) default null  comment '适用版本'

,FNOTE nvarchar(50) default null  comment '版本说明'

,FREMARKS nvarchar(100) default null  comment '应用简介'

,FCANPRACTICE char(1) default null  comment '是否可以体验'

,FTITLE nvarchar(50) default null  comment '标题'

,FKEYWORDS nvarchar(50) default null  comment '关键字'

,FDESCRIPTION nvarchar(255) default null  comment '描述'

,FDETAIL nvarchar(255) default null  comment '应用详细'

,FORGID int default null  comment '所属企业'

,FAPPORGNAME nvarchar(80) default null  comment '应用提供商'

,FINFOSTATUS nvarchar(50) default null  comment '信息状态'

,FAPPROVEDATE datetime default null  comment '审批日期'

,FSTATUS nvarchar(50) default null  comment '审批结果'

,FAPPROVEID nvarchar(50) default null  comment '审批人'

,FAPPROVENAME nvarchar(50) default null  comment '审批人姓名'

,FAPPROVEREMARKS nvarchar(255) default null  comment '审批意见'

,FSTARTDATE datetime default null  comment '应用生效日期'

,FENDDATE datetime default null  comment '应用失效日期'

,FAPPROVENOTE nvarchar(255) default null  comment '审批备注'

,FLOGO nvarchar(400) default null  comment '应用logo'

,primary key (FID)

) comment = '发布应用'

--查询--

select FID as "fid",FNumber as "fnumber",FNAME as "fname",FAPPLYTIME as "fapplytime",FAPPLIANTID as "fappliantid",FAPPLICANTNAME as "fapplicantname",FPROJECTID as "fprojectid",FDEVELOPETYPE as "fdevelopetype",FCONTACTID as "fcontactid",FCONTACTIDMOBLE as "fcontactidmoble",FCONTACTNAME as "fcontactname",FPKGID as "fpkgid",FPRODUCT as "fproduct",FVERSION as "fversion",FNOTE as "fnote",FREMARKS as "fremarks",FCANPRACTICE as "fcanpractice",FTITLE as "ftitle",FKEYWORDS as "fkeywords",FDESCRIPTION as "fdescription",FDETAIL as "fdetail",FORGID as "forgid",FAPPORGNAME as "fapporgname",FINFOSTATUS as "finfostatus",FAPPROVEDATE as "fapprovedate",FSTATUS as "fstatus",FAPPROVEID as "fapproveid",FAPPROVENAME as "fapprovename",FAPPROVEREMARKS as "fapproveremarks",FSTARTDATE as "fstartdate",FENDDATE as "fenddate",FAPPROVENOTE as "fapprovenote",FLOGO as "flogo" from T_CDP_PublishApp

--查询(中文字段)--

select FID as "内码",FNumber as "应用简称",FNAME as "应用名称",FAPPLYTIME as "申请日期",FAPPLIANTID as "申请人",FAPPLICANTNAME as "申请人姓名",FPROJECTID as "项目内码",FDEVELOPETYPE as "应用来源",FCONTACTID as "联系人内码",FCONTACTIDMOBLE as "联系人手机",FCONTACTNAME as "联系人姓名",FPKGID as "构建版本",FPRODUCT as "产品类型",FVERSION as "适用版本",FNOTE as "版本说明",FREMARKS as "应用简介",FCANPRACTICE as "是否可以体验",FTITLE as "标题",FKEYWORDS as "关键字",FDESCRIPTION as "描述",FDETAIL as "应用详细",FORGID as "所属企业",FAPPORGNAME as "应用提供商",FINFOSTATUS as "信息状态",FAPPROVEDATE as "审批日期",FSTATUS as "审批结果",FAPPROVEID as "审批人",FAPPROVENAME as "审批人姓名",FAPPROVEREMARKS as "审批意见",FSTARTDATE as "应用生效日期",FENDDATE as "应用失效日期",FAPPROVENOTE as "审批备注",FLOGO as "应用logo" from T_CDP_PublishApp

--INSERT脚本--

insert into T_CDP_PublishApp(FID,FNumber,FNAME,FAPPLYTIME,FAPPLIANTID,FAPPLICANTNAME,FPROJECTID,FDEVELOPETYPE,FCONTACTID,FCONTACTIDMOBLE,FCONTACTNAME,FPKGID,FPRODUCT,FVERSION,FNOTE,FREMARKS,FCANPRACTICE,FTITLE,FKEYWORDS,FDESCRIPTION,FDETAIL,FORGID,FAPPORGNAME,FINFOSTATUS,FAPPROVEDATE,FSTATUS,FAPPROVEID,FAPPROVENAME,FAPPROVEREMARKS,FSTARTDATE,FENDDATE,FAPPROVENOTE,FLOGO) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_CDP_PublishApp set FID=?,FNumber=?,FNAME=?,FAPPLYTIME=?,FAPPLIANTID=?,FAPPLICANTNAME=?,FPROJECTID=?,FDEVELOPETYPE=?,FCONTACTID=?,FCONTACTIDMOBLE=?,FCONTACTNAME=?,FPKGID=?,FPRODUCT=?,FVERSION=?,FNOTE=?,FREMARKS=?,FCANPRACTICE=?,FTITLE=?,FKEYWORDS=?,FDESCRIPTION=?,FDETAIL=?,FORGID=?,FAPPORGNAME=?,FINFOSTATUS=?,FAPPROVEDATE=?,FSTATUS=?,FAPPROVEID=?,FAPPROVENAME=?,FAPPROVEREMARKS=?,FSTARTDATE=?,FENDDATE=?,FAPPROVENOTE=?,FLOGO=? where FID=?

--delete脚本--

delete from T_CDP_PublishApp where FID=?

--给字段加备注--

alter table T_CDP_PublishApp comment '发布应用';

alter table T_CDP_PublishApp modify column FID int not null  comment '内码';

alter table T_CDP_PublishApp modify column FNumber nvarchar(50) default null  comment '应用简称';

alter table T_CDP_PublishApp modify column FNAME nvarchar(50) default null  comment '应用名称';

alter table T_CDP_PublishApp modify column FAPPLYTIME datetime default null  comment '申请日期';

alter table T_CDP_PublishApp modify column FAPPLIANTID int default null  comment '申请人';

alter table T_CDP_PublishApp modify column FAPPLICANTNAME nvarchar(50) default null  comment '申请人姓名';

alter table T_CDP_PublishApp modify column FPROJECTID int default null  comment '项目内码';

alter table T_CDP_PublishApp modify column FDEVELOPETYPE char(1) default null  comment '应用来源';

alter table T_CDP_PublishApp modify column FCONTACTID int default null  comment '联系人内码';

alter table T_CDP_PublishApp modify column FCONTACTIDMOBLE nvarchar(50) default null  comment '联系人手机';

alter table T_CDP_PublishApp modify column FCONTACTNAME nvarchar(50) default null  comment '联系人姓名';

alter table T_CDP_PublishApp modify column FPKGID nvarchar(50) default null  comment '构建版本';

alter table T_CDP_PublishApp modify column FPRODUCT nvarchar(50) default null  comment '产品类型';

alter table T_CDP_PublishApp modify column FVERSION nvarchar(50) default null  comment '适用版本';

alter table T_CDP_PublishApp modify column FNOTE nvarchar(50) default null  comment '版本说明';

alter table T_CDP_PublishApp modify column FREMARKS nvarchar(100) default null  comment '应用简介';

alter table T_CDP_PublishApp modify column FCANPRACTICE char(1) default null  comment '是否可以体验';

alter table T_CDP_PublishApp modify column FTITLE nvarchar(50) default null  comment '标题';

alter table T_CDP_PublishApp modify column FKEYWORDS nvarchar(50) default null  comment '关键字';

alter table T_CDP_PublishApp modify column FDESCRIPTION nvarchar(255) default null  comment '描述';

alter table T_CDP_PublishApp modify column FDETAIL nvarchar(255) default null  comment '应用详细';

alter table T_CDP_PublishApp modify column FORGID int default null  comment '所属企业';

alter table T_CDP_PublishApp modify column FAPPORGNAME nvarchar(80) default null  comment '应用提供商';

alter table T_CDP_PublishApp modify column FINFOSTATUS nvarchar(50) default null  comment '信息状态';

alter table T_CDP_PublishApp modify column FAPPROVEDATE datetime default null  comment '审批日期';

alter table T_CDP_PublishApp modify column FSTATUS nvarchar(50) default null  comment '审批结果';

alter table T_CDP_PublishApp modify column FAPPROVEID nvarchar(50) default null  comment '审批人';

alter table T_CDP_PublishApp modify column FAPPROVENAME nvarchar(50) default null  comment '审批人姓名';

alter table T_CDP_PublishApp modify column FAPPROVEREMARKS nvarchar(255) default null  comment '审批意见';

alter table T_CDP_PublishApp modify column FSTARTDATE datetime default null  comment '应用生效日期';

alter table T_CDP_PublishApp modify column FENDDATE datetime default null  comment '应用失效日期';

alter table T_CDP_PublishApp modify column FAPPROVENOTE nvarchar(255) default null  comment '审批备注';

alter table T_CDP_PublishApp modify column FLOGO nvarchar(400) default null  comment '应用logo';

--建表脚本--

create table T_CDP_PublishApp_H(

FEntryID int not null  comment '内码'

,FID int default null  comment '应用发布内码'

,FSTATUSH nvarchar(50) default null  comment '审批结果'

,FAPPROVEREMARKSH nvarchar(255) default null  comment '审批意见'

,FAPPROVEDATEH datetime default null  comment '审批时间'

,FAPPROVENOTEH nvarchar(255) default null  comment '审批备注'

,FAPPROVEIDH nvarchar(50) default null  comment '审批人'

,FAPPROVENAMEH nvarchar(50) default null  comment '审批人姓名'

,FSTARTDATEH datetime default null  comment '应用生效日期'

,FENDDATEH datetime default null  comment '应用失效日期'

,primary key (FEntryID)

) comment = '应用发布-审批历史'

--查询--

select FEntryID as "fentryid",FID as "fid",FSTATUSH as "fstatush",FAPPROVEREMARKSH as "fapproveremarksh",FAPPROVEDATEH as "fapprovedateh",FAPPROVENOTEH as "fapprovenoteh",FAPPROVEIDH as "fapproveidh",FAPPROVENAMEH as "fapprovenameh",FSTARTDATEH as "fstartdateh",FENDDATEH as "fenddateh" from T_CDP_PublishApp_H

--查询(中文字段)--

select FEntryID as "内码",FID as "应用发布内码",FSTATUSH as "审批结果",FAPPROVEREMARKSH as "审批意见",FAPPROVEDATEH as "审批时间",FAPPROVENOTEH as "审批备注",FAPPROVEIDH as "审批人",FAPPROVENAMEH as "审批人姓名",FSTARTDATEH as "应用生效日期",FENDDATEH as "应用失效日期" from T_CDP_PublishApp_H

--INSERT脚本--

insert into T_CDP_PublishApp_H(FEntryID,FID,FSTATUSH,FAPPROVEREMARKSH,FAPPROVEDATEH,FAPPROVENOTEH,FAPPROVEIDH,FAPPROVENAMEH,FSTARTDATEH,FENDDATEH) values (?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_CDP_PublishApp_H set FEntryID=?,FID=?,FSTATUSH=?,FAPPROVEREMARKSH=?,FAPPROVEDATEH=?,FAPPROVENOTEH=?,FAPPROVEIDH=?,FAPPROVENAMEH=?,FSTARTDATEH=?,FENDDATEH=? where FEntryID=?

--delete脚本--

delete from T_CDP_PublishApp_H where FEntryID=?

--给字段加备注--

alter table T_CDP_PublishApp_H comment '应用发布-审批历史';

alter table T_CDP_PublishApp_H modify column FEntryID int not null  comment '内码';

alter table T_CDP_PublishApp_H modify column FID int default null  comment '应用发布内码';

alter table T_CDP_PublishApp_H modify column FSTATUSH nvarchar(50) default null  comment '审批结果';

alter table T_CDP_PublishApp_H modify column FAPPROVEREMARKSH nvarchar(255) default null  comment '审批意见';

alter table T_CDP_PublishApp_H modify column FAPPROVEDATEH datetime default null  comment '审批时间';

alter table T_CDP_PublishApp_H modify column FAPPROVENOTEH nvarchar(255) default null  comment '审批备注';

alter table T_CDP_PublishApp_H modify column FAPPROVEIDH nvarchar(50) default null  comment '审批人';

alter table T_CDP_PublishApp_H modify column FAPPROVENAMEH nvarchar(50) default null  comment '审批人姓名';

alter table T_CDP_PublishApp_H modify column FSTARTDATEH datetime default null  comment '应用生效日期';

alter table T_CDP_PublishApp_H modify column FENDDATEH datetime default null  comment '应用失效日期';

--建表脚本--

create table T_CDP_PublishApp_I(

FPKID int not null  comment '内码'

,FID int default null  comment '应用发布内码'

,FIndustry int default null  comment '行业内码'

,primary key (FPKID)

) comment = '应用发布-行业'

--查询--

select FPKID as "fpkid",FID as "fid",FIndustry as "findustry" from T_CDP_PublishApp_I

--查询(中文字段)--

select FPKID as "内码",FID as "应用发布内码",FIndustry as "行业内码" from T_CDP_PublishApp_I

--INSERT脚本--

insert into T_CDP_PublishApp_I(FPKID,FID,FIndustry) values (?,?,?)

--UPDATE脚本--

update T_CDP_PublishApp_I set FPKID=?,FID=?,FI