--建表脚本--
create table T_CDP_Institution(
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_Institution
--查询(中文字段)--
select FID as "内码",FNUMBER as "编码",FDOCUMENTSTATUS as "数据状态",FFORBIDSTATUS as "禁用状态" from T_CDP_Institution
--INSERT脚本--
insert into T_CDP_Institution(FID,FNUMBER,FDOCUMENTSTATUS,FFORBIDSTATUS) values (?,?,?,?)
--UPDATE脚本--
update T_CDP_Institution set FID=?,FNUMBER=?,FDOCUMENTSTATUS=?,FFORBIDSTATUS=? where FID=?
--delete脚本--
delete from T_CDP_Institution where FID=?
--给字段加备注--
alter table T_CDP_Institution comment '机构';
alter table T_CDP_Institution modify column FID int not null comment '内码';
alter table T_CDP_Institution modify column FNUMBER nvarchar(50) default null comment '编码';
alter table T_CDP_Institution modify column FDOCUMENTSTATUS char(1) default null comment '数据状态';
alter table T_CDP_Institution modify column FFORBIDSTATUS char(1) default null comment '禁用状态';
--建表脚本--
create table T_CDP_Institution_L(
FPKID int not null comment '内码'
,FID int default null comment '机构内码'
,FLocaleID int default null comment '多语言内码'
,FNAME nvarchar(50) default null comment '名称'
,primary key (FPKID)
) comment = '机构-多语言'
--查询--
select FPKID as "fpkid",FID as "fid",FLocaleID as "flocaleid",FNAME as "fname" from T_CDP_Institution_L
--查询(中文字段)--
select FPKID as "内码",FID as "机构内码",FLocaleID as "多语言内码",FNAME as "名称" from T_CDP_Institution_L
--INSERT脚本--
insert into T_CDP_Institution_L(FPKID,FID,FLocaleID,FNAME) values (?,?,?,?)
--UPDATE脚本--
update T_CDP_Institution_L set FPKID=?,FID=?,FLocaleID=?,FNAME=? where FPKID=?
--delete脚本--
delete from T_CDP_Institution_L where FPKID=?
--给字段加备注--
alter table T_CDP_Institution_L comment '机构-多语言';
alter table T_CDP_Institution_L modify column FPKID int not null comment '内码';
alter table T_CDP_Institution_L modify column FID int default null comment '机构内码';
alter table T_CDP_Institution_L modify column FLocaleID int default null comment '多语言内码';
alter table T_CDP_Institution_L modify column FNAME nvarchar(50) default null comment '名称';
--建表脚本--
create table T_CDP_PROJECT(
FEntryId int not null comment '内码'
,FOrgID int default null comment '项目内码'
,FDescription nvarchar(2000) default null comment '项目描述'
,FSTARTDATE datetime default null comment '计划开始日期'
,FENDDATE datetime default null comment '计划结束日期'
,FSTATUS int default null comment '项目状态'
,FCLOSEDATE datetime default null comment '结束日期'
,primary key (FEntryId)
) comment = '项目附表'
--查询--
select FEntryId as "fentryid",FOrgID as "forgid",FDescription as "fdescription",FSTARTDATE as "fstartdate",FENDDATE as "fenddate",FSTATUS as "fstatus",FCLOSEDATE as "fclosedate" from T_CDP_PROJECT
--查询(中文字段)--
select FEntryId as "内码",FOrgID as "项目内码",FDescription as "项目描述",FSTARTDATE as "计划开始日期",FENDDATE as "计划结束日期",FSTATUS as "项目状态",FCLOSEDATE as "结束日期" from T_CDP_PROJECT
--INSERT脚本--
insert into T_CDP_PROJECT(FEntryId,FOrgID,FDescription,FSTARTDATE,FENDDATE,FSTATUS,FCLOSEDATE) values (?,?,?,?,?,?,?)
--UPDATE脚本--
update T_CDP_PROJECT set FEntryId=?,FOrgID=?,FDescription=?,FSTARTDATE=?,FENDDATE=?,FSTATUS=?,FCLOSEDATE=? where FEntryId=?
--delete脚本--
delete from T_CDP_PROJECT where FEntryId=?
--给字段加备注--
alter table T_CDP_PROJECT comment '项目附表';
alter table T_CDP_PROJECT modify column FEntryId int not null comment '内码';
alter table T_CDP_PROJECT modify column FOrgID int default null comment '项目内码';
alter table T_CDP_PROJECT modify column FDescription nvarchar(2000) default null comment '项目描述';
alter table T_CDP_PROJECT modify column FSTARTDATE datetime default null comment '计划开始日期';
alter table T_CDP_PROJECT modify column FENDDATE datetime default null comment '计划结束日期';
alter table T_CDP_PROJECT modify column FSTATUS int default null comment '项目状态';
alter table T_CDP_PROJECT modify column FCLOSEDATE datetime default null comment '结束日期';
--建表脚本--
create table T_CDP_Practice(
FID int not null comment '申请内码'
,FBILLNO nvarchar(50) default null comment '申请单号'
,FAPPLICATIONID int default null comment '应用名称'
,FAPPLYTIME datetime default null comment '申请日期'
,FAPPLYREMARKS nvarchar(1000) default null comment '申请说明'
,FAPPLICANTID int default null comment '申请人'
,FAPPLICANTNAME nvarchar(50) default null comment '申请人姓名'
,FMOBILEH nvarchar(50) default null comment '申请人手机'
,FEMAILH nvarchar(50) default null comment '申请人邮箱'
,FAPPLYORGID nvarchar(50) default null comment '所属企业'
,FORGNAME nvarchar(50) default null comment '所属企业名称'
,FCPROVINCEH nvarchar(50) default null comment '所属企业所在省份'
,FCCITYH nvarchar(50) default null comment '所属企业所在城市'
,FCTYPEH nvarchar(50) default null comment '所属企业类型'
,FINFOSTATUS nvarchar(50) default null comment '信息状态'
,FSTATUS nvarchar(50) default null comment '审批结果'
,FPRACTICESITE nvarchar(50) default null comment '体验环境地址'
,FPRACTICEDB nvarchar(50) default null comment '体验账套'
,FPRACTICEUSER nvarchar(50) default null comment '体验账号'
,FPRACTICEPASSWORD nvarchar(50) default null comment '密码'
,FREMOTEADDRESS nvarchar(50) default null comment '远程连接地址'
,FREMOTEUSER nvarchar(50) default null comment '远程连接账号'
,FREMOTEPASSWORD nvarchar(50) default null comment '远程连接密码'
,FAPPROVEDATE datetime default null comment '审批日期'
,FSTARTDATE datetime default null comment '体验开始日期'
,FENDDATE datetime default null comment '体验结束日期'
,FAPPROVEREMARKS nvarchar(1000) default null comment '审批意见'
,FAPPROVENOTE nvarchar(1000) default null comment '审批备注'
,FAPPROVEID nvarchar(50) default null comment '审批人'
,FAPPROVENAME nvarchar(50) default null comment '审批人姓名'
,primary key (FID)
) comment = '申请体验'
--查询--
select FID as "fid",FBILLNO as "fbillno",FAPPLICATIONID as "fapplicationid",FAPPLYTIME as "fapplytime",FAPPLYREMARKS as "fapplyremarks",FAPPLICANTID as "fapplicantid",FAPPLICANTNAME as "fapplicantname",FMOBILEH as "fmobileh",FEMAILH as "femailh",FAPPLYORGID as "fapplyorgid",FORGNAME as "forgname",FCPROVINCEH as "fcprovinceh",FCCITYH as "fccityh",FCTYPEH as "fctypeh",FINFOSTATUS as "finfostatus",FSTATUS as "fstatus",FPRACTICESITE as "fpracticesite",FPRACTICEDB as "fpracticedb",FPRACTICEUSER as "fpracticeuser",FPRACTICEPASSWORD as "fpracticepassword",FREMOTEADDRESS as "fremoteaddress",FREMOTEUSER as "fremoteuser",FREMOTEPASSWORD as "fremotepassword",FAPPROVEDATE as "fapprovedate",FSTARTDATE as "fstartdate",FENDDATE as "fenddate",FAPPROVEREMARKS as "fapproveremarks",FAPPROVENOTE as "fapprovenote",FAPPROVEID as "fapproveid",FAPPROVENAME as "fapprovename" from T_CDP_Practice
--查询(中文字段)--
select FID as "申请内码",FBILLNO as "申请单号",FAPPLICATIONID as "应用名称",FAPPLYTIME as "申请日期",FAPPLYREMARKS as "申请说明",FAPPLICANTID as "申请人",FAPPLICANTNAME as "申请人姓名",FMOBILEH as "申请人手机",FEMAILH as "申请人邮箱",FAPPLYORGID as "所属企业",FORGNAME as "所属企业名称",FCPROVINCEH as "所属企业所在省份",FCCITYH as "所属企业所在城市",FCTYPEH as "所属企业类型",FINFOSTATUS as "信息状态",FSTATUS as "审批结果",FPRACTICESITE as "体验环境地址",FPRACTICEDB as "体验账套",FPRACTICEUSER as "体验账号",FPRACTICEPASSWORD as "密码",FREMOTEADDRESS as "远程连接地址",FREMOTEUSER as "远程连接账号",FREMOTEPASSWORD as "远程连接密码",FAPPROVEDATE as "审批日期",FSTARTDATE as "体验开始日期",FENDDATE as "体验结束日期",FAPPROVEREMARKS as "审批意见",FAPPROVENOTE as "审批备注",FAPPROVEID as "审批人",FAPPROVENAME as "审批人姓名" from T_CDP_Practice
--INSERT脚本--
insert into T_CDP_Practice(FID,FBILLNO,FAPPLICATIONID,FAPPLYTIME,FAPPLYREMARKS,FAPPLICANTID,FAPPLICANTNAME,FMOBILEH,FEMAILH,FAPPLYORGID,FORGNAME,FCPROVINCEH,FCCITYH,FCTYPEH,FINFOSTATUS,FSTATUS,FPRACTICESITE,FPRACTICEDB,FPRACTICEUSER,FPRACTICEPASSWORD,FREMOTEADDRESS,FREMOTEUSER,FREMOTEPASSWORD,FAPPROVEDATE,FSTARTDATE,FENDDATE,FAPPROVEREMARKS,FAPPROVENOTE,FAPPROVEID,FAPPROVENAME) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
--UPDATE脚本--
update T_CDP_Practice set FID=?,FBILLNO=?,FAPPLICATIONID=?,FAPPLYTIME=?,FAPPLYREMARKS=?,FAPPLICANTID=?,FAPPLICANTNAME=?,FMOBILEH=?,FEMAILH=?,FAPPLYORGID=?,FORGNAME=?,FCPROVINCEH=?,FCCITYH=?,FCTYPEH=?,FINFOSTATUS=?,FSTATUS=?,FPRACTICESITE=?,FPRACTICEDB=?,FPRACTICEUSER=?,FPRACTICEPASSWORD=?,FREMOTEADDRESS=?,FREMOTEUSER=?,FREMOTEPASSWORD=?,FAPPROVEDATE=?,FSTARTDATE=?,FENDDATE=?,FAPPROVEREMARKS=?,FAPPROVENOTE=?,FAPPROVEID=?,FAPPROVENAME=? where FID=?
--delete脚本--
delete from T_CDP_Practice where FID=?
--给字段加备注--
alter table T_CDP_Practice comment '申请体验';
alter table T_CDP_Practice modify column FID int not null comment '申请内码';
alter table T_CDP_Practice modify column FBILLNO nvarchar(50) default null comment '申请单号';
alter table T_CDP_Practice modify column FAPPLICATIONID int default null comment '应用名称';
alter table T_CDP_Practice modify column FAPPLYTIME datetime default null comment '申请日期';
alter table T_CDP_Practice modify column FAPPLYREMARKS nvarchar(1000) default null comment '申请说明';
alter table T_CDP_Practice modify column FAPPLICANTID int default null comment '申请人';
alter table T_CDP_Practice modify column FAPPLICANTNAME nvarchar(50) default null comment '申请人姓名';
alter table T_CDP_Practice modify column FMOBILEH nvarchar(50) default null comment '申请人手机';
alter table T_CDP_Practice modify column FEMAILH nvarchar(50) default null comment '申请人邮箱';
alter table T_CDP_Practice modify column FAPPLYORGID nvarchar(50) default null comment '所属企业';
alter table T_CDP_Practice modify column FORGNAME nvarchar(50) default null comment '所属企业名称';
alter table T_CDP_Practice modify column FCPROVINCEH nvarchar(50) default null comment '所属企业所在省份';
alter table T_CDP_Practice modify column FCCITYH nvarchar(50) default null comment '所属企业所在城市';
alter table T_CDP_Practice modify column FCTYPEH nvarchar(50) default null comment '所属企业类型';
alter table T_CDP_Practice modify column FINFOSTATUS nvarchar(50) default null comment '信息状态';
alter table T_CDP_Practice modify column FSTATUS nvarchar(50) default null comment '审批结果';
alter table T_CDP_Practice modify column FPRACTICESITE nvarchar(50) default null comment '体验环境地址';
alter table T_CDP_Practice modify column FPRACTICEDB nvarchar(50) default null comment '体验账套';
alter table T_CDP_Practice modify column FPRACTICEUSER nvarchar(50) default null comment '体验账号';
alter table T_CDP_Practice modify column FPRACTICEPASSWORD nvarchar(50) default null comment '密码';
alter table T_CDP_Practice modify column FREMOTEADDRESS nvarchar(50) default null comment '远程连接地址';
alter table T_CDP_Practice modify column FREMOTEUSER nvarchar(50) default null comment '远程连接账号';
alter table T_CDP_Practice modify column FREMOTEPASSWORD nvarchar(50) default null comment '远程连接密码';
alter table T_CDP_Practice modify column FAPPROVEDATE datetime default null comment '审批日期';
alter table T_CDP_Practice modify column FSTARTDATE datetime default null comment '体验开始日期';
alter table T_CDP_Practice modify column FENDDATE datetime default null comment '体验结束日期';
alter table T_CDP_Practice modify column FAPPROVEREMARKS nvarchar(1000) default null comment '审批意见';
alter table T_CDP_Practice modify column FAPPROVENOTE nvarchar(1000) default null comment '审批备注';
alter table T_CDP_Practice modify column FAPPROVEID nvarchar(50) default null comment '审批人';
alter table T_CDP_Practice modify column FAPPROVENAME nvarchar(50) default null comment '审批人姓名';
--建表脚本--
create table T_CDP_Practice_H(
FEntryID int not null comment '内码'
,FID int default null comment '申请内码'
,FSTATUSH nvarchar(50) default null comment '审批结果'
,FAPPROVEREMARKSH nvarchar(1000) default null comment '审批意见'
,FAPPROVENOTEH nvarchar(1000) default null comment '审批备注'
,FAPPROVEDATEH datetime default null comment '审批日期'
,FSTARTDATEH datetime default null comment '体验开始日期'
,FENDDATEH datetime default null comment '体验结束日期'
,FPRACTICESITEH nvarchar(50) default null comment '体验环境地址'
,FPRACTICEDBH nvarchar(50) default null comment '体验账套'
,FPRACTICEUSERH nvarchar(50) default null comment '体验账号'
,FPRACTICEPASSWORDH nvarchar(50) default null comment '密码'
,FREMOTEADDRESSH nvarchar(50) default null comment '远程连接地址'
,FREMOTEUSERH nvarchar(50) default null comment '远程连接账号'
,FREMOTEPASSWORDH nvarchar(50) default null comment '远程连接密码'
,FAPPROVEIDH nvarchar(50) default null comment '审批人'
,FAPPROVENAMEH nvarchar(50) default null comment '审批人姓名'
,primary key (FEntryID)
) comment = '申请体验-审批历史'
--查询--
select FEntryID as "fentryid",FID as "fid",FSTATUSH as "fstatush",FAPPROVEREMARKSH as "fapproveremarksh",FAPPROVENOTEH as "fapprovenoteh",FAPPROVEDATEH as "fapprovedateh",FSTARTDATEH as "fstartdateh",FENDDATEH as "fenddateh",FPRACTICESITEH as "fpracticesiteh",FPRACTICEDBH as "fpracticedbh",FPRACTICEUSERH as "fpracticeuserh",FPRACTICEPASSWORDH as "fpracticepasswordh",FREMOTEADDRESSH as "fremoteaddressh",FREMOTEUSERH as "fremoteuserh",FREMOTEPASSWORDH as "fremotepasswordh",FAPPROVEIDH as "fapproveidh",FAPPROVENAMEH as "fapprovenameh" from T_CDP_Practice_H
--查询(中文字段)--
select FEntryID as "内码",FID as "申请内码",FSTATUSH as "审批结果",FAPPROVEREMARKSH as "审批意见",FAPPROVENOTEH as "审批备注",FAPPROVEDATEH as "审批日期",FSTARTDATEH as "体验开始日期",FENDDATEH as "体验结束日期",FPRACTICESITEH as "体验环境地址",FPRACTICEDBH as "体验账套",FPRACTICEUSERH as "体验账号",FPRACTICEPASSWORDH as "密码",FREMOTEADDRESSH as "远程连接地址",FREMOTEUSERH as "远程连接账号",FREMOTEPASSWORDH as "远程连接密码",FAPPROVEIDH as "审批人",FAPPROVENAMEH as "审批人姓名" from T_CDP_Practice_H
--INSERT脚本--
insert into T_CDP_Practice_H(FEntryID,FID,FSTATUSH,FAPPROVEREMARKSH,FAPPROVENOTEH,FAPPROVEDATEH,FSTARTDATEH,FENDDATEH,FPRACTICESITEH,FPRACTICEDBH,FPRACTICEUSERH,FPRACTICEPASSWORDH,FREMOTEADDRESSH,FREMOTEUSERH,FREMOTEPASSWORDH,FAPPROVEIDH,FAPPROVENAMEH) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
--UPDATE脚本--
update T_CDP_Practice_H set FEntryID=?,FID=?,FSTATUSH=?,FAPPROVEREMARKSH=?,FAPPROVENOTEH=?,FAPPROVEDATEH=?,FSTARTDATEH=?,FENDDATEH=?,FPRACTICESITEH=?,FPRACTICEDBH=?,FPRACTICEUSERH=?,FPRACTICEPASSWORDH=?,FREMOTEADDRESSH=?,FREMOTEUSERH=?,FREMOTEPASSWORDH=?,FAPPROVEIDH=?,FAPPROVENAMEH=? where FEntryID=?
--delete脚本--
delete from T_CDP_Practice_H where FEntryID=?
--给字段加备注--
alter table T_CDP_Practice_H comment '申请体验-审批历史';
alter table T_CDP_Practice_H modify column FEntryID int not null comment '内码';
alter table T_CDP_Practice_H modify column FID int default null comment '申请内码';
alter table T_CDP_Practice_H modify column FSTATUSH nvarchar(50) default null comment '审批结果';
alter table T_CDP_Practice_H modify column FAPPROVEREMARKSH nvarchar(1000) default null comment '审批意见';
alter table T_CDP_Practice_H modify column FAPPROVENOTEH nvarchar(1000) default null comment '审批备注';
alter table T_CDP_Practice_H modify column FAPPROVEDATEH datetime default null comment '审批日期';
alter table T_CDP_Practice_H modify column FSTARTDATEH datetime default null comment '体验开始日期';
alter table T_CDP_Practice_H modify column FENDDATEH datetime default null comment '体验结束日期';
alter table T_CDP_Practice_H modify column FPRACTICESITEH nvarchar(50) default null comment '体验环境地址';
alter table T_CDP_Practice_H modify column FPRACTICEDBH nvarchar(50) default null comment '体验账套';
alter table T_CDP_Practice_H modify column FPRACTICEUSERH nvarchar(50) default null comment '体验账号';
alter table T_CDP_Practice_H modify column FPRACTICEPASSWORDH nvarchar(50) default null comment '密码';
alter table T_CDP_Practice_H modify column FREMOTEADDRESSH nvarchar(50) default null comment '远程连接地址';
alter table T_CDP_Practice_H modify column FREMOTEUSERH nvarchar(50) default null comment '远程连接账号';
alter table T_CDP_Practice_H modify column FREMOTEPASSWORDH nvarchar(50) default null comment '远程连接密码';
alter table T_CDP_Practice_H modify column FAPPROVEIDH nvarchar(50) default null comment '审批人';
alter table T_CDP_Practice_H modify column FAPPROVENAMEH nvarchar(50) default null comment '审批人姓名';
推荐阅读
