?? 6.設備維修.sql
字號:
CREATE TABLE "dba"."sbwxjh"
("id" char(22) NOT NULL ,
"bh" char(22) NOT NULL ,
"sbbh" varchar(12) ,
"sbmc" varchar(40) ,
"ggxh" varchar(20) ,
"sybm" varchar(40) ,
"wxbh" varchar(10) ,
"wxlb" varchar(20) ,
"xz" varchar(4) ,
"qsrq" date ,
"jsrq" date ,
"tjts" numeric(5,1) ,
"wxdw" varchar(40) ,
"wxnr" varchar(40) ,
"qggs" numeric(5,1) ,
"jggs" numeric(5,1) ,
"dggs" numeric(5,1) ,
"qtgs" numeric(5,1) ,
"gsfy" numeric(10,2) ,
"clfy" numeric(10,2) ,
"glfy" numeric(10,2) ,
"qtfy" numeric(10,2) ,
"bz" varchar(100) ,
"sszt" char(1) DEFAULT '0') ;
CREATE UNIQUE INDEX "sbwxjh"
ON "dba"."sbwxjh"
("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
('sbwxjh',
'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
('sbwxjh',
'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
('sbwxjh',
'dba',
'bh',
'設備序列號',
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
('sbwxjh',
'dba',
'sbbh',
'設備編號',
0 ,
'設備編號',
0,
23 ,
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
('sbwxjh',
'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
('sbwxjh',
'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
('sbwxjh',
'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
('sbwxjh',
'dba',
'wxbh',
'維修編號',
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
('sbwxjh',
'dba',
'wxlb',
'維修類別',
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
('sbwxjh',
'dba',
'xz',
'性質',
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
('sbwxjh',
'dba',
'qsrq',
'起始日期',
0 ,
'起始日期',
0,
23 ,
0 ,
77 ,
247 ,
'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
('sbwxjh',
'dba',
'jsrq',
'結束日期',
0 ,
'結束日期',
0,
23 ,
0 ,
77 ,
247 ,
'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
('sbwxjh',
'dba',
'tjts',
'停機臺時',
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_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbwxjh',
'dba',
'wxdw',
'維修單位',
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
('sbwxjh',
'dba',
'wxnr',
'維修內容',
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_mask,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbwxjh',
'dba',
'qggs',
'鉗工工時',
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
('sbwxjh',
'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
('sbwxjh',
'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
('sbwxjh',
'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
('sbwxjh',
'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
('sbwxjh',
'dba',
'clfy',
'材料費用',
0 ,
'材料費用',
0,
24 ,
'[General]',
0 ,
77 ,
343 ,
'N',
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -