CDP协同开发平台 / 基础框架 / 物理模型图

--建表脚本--

create table T_CDP_MENU(

FMENUID int not null  comment '内码'

,FWorkspaceID int default null  comment '工作桌面内码'

,FMenuContentID nvarchar(50) default null  comment '菜单内码'

,FVISIBLE nvarchar(50) default null  comment '可见性'

,primary key (FMENUID)

) comment = 'cdp菜单'

--查询--

select FMENUID as "fmenuid",FWorkspaceID as "fworkspaceid",FMenuContentID as "fmenucontentid",FVISIBLE as "fvisible" from T_CDP_MENU

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

select FMENUID as "内码",FWorkspaceID as "工作桌面内码",FMenuContentID as "菜单内码",FVISIBLE as "可见性" from T_CDP_MENU

--INSERT脚本--

insert into T_CDP_MENU(FMENUID,FWorkspaceID,FMenuContentID,FVISIBLE) values (?,?,?,?)

--UPDATE脚本--

update T_CDP_MENU set FMENUID=?,FWorkspaceID=?,FMenuContentID=?,FVISIBLE=? where FMENUID=?

--delete脚本--

delete from T_CDP_MENU where FMENUID=?

--给字段加备注--

alter table T_CDP_MENU comment 'cdp菜单';

alter table T_CDP_MENU modify column FMENUID int not null  comment '内码';

alter table T_CDP_MENU modify column FWorkspaceID int default null  comment '工作桌面内码';

alter table T_CDP_MENU modify column FMenuContentID nvarchar(50) default null  comment '菜单内码';

alter table T_CDP_MENU modify column FVISIBLE nvarchar(50) default null  comment '可见性';

--建表脚本--

create table T_CDP_MENUDETAIL(

FMenuDetailID int not null  comment '内码'

,FMENUID int default null  comment '菜单内码'

,FDetailContentID nvarchar(50) default null  comment '菜单明细内码'

,FVISIBLE nvarchar(50) default null  comment '可见性'

,primary key (FMenuDetailID)

) comment = 'cdp菜单明细'

--查询--

select FMenuDetailID as "fmenudetailid",FMENUID as "fmenuid",FDetailContentID as "fdetailcontentid",FVISIBLE as "fvisible" from T_CDP_MENUDETAIL

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

select FMenuDetailID as "内码",FMENUID as "菜单内码",FDetailContentID as "菜单明细内码",FVISIBLE as "可见性" from T_CDP_MENUDETAIL

--INSERT脚本--

insert into T_CDP_MENUDETAIL(FMenuDetailID,FMENUID,FDetailContentID,FVISIBLE) values (?,?,?,?)

--UPDATE脚本--

update T_CDP_MENUDETAIL set FMenuDetailID=?,FMENUID=?,FDetailContentID=?,FVISIBLE=? where FMenuDetailID=?

--delete脚本--

delete from T_CDP_MENUDETAIL where FMenuDetailID=?

--给字段加备注--

alter table T_CDP_MENUDETAIL comment 'cdp菜单明细';

alter table T_CDP_MENUDETAIL modify column FMenuDetailID int not null  comment '内码';

alter table T_CDP_MENUDETAIL modify column FMENUID int default null  comment '菜单内码';

alter table T_CDP_MENUDETAIL modify column FDetailContentID nvarchar(50) default null  comment '菜单明细内码';

alter table T_CDP_MENUDETAIL modify column FVISIBLE nvarchar(50) default null  comment '可见性';

--建表脚本--

create table T_CDP_MenuContent(

FMenuContentID nvarchar(50) not null  comment '菜单内容内码'

,FNUMBER nvarchar(50) default null  comment '编码'

,FPARAM nvarchar(50) default null  comment '参数'

,FSEQ int default null  comment '顺序'

,primary key (FMenuContentID)

) comment = '菜单内容'

--查询--

select FMenuContentID as "fmenucontentid",FNUMBER as "fnumber",FPARAM as "fparam",FSEQ as "fseq" from T_CDP_MenuContent

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

select FMenuContentID as "菜单内容内码",FNUMBER as "编码",FPARAM as "参数",FSEQ as "顺序" from T_CDP_MenuContent

--INSERT脚本--

insert into T_CDP_MenuContent(FMenuContentID,FNUMBER,FPARAM,FSEQ) values (?,?,?,?)

--UPDATE脚本--

update T_CDP_MenuContent set FMenuContentID=?,FNUMBER=?,FPARAM=?,FSEQ=? where FMenuContentID=?

--delete脚本--

delete from T_CDP_MenuContent where FMenuContentID=?

--给字段加备注--

alter table T_CDP_MenuContent comment '菜单内容';

alter table T_CDP_MenuContent modify column FMenuContentID nvarchar(50) not null  comment '菜单内容内码';

alter table T_CDP_MenuContent modify column FNUMBER nvarchar(50) default null  comment '编码';

alter table T_CDP_MenuContent modify column FPARAM nvarchar(50) default null  comment '参数';

alter table T_CDP_MenuContent modify column FSEQ int default null  comment '顺序';

--建表脚本--

create table T_CDP_MenuContent_L(

FPKID nvarchar(50) not null  comment '内码'

,FMenuContentID nvarchar(50) default null  comment '菜单内容内码'

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

,FNAME nvarchar(50) default null  comment '名字'

,primary key (FPKID)

) comment = '菜单内容多语言'

--查询--

select FPKID as "fpkid",FMenuContentID as "fmenucontentid",FLocaleID as "flocaleid",FNAME as "fname" from T_CDP_MenuContent_L

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

select FPKID as "内码",FMenuContentID as "菜单内容内码",FLocaleID as "地区内码",FNAME as "名字" from T_CDP_MenuContent_L

--INSERT脚本--

insert into T_CDP_MenuContent_L(FPKID,FMenuContentID,FLocaleID,FNAME) values (?,?,?,?)

--UPDATE脚本--

update T_CDP_MenuContent_L set FPKID=?,FMenuContentID=?,FLocaleID=?,FNAME=? where FPKID=?

--delete脚本--

delete from T_CDP_MenuContent_L where FPKID=?

--给字段加备注--

alter table T_CDP_MenuContent_L comment '菜单内容多语言';

alter table T_CDP_MenuContent_L modify column FPKID nvarchar(50) not null  comment '内码';

alter table T_CDP_MenuContent_L modify column FMenuContentID nvarchar(50) default null  comment '菜单内容内码';

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

alter table T_CDP_MenuContent_L modify column FNAME nvarchar(50) default null  comment '名字';

--建表脚本--

create table T_CDP_MenuDetailContent(

FDetailContentID nvarchar(50) not null  comment '明细内码'

,FMenuContentID nvarchar(50) default null  comment '菜单内容内码'

,FNUMBER nvarchar(50) default null  comment '编码'

,FPARAM nvarchar(255) default null  comment '参数'

,FSEQ int default null  comment '顺序'

,primary key (FDetailContentID)

) comment = '菜单明细内容'

--查询--

select FDetailContentID as "fdetailcontentid",FMenuContentID as "fmenucontentid",FNUMBER as "fnumber",FPARAM as "fparam",FSEQ as "fseq" from T_CDP_MenuDetailContent

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

select FDetailContentID as "明细内码",FMenuContentID as "菜单内容内码",FNUMBER as "编码",FPARAM as "参数",FSEQ as "顺序" from T_CDP_MenuDetailContent

--INSERT脚本--

insert into T_CDP_MenuDetailContent(FDetailContentID,FMenuContentID,FNUMBER,FPARAM,FSEQ) values (?,?,?,?,?)

--UPDATE脚本--

update T_CDP_MenuDetailContent set FDetailContentID=?,FMenuContentID=?,FNUMBER=?,FPARAM=?,FSEQ=? where FDetailContentID=?

--delete脚本--

delete from T_CDP_MenuDetailContent where FDetailContentID=?

--给字段加备注--

alter table T_CDP_MenuDetailContent comment '菜单明细内容';

alter table T_CDP_MenuDetailContent modify column FDetailContentID nvarchar(50) not null  comment '明细内码';

alter table T_CDP_MenuDetailContent modify column FMenuContentID nvarchar(50) default null  comment '菜单内容内码';

alter table T_CDP_MenuDetailContent modify column FNUMBER nvarchar(50) default null  comment '编码';

alter table T_CDP_MenuDetailContent modify column FPARAM nvarchar(255) default null  comment '参数';

alter table T_CDP_MenuDetailContent modify column FSEQ int default null  comment '顺序';

--建表脚本--

create table T_CDP_MenuDetailContent_L(

FPKID nvarchar(50) not null  comment '内码'

,FDetailContentID nvarchar(50) default null  comment '明细内码'

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

,FNAME nvarchar(50) default null  comment '名字'

,primary key (FPKID)

) comment = '菜单明细内容多语言'

--查询--

select FPKID as "fpkid",FDetailContentID as "fdetailcontentid",FLocaleID as "flocaleid",FNAME as "fname" from T_CDP_MenuDetailContent_L

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

select FPKID as "内码",FDetailContentID as "明细内码",FLocaleID as "地区内码",FNAME as "名字" from T_CDP_MenuDetailContent_L

--INSERT脚本--

insert into T_CDP_MenuDetailContent_L(FPKID,FDetailContentID,FLocaleID,FNAME) values (?,?,?,?)

--UPDATE脚本--

update T_CDP_MenuDetailContent_L set FPKID=?,FDetailContentID=?,FLocaleID=?,FNAME=? where FPKID=?

--delete脚本--

delete from T_CDP_MenuDetailContent_L where FPKID=?

--给字段加备注--

alter table T_CDP_MenuDetailContent_L comment '菜单明细内容多语言';

alter table T_CDP_MenuDetailContent_L modify column FPKID nvarchar(50) not null  comment '内码';

alter table T_CDP_MenuDetailContent_L modify column FDetailContentID nvarchar(50) default null  comment '明细内码';

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

alter table T_CDP_MenuDetailContent_L modify column FNAME nvarchar(50) default null  comment '名字';

--建表脚本--

create table T_CDP_Workspace(

FWorkspaceID int not null  comment '内码'

,FORGID int default null  comment '组织编码'

,FROLE int default null  comment '角色'

,FType nvarchar(50) default null  comment '认证类型'

,FWorkspace int default null  comment '工作桌面'

,Fdescription nvarchar(50) default null  comment '描述'

,FMethod nvarchar(50) default null  comment '方法'

,primary key (FWorkspaceID)

) comment = '工作桌面'

--查询--

select FWorkspaceID as "fworkspaceid",FORGID as "forgid",FROLE as "frole",FType as "ftype",FWorkspace as "fworkspace",Fdescription as "fdescription",FMethod as "fmethod" from T_CDP_Workspace

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

select FWorkspaceID as "内码",FORGID as "组织编码",FROLE as "角色",FType as "认证类型",FWorkspace as "工作桌面",Fdescription as "描述",FMethod as "方法" from T_CDP_Workspace

--INSERT脚本--

insert into T_CDP_Workspace(FWorkspaceID,FORGID,FROLE,FType,FWorkspace,Fdescription,FMethod) values (?,?,?,?,?,?,?)

--UPDATE脚本--

update T_CDP_Workspace set FWorkspaceID=?,FORGID=?,FROLE=?,FType=?,FWorkspace=?,Fdescription=?,FMethod=? where FWorkspaceID=?

--delete脚本--

delete from T_CDP_Workspace where FWorkspaceID=?

--给字段加备注--

alter table T_CDP_Workspace comment '工作桌面';

alter table T_CDP_Workspace modify column FWorkspaceID int not null  comment '内码';

alter table T_CDP_Workspace modify column FORGID int default null  comment '组织编码';

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

alter table T_CDP_Workspace modify column FType nvarchar(50) default null  comment '认证类型';

alter table T_CDP_Workspace modify column FWorkspace int default null  comment '工作桌面';

alter table T_CDP_Workspace modify column Fdescription nvarchar(50) default null  comment '描述';

alter table T_CDP_Workspace modify column FMethod nvarchar(50) default null  comment '方法';