--建表脚本--
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=?,FIndustry=? where FPKID=?
--delete脚本--
delete from T_CDP_PublishApp_I where FPKID=?
--给字段加备注--
alter table T_CDP_PublishApp_I comment '应用发布-行业';
alter table T_CDP_PublishApp_I modify column FPKID int not null comment '内码';
alter table T_CDP_PublishApp_I modify column FID int default null comment '应用发布内码';
alter table T_CDP_PublishApp_I modify column FIndustry int default null comment '行业内码';
--建表脚本--
create table T_CDP_PublishApp_R(
FPKID int not null comment '内码'
,FID int default null comment '应用发布内码'
,FDomain int default null comment '领域内码'
,primary key (FPKID)
) comment = '应用发布-领域'
--查询--
select FPKID as "fpkid",FID as "fid",FDomain as "fdomain" from T_CDP_PublishApp_R
--查询(中文字段)--
select FPKID as "内码",FID as "应用发布内码",FDomain as "领域内码" from T_CDP_PublishApp_R
--INSERT脚本--
insert into T_CDP_PublishApp_R(FPKID,FID,FDomain) values (?,?,?)
--UPDATE脚本--
update T_CDP_PublishApp_R set FPKID=?,FID=?,FDomain=? where FPKID=?
--delete脚本--
delete from T_CDP_PublishApp_R where FPKID=?
--给字段加备注--
alter table T_CDP_PublishApp_R comment '应用发布-领域';
alter table T_CDP_PublishApp_R modify column FPKID int not null comment '内码';
alter table T_CDP_PublishApp_R modify column FID int default null comment '应用发布内码';
alter table T_CDP_PublishApp_R modify column FDomain int default null comment '领域内码';
--建表脚本--
create table T_CDP_Region(
FID int not null comment '内码'
,FNUMBER nvarchar(50) default null comment '编码'
,FDOCUMENTSTATUS char(1) default null comment '数据状态'
,FFORBIDSTATUS char(1) default null comment '禁用状态'
,primary key (FID)
) comment = '区域'
--查询--
select FID as "fid",FNUMBER as "fnumber",FDOCUMENTSTATUS as "fdocumentstatus",FFORBIDSTATUS as "fforbidstatus" from T_CDP_Region
--查询(中文字段)--
select FID as "内码",FNUMBER as "编码",FDOCUMENTSTATUS as "数据状态",FFORBIDSTATUS as "禁用状态" from T_CDP_Region
--INSERT脚本--
insert into T_CDP_Region(FID,FNUMBER,FDOCUMENTSTATUS,FFORBIDSTATUS) values (?,?,?,?)
--UPDATE脚本--
update T_CDP_Region set FID=?,FNUMBER=?,FDOCUMENTSTATUS=?,FFORBIDSTATUS=? where FID=?
--delete脚本--
delete from T_CDP_Region where FID=?
--给字段加备注--
alter table T_CDP_Region comment '区域';
alter table T_CDP_Region modify column FID int not null comment '内码';
alter table T_CDP_Region modify column FNUMBER nvarchar(50) default null comment '编码';
alter table T_CDP_Region modify column FDOCUMENTSTATUS char(1) default null comment '数据状态';
alter table T_CDP_Region modify column FFORBIDSTATUS char(1) default null comment '禁用状态';
--建表脚本--
create table T_CDP_Resource(
FID int not null comment '内码'
,FProjectID int default null comment '项目内码'
,FName nvarchar(255) default null comment '资源名称'
,FRESOURCETYPE nvarchar(50) default null comment '资源类型'
,primary key (FID)
) comment = '资源'
--查询--
select FID as "fid",FProjectID as "fprojectid",FName as "fname",FRESOURCETYPE as "fresourcetype" from T_CDP_Resource
--查询(中文字段)--
select FID as "内码",FProjectID as "项目内码",FName as "资源名称",FRESOURCETYPE as "资源类型" from T_CDP_Resource
--INSERT脚本--
insert into T_CDP_Resource(FID,FProjectID,FName,FRESOURCETYPE) values (?,?,?,?)
--UPDATE脚本--
update T_CDP_Resource set FID=?,FProjectID=?,FName=?,FRESOURCETYPE=? where FID=?
--delete脚本--
delete from T_CDP_Resource where FID=?
--给字段加备注--
alter table T_CDP_Resource comment '资源';
alter table T_CDP_Resource modify column FID int not null comment '内码';
alter table T_CDP_Resource modify column FProjectID int default null comment '项目内码';
alter table T_CDP_Resource modify column FName nvarchar(255) default null comment '资源名称';
alter table T_CDP_Resource modify column FRESOURCETYPE nvarchar(50) default null comment '资源类型';
--建表脚本--
create table T_CDP_USERROLE(
FDetailID int not null comment '内码'
,FENTITYID int default null comment '角色内码'
,FUSERID int default null comment '用户内码'
,primary key (FDetailID)
) comment = '项目用户角色'
--查询--
select FDetailID as "fdetailid",FENTITYID as "fentityid",FUSERID as "fuserid" from T_CDP_USERROLE
--查询(中文字段)--
select FDetailID as "内码",FENTITYID as "角色内码",FUSERID as "用户内码" from T_CDP_USERROLE
--INSERT脚本--
insert into T_CDP_USERROLE(FDetailID,FENTITYID,FUSERID) values (?,?,?)
--UPDATE脚本--
update T_CDP_USERROLE set FDetailID=?,FENTITYID=?,FUSERID=? where FDetailID=?
--delete脚本--
delete from T_CDP_USERROLE where FDetailID=?
--给字段加备注--
alter table T_CDP_USERROLE comment '项目用户角色';
alter table T_CDP_USERROLE modify column FDetailID int not null comment '内码';
alter table T_CDP_USERROLE modify column FENTITYID int default null comment '角色内码';
alter table T_CDP_USERROLE modify column FUSERID int default null comment '用户内码';
--建表脚本--
create table t_CDP_Environment(
FEnvironmentID int not null comment '内码'
,FPROJECTID int default null comment '项目内码'
,FBUILDERNUMBER nvarchar(255) default null comment '环境使用的包'
,FENVCREATORID int default null comment '环境者内码'
,FENVCREATEDATE datetime default null comment '环境创建时间'
,FENVCLOSEDATE datetime default null comment '环境关闭时间'
,FSTATUS int default null comment '环境状态'
,FDescription nvarchar(255) default null comment '测试体验环境描述'
,FVMID nvarchar(50) default null comment '虚机内码'
,FPkgID nvarchar(50) default null comment '构建包内码'
,primary key (FEnvironmentID)
) comment = '项目体验环境'
--查询--
select FEnvironmentID as "fenvironmentid",FPROJECTID as "fprojectid",FBUILDERNUMBER as "fbuildernumber",FENVCREATORID as "fenvcreatorid",FENVCREATEDATE as "fenvcreatedate",FENVCLOSEDATE as "fenvclosedate",FSTATUS as "fstatus",FDescription as "fdescription",FVMID as "fvmid",FPkgID as "fpkgid" from t_CDP_Environment
--查询(中文字段)--
select FEnvironmentID as "内码",FPROJECTID as "项目内码",FBUILDERNUMBER as "环境使用的包",FENVCREATORID as "环境者内码",FENVCREATEDATE as "环境创建时间",FENVCLOSEDATE as "环境关闭时间",FSTATUS as "环境状态",FDescription as "测试体验环境描述",FVMID as "虚机内码",FPkgID as "构建包内码" from t_CDP_Environment
--INSERT脚本--
insert into t_CDP_Environment(FEnvironmentID,FPROJECTID,FBUILDERNUMBER,FENVCREATORID,FENVCREATEDATE,FENVCLOSEDATE,FSTATUS,FDescription,FVMID,FPkgID) values (?,?,?,?,?,?,?,?,?,?)
--UPDATE脚本--
update t_CDP_Environment set FEnvironmentID=?,FPROJECTID=?,FBUILDERNUMBER=?,FENVCREATORID=?,FENVCREATEDATE=?,FENVCLOSEDATE=?,FSTATUS=?,FDescription=?,FVMID=?,FPkgID=? where FEnvironmentID=?
--delete脚本--
delete from t_CDP_Environment where FEnvironmentID=?
--给字段加备注--
alter table t_CDP_Environment comment '项目体验环境';
alter table t_CDP_Environment modify column FEnvironmentID int not null comment '内码';
alter table t_CDP_Environment modify column FPROJECTID int default null comment '项目内码';
alter table t_CDP_Environment modify column FBUILDERNUMBER nvarchar(255) default null comment '环境使用的包';
alter table t_CDP_Environment modify column FENVCREATORID int default null comment '环境者内码';
alter table t_CDP_Environment modify column FENVCREATEDATE datetime default null comment '环境创建时间';
alter table t_CDP_Environment modify column FENVCLOSEDATE datetime default null comment '环境关闭时间';
alter table t_CDP_Environment modify column FSTATUS int default null comment '环境状态';
alter table t_CDP_Environment modify column FDescription nvarchar(255) default null comment '测试体验环境描述';
alter table t_CDP_Environment modify column FVMID nvarchar(50) default null comment '虚机内码';
alter table t_CDP_Environment modify column FPkgID nvarchar(50) default null comment '构建包内码';
赞 70
打赏推荐阅读
