📄 7.特种设备.sql
字号:
CREATE TABLE "dba"."sbtzdlsb"
("id" char(22) NOT NULL ,
"sbbh" char(22) ,
"sbmc" varchar(40) ,
"ggxh" varchar(20) ,
"sybm" varchar(40) ,
"zzc" varchar(40) ,
"ccny" varchar(10) ,
"dllb" varchar(10) ,
"zfmc" varchar(20) ,
"nl" numeric(10,2) ) ;
CREATE UNIQUE INDEX "sbtzdlsb"
ON "dba"."sbtzdlsb"
("id" ) ;
insert into "dba".pbcattbl
(pbt_tnam,
pbt_ownr,
pbd_fhgt,
pbd_fwgt,
pbd_fitl,
pbd_funl,
pbd_fchr,
pbd_fptc,
pbd_ffce,
pbh_fhgt,
pbh_fwgt,
pbh_fitl,
pbh_funl,
pbh_fchr,
pbh_fptc,
pbh_ffce,
pbl_fhgt,
pbl_fwgt,
pbl_fitl,
pbl_funl,
pbl_fchr,
pbl_fptc,
pbl_ffce,
pbt_cmnt)
values
('sbtzdlsb',
'dba',
-9,
400,
'N',
'N',
0,
34,
'Arial',
-9,
400,
'N',
'N',
134,
2,
'宋体',
-9,
400 ,
'N',
'N',
134,
2,
'宋体',
'动力设备') ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbtzdlsb',
'dba',
'id',
'序列号',
0 ,
'序列号',
0,
23 ,
0 ,
77 ,
567 ,
'N',
'序列号' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbtzdlsb',
'dba',
'sbbh',
'设备编号',
0 ,
'设备编号',
0,
23 ,
0 ,
77 ,
567 ,
'N',
'设备编号' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbtzdlsb',
'dba',
'sbmc',
'设备名称',
0 ,
'设备名称',
0,
23 ,
0 ,
77 ,
983 ,
'N',
'设备名称' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbtzdlsb',
'dba',
'ggxh',
'规格型号',
0 ,
'规格型号',
0,
23 ,
0 ,
77 ,
526 ,
'N',
'规格型号' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbtzdlsb',
'dba',
'sybm',
'使用部门',
0 ,
'使用部门',
0,
23 ,
0 ,
77 ,
983 ,
'N',
'使用部门' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbtzdlsb',
'dba',
'zzc',
'制造厂',
0 ,
'制造厂',
0,
23 ,
0 ,
77 ,
983 ,
'N',
'制造厂' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbtzdlsb',
'dba',
'ccny',
'出厂年月',
0 ,
'出厂年月',
0,
23 ,
0 ,
77 ,
293 ,
'N',
'出厂年月' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbtzdlsb',
'dba',
'dllb',
'动力类别',
0 ,
'动力类别',
0,
23 ,
0 ,
77 ,
293 ,
'N',
'动力类别' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbtzdlsb',
'dba',
'zfmc',
'站房名称',
0 ,
'站房名称',
0,
23 ,
0 ,
77 ,
526 ,
'N',
'站房名称' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_mask,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbtzdlsb',
'dba',
'nl',
'能力',
0 ,
'能力',
0,
24 ,
'[General]',
0 ,
77 ,
343 ,
'N',
'能力' ) ;
CREATE TABLE "dba"."sbtzjlqj"
("id" char(22) NOT NULL ,
"bh" varchar(20) ,
"mc" varchar(40) ,
"ggxh" varchar(20) ,
"sybm" varchar(40) ,
"syr" varchar(10) ,
"lb" varchar(20) ,
"jddj" varchar(10) ,
"csbz" varchar(10) ,
"zt" varchar(4) ,
"jdsj" varchar(10) ,
"jddw" varchar(40) ,
"jdjg" varchar(20) ,
"yxrq" varchar(10) ,
"bz" varchar(200) ) ;
CREATE UNIQUE INDEX "sbtzjlqj"
ON "dba"."sbtzjlqj"
("id" ) ;
insert into "dba".pbcattbl
(pbt_tnam,
pbt_ownr,
pbd_fhgt,
pbd_fwgt,
pbd_fitl,
pbd_funl,
pbd_fchr,
pbd_fptc,
pbd_ffce,
pbh_fhgt,
pbh_fwgt,
pbh_fitl,
pbh_funl,
pbh_fchr,
pbh_fptc,
pbh_ffce,
pbl_fhgt,
pbl_fwgt,
pbl_fitl,
pbl_funl,
pbl_fchr,
pbl_fptc,
pbl_ffce,
pbt_cmnt)
values
('sbtzjlqj',
'dba',
-9,
400,
'N',
'N',
0,
34,
'Arial',
-9,
400,
'N',
'N',
134,
2,
'宋体',
-9,
400 ,
'N',
'N',
134,
2,
'宋体',
'计量器具') ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbtzjlqj',
'dba',
'id',
'序列号',
0 ,
'序列号',
0,
23 ,
0 ,
77 ,
567 ,
'N',
'序列号' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbtzjlqj',
'dba',
'bh',
'编号',
0 ,
'编号',
0,
23 ,
0 ,
77 ,
526 ,
'N',
'编号' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbtzjlqj',
'dba',
'mc',
'名称',
0 ,
'名称',
0,
23 ,
0 ,
77 ,
983 ,
'N',
'名称' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbtzjlqj',
'dba',
'ggxh',
'规格型号',
0 ,
'规格型号',
0,
23 ,
0 ,
77 ,
526 ,
'N',
'规格型号' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbtzjlqj',
'dba',
'sybm',
'使用部门',
0 ,
'使用部门',
0,
23 ,
0 ,
77 ,
983 ,
'N',
'使用部门' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbtzjlqj',
'dba',
'syr',
'使用人',
0 ,
'使用人',
0,
23 ,
0 ,
77 ,
293 ,
'N',
'使用人' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbtzjlqj',
'dba',
'lb',
'类别',
0 ,
'类别',
0,
23 ,
0 ,
77 ,
526 ,
'N',
'类别' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbtzjlqj',
'dba',
'jddj',
'精度等级',
0 ,
'精度等级',
0,
23 ,
0 ,
77 ,
293 ,
'N',
'精度等级' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbtzjlqj',
'dba',
'csbz',
'彩色标志',
0 ,
'彩色标志',
0,
23 ,
0 ,
77 ,
293 ,
'N',
'彩色标志' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbtzjlqj',
'dba',
'zt',
'状态',
0 ,
'状态',
0,
23 ,
0 ,
77 ,
161 ,
'N',
'状态' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbtzjlqj',
'dba',
'jdsj',
'鉴定时间',
0 ,
'鉴定时间',
0,
23 ,
0 ,
77 ,
293 ,
'N',
'鉴定时间' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbtzjlqj',
'dba',
'jddw',
'鉴定单位',
0 ,
'鉴定单位',
0,
23 ,
0 ,
77 ,
983 ,
'N',
'鉴定单位' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbtzjlqj',
'dba',
'jdjg',
'鉴定结果',
0 ,
'鉴定结果',
0,
23 ,
0 ,
77 ,
526 ,
'N',
'鉴定结果' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbtzjlqj',
'dba',
'yxrq',
'有效日期',
0 ,
'有效日期',
0,
23 ,
0 ,
77 ,
293 ,
'N',
'有效日期' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -