CDP协同开发平台 / 平台管理 / 物理模型图

--建表脚本--

create table T_CDP_Document(

FDocumentID int not null  comment '内码'

,FType nvarchar(50) default null  comment '资料类型'

,FContent nvarchar default null  comment '内容'

,FPublisherID int default null  comment '发布人'

,FPublishTime datetime default null  comment '发布日期'

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

,primary key (FDocumentID)

) comment = '平台资料'

--查询--

select FDocumentID as "fdocumentid",FType as "ftype",FContent as "fcontent",FPublisherID as "fpublisherid",FPublishTime as "fpublishtime",FInfoStatus as "finfostatus" from T_CDP_Document

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

select FDocumentID as "内码",FType as "资料类型",FContent as "内容",FPublisherID as "发布人",FPublishTime as "发布日期",FInfoStatus as "信息状态" from T_CDP_Document

--INSERT脚本--

insert into T_CDP_Document(FDocumentID,FType,FContent,FPublisherID,FPublishTime,FInfoStatus) values (?,?,?,?,?,?)

--UPDATE脚本--

update T_CDP_Document set FDocumentID=?,FType=?,FContent=?,FPublisherID=?,FPublishTime=?,FInfoStatus=? where FDocumentID=?

--delete脚本--

delete from T_CDP_Document where FDocumentID=?

--给字段加备注--

alter table T_CDP_Document comment '平台资料';

alter table T_CDP_Document modify column FDocumentID int not null  comment '内码';

alter table T_CDP_Document modify column FType nvarchar(50) default null  comment '资料类型';

alter table T_CDP_Document modify column FContent nvarchar default null  comment '内容';

alter table T_CDP_Document modify column FPublisherID int default null  comment '发布人';

alter table T_CDP_Document modify column FPublishTime datetime default null  comment '发布日期';

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

--建表脚本--

create table T_CDP_Document_L(

FPKID int not null  comment '内码'

,FDocumentID int default null  comment '平台资料内码'

,FLocaleID int default null  comment '地区内码'

,FSUBJECT nvarchar(50) default null  comment '公告标题'

,primary key (FPKID)

) comment = '平台资料多语言'

--查询--

select FPKID as "fpkid",FDocumentID as "fdocumentid",FLocaleID as "flocaleid",FSUBJECT as "fsubject" from T_CDP_Document_L

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

select FPKID as "内码",FDocumentID as "平台资料内码",FLocaleID as "地区内码",FSUBJECT as "公告标题" from T_CDP_Document_L

--INSERT脚本--

insert into T_CDP_Document_L(FPKID,FDocumentID,FLocaleID,FSUBJECT) values (?,?,?,?)

--UPDATE脚本--

update T_CDP_Document_L set FPKID=?,FDocumentID=?,FLocaleID=?,FSUBJECT=? where FPKID=?

--delete脚本--

delete from T_CDP_Document_L where FPKID=?

--给字段加备注--

alter table T_CDP_Document_L comment '平台资料多语言';

alter table T_CDP_Document_L modify column FPKID int not null  comment '内码';

alter table T_CDP_Document_L modify column FDocumentID int default null  comment '平台资料内码';

alter table T_CDP_Document_L modify column FLocaleID int default null  comment '地区内码';

alter table T_CDP_Document_L modify column FSUBJECT nvarchar(50) default null  comment '公告标题';

--建表脚本--

create table T_CDP_DynamicNews(

FDynamicID int not null  comment '内码'

,FDynamicType nvarchar(50) default null  comment '动态类型'

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

,FContent nvarchar default null  comment '内容'

,FPublisherID int default null  comment '发布人'

,FPublishTime datetime default null  comment '发布日期'

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

,primary key (FDynamicID)

) comment = '平台动态'

--查询--

select FDynamicID as "fdynamicid",FDynamicType as "fdynamictype",FProductType as "fproducttype",FContent as "fcontent",FPublisherID as "fpublisherid",FPublishTime as "fpublishtime",FInfoStatus as "finfostatus" from T_CDP_DynamicNews

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

select FDynamicID as "内码",FDynamicType as "动态类型",FProductType as "产品类型",FContent as "内容",FPublisherID as "发布人",FPublishTime as "发布日期",FInfoStatus as "信息状态" from T_CDP_DynamicNews

--INSERT脚本--

insert into T_CDP_DynamicNews(FDynamicID,FDynamicType,FProductType,FContent,FPublisherID,FPublishTime,FInfoStatus) values (?,?,?,?,?,?,?)

--UPDATE脚本--

update T_CDP_DynamicNews set FDynamicID=?,FDynamicType=?,FProductType=?,FContent=?,FPublisherID=?,FPublishTime=?,FInfoStatus=? where FDynamicID=?

--delete脚本--

delete from T_CDP_DynamicNews where FDynamicID=?

--给字段加备注--

alter table T_CDP_DynamicNews comment '平台动态';

alter table T_CDP_DynamicNews modify column FDynamicID int not null  comment '内码';

alter table T_CDP_DynamicNews modify column FDynamicType nvarchar(50) default null  comment '动态类型';

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

alter table T_CDP_DynamicNews modify column FContent nvarchar default null  comment '内容';

alter table T_CDP_DynamicNews modify column FPublisherID int default null  comment '发布人';

alter table T_CDP_DynamicNews modify column FPublishTime datetime default null  comment '发布日期';

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

--建表脚本--

create table T_CDP_DynamicNews_L(

FPKID int not null  comment '内码'

,FDynamicID int default null  comment '平台动态内码'

,FLocaleID int default null  comment '地区内码'

,FSUBJECT nvarchar(50) default null  comment '公告标题'

,primary key (FPKID)

) comment = '平台动态多语言'

--查询--

select FPKID as "fpkid",FDynamicID as "fdynamicid",FLocaleID as "flocaleid",FSUBJECT as "fsubject" from T_CDP_DynamicNews_L

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

select FPKID as "内码",FDynamicID as "平台动态内码",FLocaleID as "地区内码",FSUBJECT as "公告标题" from T_CDP_DynamicNews_L

--INSERT脚本--

insert into T_CDP_DynamicNews_L(FPKID,FDynamicID,FLocaleID,FSUBJECT) values (?,?,?,?)

--UPDATE脚本--

update T_CDP_DynamicNews_L set FPKID=?,FDynamicID=?,FLocaleID=?,FSUBJECT=? where FPKID=?

--delete脚本--

delete from T_CDP_DynamicNews_L where FPKID=?

--给字段加备注--

alter table T_CDP_DynamicNews_L comment '平台动态多语言';

alter table T_CDP_DynamicNews_L modify