PLM开发字段集合IV

--建表脚本--

create table T_PLM_CFG_FIELD(

FID bigint not null  comment '主键'

,FMasterID bigint not null  comment '组织id'

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

,FENTITYCODE nvarchar(50) default null  comment '实体属性'

,FFIELDTYPE nvarchar(50) default null  comment '字段类型'

,FKEY nvarchar(50) default null  comment '标识'

,FELEMENTTYPEID nvarchar(50) default null  comment '元素类型id'

,FOBJECTTYPE int not null  comment '对象类型'

,FDEFVALUE nvarchar(1000) default ''  comment '默认值'

,FMUSTINPUT char(1) default ''0''  comment '必填'

,FFUNCTIONDEFAULT nvarchar(200) default null  comment '默认方法'

,FBASETYPE nvarchar(50) default null  comment '基础资料'

,FENUMNAME nvarchar(50) default null  comment '枚举类型'

,FISREADONLY char(1) default ''0''  comment '是否只读'

,FISSHOWLIST char(1) default ''0''  comment '列表显示'

,FISSHOW char(1) default ''0''  comment '显示'

,FISCLIENTDEFAULT char(1) default ''0''  comment 'FISCLIENTDEFAULT'

,FISCLIENTSEARCHDEFAULT char(1) default ''0''  comment '客户端搜索默认'

,FISCLIENTGRIDDEFAULT char(1) default ''0''  comment '客户端grid默认'

,FISTREEEDITORDEFAULT char(1) default ''0''  comment '客户端bom编辑默认'

,FISTREEVIEWDEFAULT char(1) default ''0''  comment '客户端bom查看默认'

,FELEMENTTYPE nvarchar(50) default null  comment '元素类型'

,FCREATEDATE datetime default null  comment '创建时间'

,FMODIFYDATE datetime default null  comment '修改时间'

,FEXTENDKEY nvarchar(100) not null  comment '扩展标识'

,primary key (FID)

) comment = '字段对象'

--查询--

select FID as "fid",FMasterID as "fmasterid",FCODE as "fcode",FENTITYCODE as "fentitycode",FFIELDTYPE as "ffieldtype",FKEY as "fkey",FELEMENTTYPEID as "felementtypeid",FOBJECTTYPE as "fobjecttype",FDEFVALUE as "fdefvalue",FMUSTINPUT as "fmustinput",FFUNCTIONDEFAULT as "ffunctiondefault",FBASETYPE as "fbasetype",FENUMNAME as "fenumname",FISREADONLY as "fisreadonly",FISSHOWLIST as "fisshowlist",FISSHOW as "fisshow",FISCLIENTDEFAULT as "fisclientdefault",FISCLIENTSEARCHDEFAULT as "fisclientsearchdefault",FISCLIENTGRIDDEFAULT as "fisclientgriddefault",FISTREEEDITORDEFAULT as "fistreeeditordefault",FISTREEVIEWDEFAULT as "fistreeviewdefault",FELEMENTTYPE as "felementtype",FCREATEDATE as "fcreatedate",FMODIFYDATE as "fmodifydate",FEXTENDKEY as "fextendkey" from T_PLM_CFG_FIELD

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

select FID as "主键",FMasterID as "组织id",FCODE as "编码",FENTITYCODE as "实体属性",FFIELDTYPE as "字段类型",FKEY as "标识",FELEMENTTYPEID as "元素类型id",FOBJECTTYPE as "对象类型",FDEFVALUE as "默认值",FMUSTINPUT as "必填",FFUNCTIONDEFAULT as "默认方法",FBASETYPE as "基础资料",FENUMNAME as "枚举类型",FISREADONLY as "是否只读",FISSHOWLIST as "列表显示",FISSHOW as "显示",FISCLIENTDEFAULT as "FISCLIENTDEFAULT",FISCLIENTSEARCHDEFAULT as "客户端搜索默认",FISCLIENTGRIDDEFAULT as "客户端grid默认",FISTREEEDITORDEFAULT as "客户端bom编辑默认",FISTREEVIEWDEFAULT as "客户端bom查看默认",FELEMENTTYPE as "元素类型",FCREATEDATE as "创建时间",FMODIFYDATE as "修改时间",FEXTENDKEY as "扩展标识" from T_PLM_CFG_FIELD

--INSERT脚本--

insert into T_PLM_CFG_FIELD(FID,FMasterID,FCODE,FENTITYCODE,FFIELDTYPE,FKEY,FELEMENTTYPEID,FOBJECTTYPE,FDEFVALUE,FMUSTINPUT,FFUNCTIONDEFAULT,FBASETYPE,FENUMNAME,FISREADONLY,FISSHOWLIST,FISSHOW,FISCLIENTDEFAULT,FISCLIENTSEARCHDEFAULT,FISCLIENTGRIDDEFAULT,FISTREEEDITORDEFAULT,FISTREEVIEWDEFAULT,FELEMENTTYPE,FCREATEDATE,FMODIFYDATE,FEXTENDKEY) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_FIELD set FID=?,FMasterID=?,FCODE=?,FENTITYCODE=?,FFIELDTYPE=?,FKEY=?,FELEMENTTYPEID=?,FOBJECTTYPE=?,FDEFVALUE=?,FMUSTINPUT=?,FFUNCTIONDEFAULT=?,FBASETYPE=?,FENUMNAME=?,FISREADONLY=?,FISSHOWLIST=?,FISSHOW=?,FISCLIENTDEFAULT=?,FISCLIENTSEARCHDEFAULT=?,FISCLIENTGRIDDEFAULT=?,FISTREEEDITORDEFAULT=?,FISTREEVIEWDEFAULT=?,FELEMENTTYPE=?,FCREATEDATE=?,FMODIFYDATE=?,FEXTENDKEY=? where FID=?

--delete脚本--

delete from T_PLM_CFG_FIELD where FID=?

--给字段加备注--

alter table T_PLM_CFG_FIELD comment '字段对象';

alter table T_PLM_CFG_FIELD modify column FID bigint not null  comment '主键';

alter table T_PLM_CFG_FIELD modify column FMasterID bigint not null  comment '组织id';

alter table T_PLM_CFG_FIELD modify column FCODE nvarchar(50) default null  comment '编码';

alter table T_PLM_CFG_FIELD modify column FENTITYCODE nvarchar(50) default null  comment '实体属性';

alter table T_PLM_CFG_FIELD modify column FFIELDTYPE nvarchar(50) default null  comment '字段类型';

alter table T_PLM_CFG_FIELD modify column FKEY nvarchar(50) default null  comment '标识';

alter table T_PLM_CFG_FIELD modify column FELEMENTTYPEID nvarchar(50) default null  comment '元素类型id';

alter table T_PLM_CFG_FIELD modify column FOBJECTTYPE int not null  comment '对象类型';

alter table T_PLM_CFG_FIELD modify column FDEFVALUE nvarchar(1000) default ''  comment '默认值';

alter table T_PLM_CFG_FIELD modify column FMUSTINPUT char(1) default ''0''  comment '必填';

alter table T_PLM_CFG_FIELD modify column FFUNCTIONDEFAULT nvarchar(200) default null  comment '默认方法';

alter table T_PLM_CFG_FIELD modify column FBASETYPE nvarchar(50) default null  comment '基础资料';

alter table T_PLM_CFG_FIELD modify column FENUMNAME nvarchar(50) default null  comment '枚举类型';

alter table T_PLM_CFG_FIELD modify column FISREADONLY char(1) default ''0''  comment '是否只读';

alter table T_PLM_CFG_FIELD modify column FISSHOWLIST char(1) default ''0''  comment '列表显示';

alter table T_PLM_CFG_FIELD modify column FISSHOW char(1) default ''0''  comment '显示';

alter table T_PLM_CFG_FIELD modify column FISCLIENTDEFAULT char(1) default ''0''  comment 'FISCLIENTDEFAULT';

alter table T_PLM_CFG_FIELD modify column FISCLIENTSEARCHDEFAULT char(1) default ''0''  comment '客户端搜索默认';

alter table T_PLM_CFG_FIELD modify column FISCLIENTGRIDDEFAULT char(1) default ''0''  comment '客户端grid默认';

alter table T_PLM_CFG_FIELD modify column FISTREEEDITORDEFAULT char(1) default ''0''  comment '客户端bom编辑默认';

alter table T_PLM_CFG_FIELD modify column FISTREEVIEWDEFAULT char(1) default ''0''  comment '客户端bom查看默认';

alter table T_PLM_CFG_FIELD modify column FELEMENTTYPE nvarchar(50) default null  comment '元素类型';

alter table T_PLM_CFG_FIELD modify column FCREATEDATE datetime default null  comment '创建时间';

alter table T_PLM_CFG_FIELD modify column FMODIFYDATE datetime default null  comment '修改时间';

alter table T_PLM_CFG_FIELD modify column FEXTENDKEY nvarchar(100) not null  comment '扩展标识';

--建表脚本--

create table T_PLM_CFG_FIELDENTRY(

FEntryID int not null  comment '从表id'

,FID int not null  comment '主键'

,FFIELDCODE bigint not null  comment '字段编码'

,primary key (FEntryID)

) comment = '字段对象从表'

--查询--

select FEntryID as "fentryid",FID as "fid",FFIELDCODE as "ffieldcode" from T_PLM_CFG_FIELDENTRY

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

select FEntryID as "从表id",FID as "主键",FFIELDCODE as "字段编码" from T_PLM_CFG_FIELDENTRY

--INSERT脚本--

insert into T_PLM_CFG_FIELDENTRY(FEntryID,FID,FFIELDCODE) values (?,?,?)

--UPDATE脚本--

update T_PLM_CFG_FIELDENTRY set FEntryID=?,FID=?,FFIELDCODE=? where FEntryID=?

--delete脚本--

delete from T_PLM_CFG_FIELDENTRY where FEntryID=?

--给字段加备注--

alter table T_PLM_CFG_FIELDENTRY comment '字段对象从表';

alter table T_PLM_CFG_FIELDENTRY modify column FEntryID int not null  comment '从表id';

alter table T_PLM_CFG_FIELDENTRY modify column FID int not null  comment '主键';

alter table T_PLM_CFG_FIELDENTRY modify column FFIELDCODE bigint not null  comment '字段编码';

--建表脚本--

create table T_PLM_CFG_FOLDER(

FID bigint not null  comment '主键'

,FMasterID bigint not null  comment '组织id'

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

,FCREATORID int not null  comment '创建人'

,FCREATEDATE datetime default null  comment '创建日期'

,FMODIFIERID int not null  comment '修改人'

,FMODIFYDATE datetime default null  comment '修改日期'

,FPARENTID bigint not null  comment '父文件夹'

,FTYPE varchar(20) default null  comment 'FTYPE'

,FPATHID int not null  comment 'FPATHID'

,FISPRODUCTFOLDER char(1) not null  comment 'FISPRODUCTFOLDER'

,FOWNERID int default null  comment '拥有者用户id'

,FPERMISSIONOBJECTID varchar(36) not null  comment 'FPERMISSIONOBJECTID'

,FKEYID decimal(38,1) not null  comment '文件夹线索id'

,FLEVEL int not null  comment '文件夹层级'

,FISJOINTHINKTANK char(1) not null  comment '是否纳入研发智库'

,FPROJECTRESOURCE char(1) not null  comment '项目资源目录'

,FCREATEORGID int not null  comment '创建组织'

,FSN int not null  comment '序号'

,primary key (FID)

) comment = 'pdm文件夹'

--查询--

select FID as "fid",FMasterID as "fmasterid",FCODE as "fcode",FCREATORID as "fcreatorid",FCREATEDATE as "fcreatedate",FMODIFIERID as "fmodifierid",FMODIFYDATE as "fmodifydate",FPARENTID as "fparentid",FTYPE as "ftype",FPATHID as "fpathid",FISPRODUCTFOLDER as "fisproductfolder",FOWNERID as "fownerid",FPERMISSIONOBJECTID as "fpermissionobjectid",FKEYID as "fkeyid",FLEVEL as "flevel",FISJOINTHINKTANK as "fisjointhinktank",FPROJECTRESOURCE as "fprojectresource",FCREATEORGID as "fcreateorgid",FSN as "fsn" from T_PLM_CFG_FOLDER

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

select FID as "主键",FMasterID as "组织id",FCODE as "编码",FCREATORID as "创建人",FCREATEDATE as "创建日期",FMODIFIERID as "修改人",FMODIFYDATE as "修改日期",FPARENTID as "父文件夹",FTYPE as "FTYPE",FPATHID as "FPATHID",FISPRODUCTFOLDER as "FISPRODUCTFOLDER",FOWNERID as "拥有者用户id",FPERMISSIONOBJECTID as "FPERMISSIONOBJECTID",FKEYID as "文件夹线索id",FLEVEL as "文件夹层级",FISJOINTHINKTANK as "是否纳入研发智库",FPROJECTRESOURCE as "项目资源目录",FCREATEORGID as "创建组织",FSN as "序号" from T_PLM_CFG_FOLDER

--INSERT脚本--

insert into T_PLM_CFG_FOLDER(FID,FMasterID,FCODE,FCREATORID,FCREATEDATE,FMODIFIERID,FMODIFYDATE,FPARENTID,FTYPE,FPATHID,FISPRODUCTFOLDER,FOWNERID,FPERMISSIONOBJECTID,FKEYID,FLEVEL,FISJOINTHINKTANK,FPROJECTRESOURCE,FCREATEORGID,FSN) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_FOLDER set FID=?,FMasterID=?,FCODE=?,FCREATORID=?,FCREATEDATE=?,FMODIFIERID=?,FMODIFYDATE=?,FPARENTID=?,FTYPE=?,FPATHID=?,FISPRODUCTFOLDER=?,FOWNERID=?,FPERMISSIONOBJECTID=?,FKEYID=?,FLEVEL=?,FISJOINTHINKTANK=?,FPROJECTRESOURCE=?,FCREATEORGID=?,FSN=? where FID=?

--delete脚本--

delete from T_PLM_CFG_FOLDER where FID=?

--给字段加备注--

alter table T_PLM_CFG_FOLDER comment 'pdm文件夹';

alter table T_PLM_CFG_FOLDER modify column FID bigint not null  comment '主键';

alter table T_PLM_CFG_FOLDER modify column FMasterID bigint not null  comment '组织id';

alter table T_PLM_CFG_FOLDER modify column FCODE nvarchar(50) default null  comment '编码';

alter table T_PLM_CFG_FOLDER modify column FCREATORID int not null  comment '创建人';

alter table T_PLM_CFG_FOLDER modify column FCREATEDATE datetime default null  comment '创建日期';

alter table T_PLM_CFG_FOLDER modify column FMODIFIERID int not null  comment '修改人';

alter table T_PLM_CFG_FOLDER modify column FMODIFYDATE datetime default null  comment '修改日期';

alter table T_PLM_CFG_FOLDER modify column FPARENTID bigint not null  comment '父文件夹';

alter table T_PLM_CFG_FOLDER modify column FTYPE varchar(20) default null  comment 'FTYPE';

alter table T_PLM_CFG_FOLDER modify column FPATHID int not null  comment 'FPATHID';

alter table T_PLM_CFG_FOLDER modify column FISPRODUCTFOLDER char(1) not null  comment 'FISPRODUCTFOLDER';

alter table T_PLM_CFG_FOLDER modify column FOWNERID int default null  comment '拥有者用户id';

alter table T_PLM_CFG_FOLDER modify column FPERMISSIONOBJECTID varchar(36) not null  comment 'FPERMISSIONOBJECTID';

alter table T_PLM_CFG_FOLDER