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 column FPKID int not null  comment '内码';

alter table T_CDP_DynamicNews_L modify column FDynamicID int default null  comment '平台动态内码';

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

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

--建表脚本--

create table T_CDP_NOTICE_L(

FPKID int not null  comment '内码'

,FNOTICEID int default null  comment '平台公告内码'

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

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

,primary key (FPKID)

) comment = '平台公告多语言'

--查询--

select FPKID as "fpkid",FNOTICEID as "fnoticeid",FLocaleID as "flocaleid",FSUBJECT as "fsubject" from T_CDP_NOTICE_L

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

select FPKID as "内码",FNOTICEID as "平台公告内码",FLocaleID as "地区内码",FSUBJECT as "公告标题" from T_CDP_NOTICE_L

--INSERT脚本--

insert into T_CDP_NOTICE_L(FPKID,FNOTICEID,FLocaleID,FSUBJECT) values (?,?,?,?)

--UPDATE脚本--

update T_CDP_NOTICE_L set FPKID=?,FNOTICEID=?,FLocaleID=?,FSUBJECT=? where FPKID=?

--delete脚本--

delete from T_CDP_NOTICE_L where FPKID=?

--给字段加备注--

alter table T_CDP_NOTICE_L comment '平台公告多语言';

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

alter table T_CDP_NOTICE_L modify column FNOTICEID int default null  comment '平台公告内码';

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

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

--建表脚本--

create table T_CDP_Notice(

FNOTICEID int not 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 (FNOTICEID)

) comment = '平台公告'

--查询--

select FNOTICEID as "fnoticeid",FContent as "fcontent",FPublisherID as "fpublisherid",FPublishTime as "fpublishtime",FInfoStatus as "finfostatus" from T_CDP_Notice

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

select FNOTICEID as "内码",FContent as "内容",FPublisherID as "发布人",FPublishTime as "发布日期",FInfoStatus as "信息状态" from T_CDP_Notice

--INSERT脚本--

insert into T_CDP_Notice(FNOTICEID,FContent,FPublisherID,FPublishTime,FInfoStatus) values (?,?,?,?,?)

--UPDATE脚本--

update T_CDP_Notice set FNOTICEID=?,FContent=?,FPublisherID=?,FPublishTime=?,FInfoStatus=? where FNOTICEID=?

--delete脚本--

delete from T_CDP_Notice where FNOTICEID=?

--给字段加备注--

alter table T_CDP_Notice comment '平台公告';

alter table T_CDP_Notice modify column FNOTICEID int not null  comment '内码';

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

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

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

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

--建表脚本--

create table T_CDP_ORGTYPEROLE(

FID int not null  comment '内码'

,FORGTYPE nvarchar(50) default null  comment '组织类型'

,FROLE int default null  comment '角色'

,primary key (FID)

) comment = '组织类型角色表'

--查询--

select FID as "fid",FORGTYPE as "forgtype",FROLE as "frole" from T_CDP_ORGTYPEROLE

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

select FID as "内码",FORGTYPE as "组织类型",FROLE as "角色" from T_CDP_ORGTYPEROLE

--INSERT脚本--

insert into T_CDP_ORGTYPEROLE(FID,FORGTYPE,FROLE) values (?,?,?)

--UPDATE脚本--

update T_CDP_ORGTYPEROLE set FID=?,FORGTYPE=?,FROLE=? where FID=?

--delete脚本--

delete from T_CDP_ORGTYPEROLE where FID=?

--给字段加备注--

alter table T_CDP_ORGTYPEROLE comment '组织类型角色表';

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

alter table T_CDP_ORGTYPEROLE modify column FORGTYPE nvarchar(50) default null  comment '组织类型';

alter table T_CDP_ORGTYPEROLE modify column FROLE int default null  comment '角色';