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

栏目：云星空知识作者：金蝶来源：金蝶云社区发布：2024-09-16浏览：1

--建表脚本--

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 '认证类型';