?? 6.設備維修.sql
字號:
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
('sbwxss',
'dba',
'jggs',
'機工工時',
0 ,
'機工工時',
0,
24 ,
'[General]',
0 ,
77 ,
229 ,
'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
('sbwxss',
'dba',
'dggs',
'電工工時',
0 ,
'電工工時',
0,
24 ,
'[General]',
0 ,
77 ,
229 ,
'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
('sbwxss',
'dba',
'qtgs',
'其他工時',
0 ,
'其他工時',
0,
24 ,
'[General]',
0 ,
77 ,
229 ,
'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
('sbwxss',
'dba',
'gsfy',
'工時費用',
0 ,
'工時費用',
0,
24 ,
'[General]',
0 ,
77 ,
343 ,
'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
('sbwxss',
'dba',
'clfy',
'材料費用',
0 ,
'材料費用',
0,
24 ,
'[General]',
0 ,
77 ,
343 ,
'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
('sbwxss',
'dba',
'glfy',
'管理費用',
0 ,
'管理費用',
0,
24 ,
'[General]',
0 ,
77 ,
343 ,
'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
('sbwxss',
'dba',
'qtfy',
'其他費用',
0 ,
'其他費用',
0,
24 ,
'[General]',
0 ,
77 ,
343 ,
'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
('sbwxss',
'dba',
'jhts',
'計劃臺時',
0 ,
'計劃臺時',
0,
24 ,
'[General]',
0 ,
77 ,
229 ,
'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
('sbwxss',
'dba',
'jhgs',
'計劃工時',
0 ,
'計劃工時',
0,
24 ,
'[General]',
0 ,
77 ,
229 ,
'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
('sbwxss',
'dba',
'jhfy',
'計劃費用',
0 ,
'計劃費用',
0,
24 ,
'[General]',
0 ,
77 ,
343 ,
'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
('sbwxss',
'dba',
'bz',
'備注',
0 ,
'備注',
0,
23 ,
0 ,
77 ,
2350 ,
'N',
'備注' ) ;
CREATE TABLE "dba"."sbwxbj"
("id" char(22) NOT NULL ,
"wxid" char(22) NOT NULL ,
"bjbh" varchar(10) ,
"mc" varchar(30) ,
"ggxh" varchar(20) ,
"dw" varchar(10) ,
"dj" numeric(10,2) ,
"sl" numeric(10,2) ,
"je" numeric(10,2) ) ;
CREATE UNIQUE INDEX "sbwxbj"
ON "dba"."sbwxbj"
("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
('sbwxbj',
'dba',
-9,
400,
'N',
'N',
134,
2,
'宋體',
-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
('sbwxbj',
'dba',
'id',
'序列號',
0 ,
'序列號',
0,
23 ,
0 ,
57 ,
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
('sbwxbj',
'dba',
'wxid',
'維修序號',
0 ,
'維修序號',
0,
23 ,
0 ,
57 ,
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
('sbwxbj',
'dba',
'bjbh',
'備件編號',
0 ,
'備件編號',
0,
23 ,
0 ,
57 ,
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
('sbwxbj',
'dba',
'mc',
'名稱',
0 ,
'名稱',
0,
23 ,
0 ,
57 ,
750 ,
'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
('sbwxbj',
'dba',
'ggxh',
'規(guī)格型號',
0 ,
'規(guī)格型號',
0,
23 ,
0 ,
57 ,
526 ,
'N',
'規(guī)格型號' ) ;
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
('sbwxbj',
'dba',
'dw',
'單位',
0 ,
'單位',
0,
23 ,
0 ,
57 ,
293 ,
'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
('sbwxbj',
'dba',
'dj',
'單價',
0 ,
'單價',
0,
24 ,
'[General]',
0 ,
57 ,
343 ,
'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
('sbwxbj',
'dba',
'sl',
'數(shù)量',
0 ,
'數(shù)量',
0,
24 ,
'[General]',
0 ,
57 ,
343 ,
'N',
'數(shù)量' ) ;
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
('sbwxbj',
'dba',
'je',
'金額',
0 ,
'金額',
0,
24 ,
'[General]',
0 ,
57 ,
343 ,
'N',
'金額' ) ;
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -