BOS / 基础服务与基础框架 / 弹性域(3)原创
金蝶云社区-枯藤老树昏鸦
枯藤老树昏鸦
28人赞赏了该文章 325次浏览 未经作者许可,禁止转载编辑于2024年01月19日 14:48:56

image.png


--建表脚本--

create table T_BD_FLEXITEMDETAILV(

FID int not null  comment '主键'

,FOPCODE nvarchar(10) default ''  comment '快速输入码'

,FFLEX4 int not null  comment '预设维度数据供应商'

,FFLEX5 int not null  comment '预设维度数据部门'

,FFLEX6 int not null  comment '预设维度数据客户'

,FFLEX7 int not null  comment '预设维度数据员工'

,FFLEX8 int not null  comment '预设维度数据物料'

,FFLEX9 int default 0  comment '预置维度数据费用项目'

,FFLEX10 int default 0  comment '预置维度数据资产类别'

,primary key (FID)

) comment = '核算维度数据表'


--查询--

select FID as "fid",FOPCODE as "fopcode",FFLEX4 as "fflex4",FFLEX5 as "fflex5",FFLEX6 as "fflex6",FFLEX7 as "fflex7",FFLEX8 as "fflex8",FFLEX9 as "fflex9",FFLEX10 as "fflex10" from T_BD_FLEXITEMDETAILV


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

select FID as "主键",FOPCODE as "快速输入码",FFLEX4 as "预设维度数据供应商",FFLEX5 as "预设维度数据部门",FFLEX6 as "预设维度数据客户",FFLEX7 as "预设维度数据员工",FFLEX8 as "预设维度数据物料",FFLEX9 as "预置维度数据费用项目",FFLEX10 as "预置维度数据资产类别" from T_BD_FLEXITEMDETAILV


--INSERT脚本--

insert into T_BD_FLEXITEMDETAILV(FID,FOPCODE,FFLEX4,FFLEX5,FFLEX6,FFLEX7,FFLEX8,FFLEX9,FFLEX10) values (?,?,?,?,?,?,?,?,?)


--UPDATE脚本--

update T_BD_FLEXITEMDETAILV set FID=?,FOPCODE=?,FFLEX4=?,FFLEX5=?,FFLEX6=?,FFLEX7=?,FFLEX8=?,FFLEX9=?,FFLEX10=? where FID=?


--delete脚本--

delete from T_BD_FLEXITEMDETAILV where FID=?


--给字段加备注--

alter table T_BD_FLEXITEMDETAILV comment '核算维度数据表';

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

alter table T_BD_FLEXITEMDETAILV modify column FOPCODE nvarchar(10) default ''  comment '快速输入码';

alter table T_BD_FLEXITEMDETAILV modify column FFLEX4 int not null  comment '预设维度数据供应商';

alter table T_BD_FLEXITEMDETAILV modify column FFLEX5 int not null  comment '预设维度数据部门';

alter table T_BD_FLEXITEMDETAILV modify column FFLEX6 int not null  comment '预设维度数据客户';

alter table T_BD_FLEXITEMDETAILV modify column FFLEX7 int not null  comment '预设维度数据员工';

alter table T_BD_FLEXITEMDETAILV modify column FFLEX8 int not null  comment '预设维度数据物料';

alter table T_BD_FLEXITEMDETAILV modify column FFLEX9 int default 0  comment '预置维度数据费用项目';

alter table T_BD_FLEXITEMDETAILV modify column FFLEX10 int default 0  comment '预置维度数据资产类别';


--建表脚本--

create table T_BD_FLEXITEMGROUP(

FID int not null  comment '内码'

,FNUMBER nvarchar(1000) not null  comment '编码'

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

,FCREATORID int not null  comment '创建人'

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

,FUSEORGID int not null  comment '使用组织'

,FMODIFIERID int not null  comment '修改人'

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

,FDOCUMENTSTATUS char(1) not null  comment '数据状态'

,FAUDITORID int not null  comment '审核人'

,FAUDITDATE datetime default null  comment '审核日期'

,FFORBIDSTATUS char(1) not null  comment '禁用状态'

,FFORBIDDERID int not null  comment '禁用人'

,FFORBIDDATE datetime default null  comment '禁用日期'

,FISSYSPRESET char(1) not null  comment '是否系统预设'

,FMASTERID int not null  comment '主id'

,primary key (FID)

) comment = '维度组主表'


--查询--

select FID as "fid",FNUMBER as "fnumber",FCREATEORGID as "fcreateorgid",FCREATORID as "fcreatorid",FCREATEDATE as "fcreatedate",FUSEORGID as "fuseorgid",FMODIFIERID as "fmodifierid",FMODIFYDATE as "fmodifydate",FDOCUMENTSTATUS as "fdocumentstatus",FAUDITORID as "fauditorid",FAUDITDATE as "fauditdate",FFORBIDSTATUS as "fforbidstatus",FFORBIDDERID as "fforbidderid",FFORBIDDATE as "fforbiddate",FISSYSPRESET as "fissyspreset",FMASTERID as "fmasterid" from T_BD_FLEXITEMGROUP


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

select FID as "内码",FNUMBER as "编码",FCREATEORGID as "创建组织",FCREATORID as "创建人",FCREATEDATE as "创建日期",FUSEORGID as "使用组织",FMODIFIERID as "修改人",FMODIFYDATE as "修改日期",FDOCUMENTSTATUS as "数据状态",FAUDITORID as "审核人",FAUDITDATE as "审核日期",FFORBIDSTATUS as "禁用状态",FFORBIDDERID as "禁用人",FFORBIDDATE as "禁用日期",FISSYSPRESET as "是否系统预设",FMASTERID as "主id" from T_BD_FLEXITEMGROUP


--INSERT脚本--

insert into T_BD_FLEXITEMGROUP(FID,FNUMBER,FCREATEORGID,FCREATORID,FCREATEDATE,FUSEORGID,FMODIFIERID,FMODIFYDATE,FDOCUMENTSTATUS,FAUDITORID,FAUDITDATE,FFORBIDSTATUS,FFORBIDDERID,FFORBIDDATE,FISSYSPRESET,FMASTERID) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)


--UPDATE脚本--

update T_BD_FLEXITEMGROUP set FID=?,FNUMBER=?,FCREATEORGID=?,FCREATORID=?,FCREATEDATE=?,FUSEORGID=?,FMODIFIERID=?,FMODIFYDATE=?,FDOCUMENTSTATUS=?,FAUDITORID=?,FAUDITDATE=?,FFORBIDSTATUS=?,FFORBIDDERID=?,FFORBIDDATE=?,FISSYSPRESET=?,FMASTERID=? where FID=?


--delete脚本--

delete from T_BD_FLEXITEMGROUP where FID=?


--给字段加备注--

alter table T_BD_FLEXITEMGROUP comment '维度组主表';

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

alter table T_BD_FLEXITEMGROUP modify column FNUMBER nvarchar(1000) not null  comment '编码';

alter table T_BD_FLEXITEMGROUP modify column FCREATEORGID int not null  comment '创建组织';

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

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

alter table T_BD_FLEXITEMGROUP modify column FUSEORGID int not null  comment '使用组织';

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

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

alter table T_BD_FLEXITEMGROUP modify column FDOCUMENTSTATUS char(1) not null  comment '数据状态';

alter table T_BD_FLEXITEMGROUP modify column FAUDITORID int not null  comment '审核人';

alter table T_BD_FLEXITEMGROUP modify column FAUDITDATE datetime default null  comment '审核日期';

alter table T_BD_FLEXITEMGROUP modify column FFORBIDSTATUS char(1) not null  comment '禁用状态';

alter table T_BD_FLEXITEMGROUP modify column FFORBIDDERID int not null  comment '禁用人';

alter table T_BD_FLEXITEMGROUP modify column FFORBIDDATE datetime default null  comment '禁用日期';

alter table T_BD_FLEXITEMGROUP modify column FISSYSPRESET char(1) not null  comment '是否系统预设';

alter table T_BD_FLEXITEMGROUP modify column FMASTERID int not null  comment '主id';


--建表脚本--

create table T_BD_FLEXITEMGROUP_L(

FPKID int not null  comment '多语言表内码'

,FID int not null  comment '主表内码'

,FNAME nvarchar(2000) not null  comment '名称'

,FDESCRIPTION nvarchar(500) not null  comment '描述'

,FLOCALEID int not null  comment '语言内码'

,primary key (FPKID)

) comment = '维度组多语言表'


--查询--

select FPKID as "fpkid",FID as "fid",FNAME as "fname",FDESCRIPTION as "fdescription",FLOCALEID as "flocaleid" from T_BD_FLEXITEMGROUP_L


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

select FPKID as "多语言表内码",FID as "主表内码",FNAME as "名称",FDESCRIPTION as "描述",FLOCALEID as "语言内码" from T_BD_FLEXITEMGROUP_L


--INSERT脚本--

insert into T_BD_FLEXITEMGROUP_L(FPKID,FID,FNAME,FDESCRIPTION,FLOCALEID) values (?,?,?,?,?)


--UPDATE脚本--

update T_BD_FLEXITEMGROUP_L set FPKID=?,FID=?,FNAME=?,FDESCRIPTION=?,FLOCALEID=? where FPKID=?


--delete脚本--

delete from T_BD_FLEXITEMGROUP_L where FPKID=?


--给字段加备注--

alter table T_BD_FLEXITEMGROUP_L comment '维度组多语言表';

alter table T_BD_FLEXITEMGROUP_L modify column FPKID int not null  comment '多语言表内码';

alter table T_BD_FLEXITEMGROUP_L modify column FID int not null  comment '主表内码';

alter table T_BD_FLEXITEMGROUP_L modify column FNAME nvarchar(2000) not null  comment '名称';

alter table T_BD_FLEXITEMGROUP_L modify column FDESCRIPTION nvarchar(500) not null  comment '描述';

alter table T_BD_FLEXITEMGROUP_L modify column FLOCALEID int not null  comment '语言内码';


--建表脚本--

create table T_BD_FLEXITEMGRPENTRY(

FENTRYID int not null  comment '分录内码'

,FID int not null  comment '主表内码'

,FFLEXITEMPROPERTYID int not null  comment '维度id'

,FACCTITEMISVALID char(1) not null  comment '是否启用'

,FINPUTTYPE varchar(50) default null  comment '必录类型'

,FFILTER nvarchar(255) not null  comment '条件定义'

,FDATAFIELDNAME nvarchar(50) not null  comment '数据字段'

,FSEQ int not null  comment '显示顺序'

,FMASTERID int not null  comment '主id'

,primary key (FENTRYID)

) comment = '维度组从表'


--查询--

select FENTRYID as "fentryid",FID as "fid",FFLEXITEMPROPERTYID as "fflexitempropertyid",FACCTITEMISVALID as "facctitemisvalid",FINPUTTYPE as "finputtype",FFILTER as "ffilter",FDATAFIELDNAME as "fdatafieldname",FSEQ as "fseq",FMASTERID as "fmasterid" from T_BD_FLEXITEMGRPENTRY


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

select FENTRYID as "分录内码",FID as "主表内码",FFLEXITEMPROPERTYID as "维度id",FACCTITEMISVALID as "是否启用",FINPUTTYPE as "必录类型",FFILTER as "条件定义",FDATAFIELDNAME as "数据字段",FSEQ as "显示顺序",FMASTERID as "主id" from T_BD_FLEXITEMGRPENTRY


--INSERT脚本--

insert into T_BD_FLEXITEMGRPENTRY(FENTRYID,FID,FFLEXITEMPROPERTYID,FACCTITEMISVALID,FINPUTTYPE,FFILTER,FDATAFIELDNAME,FSEQ,FMASTERID) values (?,?,?,?,?,?,?,?,?)


--UPDATE脚本--

update T_BD_FLEXITEMGRPENTRY set FENTRYID=?,FID=?,FFLEXITEMPROPERTYID=?,FACCTITEMISVALID=?,FINPUTTYPE=?,FFILTER=?,FDATAFIELDNAME=?,FSEQ=?,FMASTERID=? where FENTRYID=?


--delete脚本--

delete from T_BD_FLEXITEMGRPENTRY where FENTRYID=?


--给字段加备注--

alter table T_BD_FLEXITEMGRPENTRY comment '维度组从表';

alter table T_BD_FLEXITEMGRPENTRY modify column FENTRYID int not null  comment '分录内码';

alter table T_BD_FLEXITEMGRPENTRY modify column FID int not null  comment '主表内码';

alter table T_BD_FLEXITEMGRPENTRY modify column FFLEXITEMPROPERTYID int not null  comment '维度id';

alter table T_BD_FLEXITEMGRPENTRY modify column FACCTITEMISVALID char(1) not null  comment '是否启用';

alter table T_BD_FLEXITEMGRPENTRY modify column FINPUTTYPE varchar(50) default null  comment '必录类型';

alter table T_BD_FLEXITEMGRPENTRY modify column FFILTER nvarchar(255) not null  comment '条件定义';

alter table T_BD_FLEXITEMGRPENTRY modify column FDATAFIELDNAME nvarchar(50) not null  comment '数据字段';

alter table T_BD_FLEXITEMGRPENTRY modify column FSEQ int not null  comment '显示顺序';

alter table T_BD_FLEXITEMGRPENTRY modify column FMASTERID int not null  comment '主id';


--建表脚本--

create table T_BD_FLEXITEMPROPERTY(

FID int not null  comment '内码'

,FMASTERID int not null  comment '分配后内码'

,FFORMID varchar(36) not null  comment '单据类型'

,FNUMBER nvarchar(30) not null  comment '编码'

,FVALUETYPE varchar(50) not null  comment '值类型'

,FVALUESOURCE varchar(36) not null  comment '值来源'

,FVALUELIMIT int not null  comment '值约束'

,FFLEXNUMBER nvarchar(30) not null  comment '自定义维度数据对应数据字段名称'

,FISSYSPRESET char(1) not null  comment '系统预设'

,FCREATORID int not null  comment '创建人'

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

,FMODIFIERID int not null  comment '修改人'

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

,FAUDITORID int not null  comment '审核人'

,FAUDITDATE datetime default null  comment '审核日期'

,FFORBIDDERID int not null  comment '禁用人'

,FFORBIDDATE datetime default null  comment '禁用日期'

,FDOCUMENTSTATUS char(1) not null  comment '数据状态'

,FFORBIDSTATUS char(1) not null  comment '禁用状态'

,FCUSTOMDATATYPE varchar(50) default ''''  comment '自定义数据类型'

,FCUSTOMDATAPRECISION int default 0  comment '自定义维度整数精度'

,FCUSTOMDATAACCURACY int default 0  comment '自定义维度小数精度'

,FCUSTOMDATAMIN varchar(50) default ''''  comment '自定义维度最小值'

,FCUSTOMDATAMAX varchar(50) default ''''  comment '自定义维度最大值'

,FCUSTOMDATASTRMAXLEN int default 0  comment '自定义维度字符长度'

,primary key (FID)

) comment = '自定义维度'


--查询--

select FID as "fid",FMASTERID as "fmasterid",FFORMID as "fformid",FNUMBER as "fnumber",FVALUETYPE as "fvaluetype",FVALUESOURCE as "fvaluesource",FVALUELIMIT as "fvaluelimit",FFLEXNUMBER as "fflexnumber",FISSYSPRESET as "fissyspreset",FCREATORID as "fcreatorid",FCREATEDATE as "fcreatedate",FMODIFIERID as "fmodifierid",FMODIFYDATE as "fmodifydate",FAUDITORID as "fauditorid",FAUDITDATE as "fauditdate",FFORBIDDERID as "fforbidderid",FFORBIDDATE as "fforbiddate",FDOCUMENTSTATUS as "fdocumentstatus",FFORBIDSTATUS as "fforbidstatus",FCUSTOMDATATYPE as "fcustomdatatype",FCUSTOMDATAPRECISION as "fcustomdataprecision",FCUSTOMDATAACCURACY as "fcustomdataaccuracy",FCUSTOMDATAMIN as "fcustomdatamin",FCUSTOMDATAMAX as "fcustomdatamax",FCUSTOMDATASTRMAXLEN as "fcustomdatastrmaxlen" from T_BD_FLEXITEMPROPERTY


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

select FID as "内码",FMASTERID as "分配后内码",FFORMID as "单据类型",FNUMBER as "编码",FVALUETYPE as "值类型",FVALUESOURCE as "值来源",FVALUELIMIT as "值约束",FFLEXNUMBER as "自定义维度数据对应数据字段名称",FISSYSPRESET as "系统预设",FCREATORID as "创建人",FCREATEDATE as "创建日期",FMODIFIERID as "修改人",FMODIFYDATE as "修改日期",FAUDITORID as "审核人",FAUDITDATE as "审核日期",FFORBIDDERID as "禁用人",FFORBIDDATE as "禁用日期",FDOCUMENTSTATUS as "数据状态",FFORBIDSTATUS as "禁用状态",FCUSTOMDATATYPE as "自定义数据类型",FCUSTOMDATAPRECISION as "自定义维度整数精度",FCUSTOMDATAACCURACY as "自定义维度小数精度",FCUSTOMDATAMIN as "自定义维度最小值",FCUSTOMDATAMAX as "自定义维度最大值",FCUSTOMDATASTRMAXLEN as "自定义维度字符长度" from T_BD_FLEXITEMPROPERTY


--INSERT脚本--

insert into T_BD_FLEXITEMPROPERTY(FID,FMASTERID,FFORMID,FNUMBER,FVALUETYPE,FVALUESOURCE,FVALUELIMIT,FFLEXNUMBER,FISSYSPRESET,FCREATORID,FCREATEDATE,FMODIFIERID,FMODIFYDATE,FAUDITORID,FAUDITDATE,FFORBIDDERID,FFORBIDDATE,FDOCUMENTSTATUS,FFORBIDSTATUS,FCUSTOMDATATYPE,FCUSTOMDATAPRECISION,FCUSTOMDATAACCURACY,FCUSTOMDATAMIN,FCUSTOMDATAMAX,FCUSTOMDATASTRMAXLEN) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)


--UPDATE脚本--

update T_BD_FLEXITEMPROPERTY set FID=?,FMASTERID=?,FFORMID=?,FNUMBER=?,FVALUETYPE=?,FVALUESOURCE=?,FVALUELIMIT=?,FFLEXNUMBER=?,FISSYSPRESET=?,FCREATORID=?,FCREATEDATE=?,FMODIFIERID=?,FMODIFYDATE=?,FAUDITORID=?,FAUDITDATE=?,FFORBIDDERID=?,FFORBIDDATE=?,FDOCUMENTSTATUS=?,FFORBIDSTATUS=?,FCUSTOMDATATYPE=?,FCUSTOMDATAPRECISION=?,FCUSTOMDATAACCURACY=?,FCUSTOMDATAMIN=?,FCUSTOMDATAMAX=?,FCUSTOMDATASTRMAXLEN=? where FID=?


--delete脚本--

delete from T_BD_FLEXITEMPROPERTY where FID=?


--给字段加备注--

alter table T_BD_FLEXITEMPROPERTY comment '自定义维度';

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

alter table T_BD_FLEXITEMPROPERTY modify column FMASTERID int not null  comment '分配后内码';

alter table T_BD_FLEXITEMPROPERTY modify column FFORMID varchar(36) not null  comment '单据类型';

alter table T_BD_FLEXITEMPROPERTY modify column FNUMBER nvarchar(30) not null  comment '编码';

alter table T_BD_FLEXITEMPROPERTY modify column FVALUETYPE varchar(50) not null  comment '值类型';

alter table T_BD_FLEXITEMPROPERTY modify column FVALUESOURCE varchar(36) not null  comment '值来源';

alter table T_BD_FLEXITEMPROPERTY modify column FVALUELIMIT int not null  comment '值约束';

alter table T_BD_FLEXITEMPROPERTY modify column FFLEXNUMBER nvarchar(30) not null  comment '自定义维度数据对应数据字段名称';

alter table T_BD_FLEXITEMPROPERTY modify column FISSYSPRESET char(1) not null  comment '系统预设';

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

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

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

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

alter table T_BD_FLEXITEMPROPERTY modify column FAUDITORID int not null  comment '审核人';

alter table T_BD_FLEXITEMPROPERTY modify column FAUDITDATE datetime default null  comment '审核日期';

alter table T_BD_FLEXITEMPROPERTY modify column FFORBIDDERID int not null  comment '禁用人';

alter table T_BD_FLEXITEMPROPERTY modify column FFORBIDDATE datetime default null  comment '禁用日期';

alter table T_BD_FLEXITEMPROPERTY modify column FDOCUMENTSTATUS char(1) not null  comment '数据状态';

alter table T_BD_FLEXITEMPROPERTY modify column FFORBIDSTATUS char(1) not null  comment '禁用状态';

alter table T_BD_FLEXITEMPROPERTY modify column FCUSTOMDATATYPE varchar(50) default ''''  comment '自定义数据类型';

alter table T_BD_FLEXITEMPROPERTY modify column FCUSTOMDATAPRECISION int default 0  comment '自定义维度整数精度';

alter table T_BD_FLEXITEMPROPERTY modify column FCUSTOMDATAACCURACY int default 0  comment '自定义维度小数精度';

alter table T_BD_FLEXITEMPROPERTY modify column FCUSTOMDATAMIN varchar(50) default ''''  comment '自定义维度最小值';

alter table T_BD_FLEXITEMPROPERTY modify column FCUSTOMDATAMAX varchar(50) default ''''  comment '自定义维度最大值';

alter table T_BD_FLEXITEMPROPERTY modify column FCUSTOMDATASTRMAXLEN int default 0  comment '自定义维度字符长度';


--建表脚本--

create table T_BD_FLEXITEMPROPERTY_L(

FPKID int not null  comment '主键'

,FID int not null  comment '辅助属性内码'

,FLOCALEID int not null  comment '语言标识'

,FNAME nvarchar(80) not null  comment '名称'

,FDESCRIPTION nvarchar(255) not null  comment '描述'

,primary key (FPKID)

) comment = '自定义维度多语言'


--查询--

select FPKID as "fpkid",FID as "fid",FLOCALEID as "flocaleid",FNAME as "fname",FDESCRIPTION as "fdescription" from T_BD_FLEXITEMPROPERTY_L


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

select FPKID as "主键",FID as "辅助属性内码",FLOCALEID as "语言标识",FNAME as "名称",FDESCRIPTION as "描述" from T_BD_FLEXITEMPROPERTY_L


--INSERT脚本--

insert into T_BD_FLEXITEMPROPERTY_L(FPKID,FID,FLOCALEID,FNAME,FDESCRIPTION) values (?,?,?,?,?)


--UPDATE脚本--

update T_BD_FLEXITEMPROPERTY_L set FPKID=?,FID=?,FLOCALEID=?,FNAME=?,FDESCRIPTION=? where FPKID=?


--delete脚本--

delete from T_BD_FLEXITEMPROPERTY_L where FPKID=?


--给字段加备注--

alter table T_BD_FLEXITEMPROPERTY_L comment '自定义维度多语言';

alter table T_BD_FLEXITEMPROPERTY_L modify column FPKID int not null  comment '主键';

alter table T_BD_FLEXITEMPROPERTY_L modify column FID int not null  comment '辅助属性内码';

alter table T_BD_FLEXITEMPROPERTY_L modify column FLOCALEID int not null  comment '语言标识';

alter table T_BD_FLEXITEMPROPERTY_L modify column FNAME nvarchar(80) not null  comment '名称';

alter table T_BD_FLEXITEMPROPERTY_L modify column FDESCRIPTION nvarchar(255) not null  comment '描述';


--建表脚本--

create table T_BD_FLEXSITEMDETAILV(

FID int not null  comment '内码'

,FOPCODE nvarchar(10) default ''  comment '编码'

,primary key (FID)

) comment = '辅助属性数据表'


--查询--

select FID as "fid",FOPCODE as "fopcode" from T_BD_FLEXSITEMDETAILV


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

select FID as "内码",FOPCODE as "编码" from T_BD_FLEXSITEMDETAILV


--INSERT脚本--

insert into T_BD_FLEXSITEMDETAILV(FID,FOPCODE) values (?,?)


--UPDATE脚本--

update T_BD_FLEXSITEMDETAILV set FID=?,FOPCODE=? where FID=?


--delete脚本--

delete from T_BD_FLEXSITEMDETAILV where FID=?


--给字段加备注--

alter table T_BD_FLEXSITEMDETAILV comment '辅助属性数据表';

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

alter table T_BD_FLEXSITEMDETAILV modify column FOPCODE nvarchar(10) default ''  comment '编码';


上传图片


图标赞 28
28人点赞
还没有人点赞,快来当第一个点赞的人吧!
图标打赏
0人打赏
还没有人打赏,快来当第一个打赏的人吧!