📄 7.特种设备.sql
字号:
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbtzjlqj',
'dba',
'bz',
'备注',
0 ,
'备注',
0,
23 ,
0 ,
77 ,
4641 ,
'N',
'备注' ) ;
CREATE TABLE "dba"."sbtzjdcl"
("id" char(22) NOT NULL ,
"sbbh" varchar(12) ,
"clmc" varchar(20) ,
"xh" varchar(20) ,
"lb" varchar(10) ,
"ccny" varchar(10) ,
"jg" numeric(12,2) ,
"sybm" varchar(40) ,
"fzdd" varchar(40) ,
"zkrs" integer ,
"qd" varchar(10) ,
"zz" integer ,
"hdzz" integer ,
"fdjh" varchar(20) ,
"cjhm" varchar(20) ,
"cph" varchar(20) ,
"rlzl" varchar(10) ,
"gdyy" varchar(10) ,
"gddyy" varchar(10) ,
"ys" varchar(10) ,
"dbqsrq" varchar(10) ,
"dxzq" integer ,
"hjyzq" integer ,
"hjysl" numeric(10,2) ,
"hyd" varchar(20) ) ;
CREATE UNIQUE INDEX "sbtzjdcl"
ON "dba"."sbtzjdcl"
("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
('sbtzjdcl',
'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
('sbtzjdcl',
'dba',
'id',
'序列号',
0 ,
'序列号',
0,
23 ,
0 ,
61 ,
453 ,
'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
('sbtzjdcl',
'dba',
'sbbh',
'设备编号',
0 ,
'设备编号',
0,
23 ,
0 ,
61 ,
270 ,
'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
('sbtzjdcl',
'dba',
'clmc',
'车辆名称',
0 ,
'车辆名称',
0,
23 ,
0 ,
61 ,
421 ,
'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
('sbtzjdcl',
'dba',
'xh',
'型号',
0 ,
'型号',
0,
23 ,
0 ,
61 ,
421 ,
'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
('sbtzjdcl',
'dba',
'lb',
'类别',
0 ,
'类别',
0,
23 ,
0 ,
61 ,
238 ,
'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
('sbtzjdcl',
'dba',
'ccny',
'出厂年月',
0 ,
'出厂年月',
0,
23 ,
0 ,
61 ,
238 ,
'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
('sbtzjdcl',
'dba',
'jg',
'价格',
0 ,
'价格',
0,
24 ,
'[General]',
0 ,
61 ,
311 ,
'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
('sbtzjdcl',
'dba',
'sybm',
'使用部门',
0 ,
'使用部门',
0,
23 ,
0 ,
61 ,
782 ,
'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
('sbtzjdcl',
'dba',
'fzdd',
'放置地点',
0 ,
'放置地点',
0,
23 ,
0 ,
61 ,
782 ,
'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
('sbtzjdcl',
'dba',
'zkrs',
'载客人数',
0 ,
'载客人数',
0,
24 ,
'[General]',
0 ,
61 ,
165 ,
'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
('sbtzjdcl',
'dba',
'qd',
'驱动',
0 ,
'驱动',
0,
23 ,
0 ,
61 ,
238 ,
'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
('sbtzjdcl',
'dba',
'zz',
'自重',
0 ,
'自重',
0,
24 ,
'[General]',
0 ,
61 ,
165 ,
'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
('sbtzjdcl',
'dba',
'hdzz',
'核定载重',
0 ,
'核定载重',
0,
24 ,
'[General]',
0 ,
61 ,
165 ,
'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
('sbtzjdcl',
'dba',
'fdjh',
'发动机号',
0 ,
'发动机号',
0,
23 ,
0 ,
61 ,
421 ,
'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
('sbtzjdcl',
'dba',
'cjhm',
'车架号码',
0 ,
'车架号码',
0,
23 ,
0 ,
61 ,
421 ,
'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
('sbtzjdcl',
'dba',
'cph',
'车牌号',
0 ,
'车牌号',
0,
23 ,
0 ,
61 ,
421 ,
'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
('sbtzjdcl',
'dba',
'rlzl',
'燃料种类',
0 ,
'燃料种类',
0,
23 ,
0 ,
61 ,
238 ,
'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
('sbtzjdcl',
'dba',
'gdyy',
'规定用油',
0 ,
'规定用油',
0,
23 ,
0 ,
61 ,
238 ,
'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
('sbtzjdcl',
'dba',
'gddyy',
'规定代用油',
0 ,
'规定代用油',
0,
23 ,
0 ,
61 ,
238 ,
'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
('sbtzjdcl',
'dba',
'ys',
'颜色',
0 ,
'颜色',
0,
23 ,
0 ,
61 ,
238 ,
'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
('sbtzjdcl',
'dba',
'dbqsrq',
'定标起始日期',
0 ,
'定标起始日期',
0,
23 ,
0 ,
61 ,
238 ,
'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
('sbtzjdcl',
'dba',
'dxzq',
'大修周期',
0 ,
'大修周期',
0,
24 ,
'[General]',
0 ,
61 ,
165 ,
'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
('sbtzjdcl',
'dba',
'hjyzq',
'换机油周期',
0 ,
'换机油周期',
0,
24 ,
'[General]',
0 ,
61 ,
165 ,
'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
('sbtzjdcl',
'dba',
'hjysl',
'换机油数量',
0 ,
'换机油数量',
0,
24 ,
'[General]',
0 ,
61 ,
270 ,
'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
('sbtzjdcl',
'dba',
'hyd',
'换油点',
0 ,
'换油点',
0,
23 ,
0 ,
61 ,
421 ,
'N',
'换油点' ) ;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -