--建表脚本--
create table T_META_FORMBILLLIST(
FID varchar(36) not null comment '内码'
,FLAYOUTID varchar(36) not null comment '布局'
,primary key (FID)
) comment = '单据列表描述'
--查询--
select FID as "fid",FLAYOUTID as "flayoutid" from T_META_FORMBILLLIST
--查询(中文字段)--
select FID as "内码",FLAYOUTID as "布局" from T_META_FORMBILLLIST
--INSERT脚本--
insert into T_META_FORMBILLLIST(FID,FLAYOUTID) values (?,?)
--UPDATE脚本--
update T_META_FORMBILLLIST set FID=?,FLAYOUTID=? where FID=?
--delete脚本--
delete from T_META_FORMBILLLIST where FID=?
--给字段加备注--
alter table T_META_FORMBILLLIST comment '单据列表描述';
alter table T_META_FORMBILLLIST modify column FID varchar(36) not null comment '内码';
alter table T_META_FORMBILLLIST modify column FLAYOUTID varchar(36) not null comment '布局';
--建表脚本--
create table T_META_FORMBILLLISTDETAIL(
FID varchar(36) not null comment '编号'
,FLISTID varchar(36) not null comment '列表id'
,FENTITYKEY varchar(30) not null comment '单据体'
,FTYPE int not null comment '类型'
,FVALUE nvarchar(2000) default null comment '值'
,primary key (FID)
) comment = '单据列表描述明细'
--查询--
select FID as "fid",FLISTID as "flistid",FENTITYKEY as "fentitykey",FTYPE as "ftype",FVALUE as "fvalue" from T_META_FORMBILLLISTDETAIL
--查询(中文字段)--
select FID as "编号",FLISTID as "列表id",FENTITYKEY as "单据体",FTYPE as "类型",FVALUE as "值" from T_META_FORMBILLLISTDETAIL
--INSERT脚本--
insert into T_META_FORMBILLLISTDETAIL(FID,FLISTID,FENTITYKEY,FTYPE,FVALUE) values (?,?,?,?,?)
--UPDATE脚本--
update T_META_FORMBILLLISTDETAIL set FID=?,FLISTID=?,FENTITYKEY=?,FTYPE=?,FVALUE=? where FID=?
--delete脚本--
delete from T_META_FORMBILLLISTDETAIL where FID=?
--给字段加备注--
alter table T_META_FORMBILLLISTDETAIL comment '单据列表描述明细';
alter table T_META_FORMBILLLISTDETAIL modify column FID varchar(36) not null comment '编号';
alter table T_META_FORMBILLLISTDETAIL modify column FLISTID varchar(36) not null comment '列表id';
alter table T_META_FORMBILLLISTDETAIL modify column FENTITYKEY varchar(30) not null comment '单据体';
alter table T_META_FORMBILLLISTDETAIL modify column FTYPE int not null comment '类型';
alter table T_META_FORMBILLLISTDETAIL modify column FVALUE nvarchar(2000) default null comment '值';