?? 3.設備附件.sql
字號:
CREATE TABLE "dba"."sbfsdj"
("id" char(22) NOT NULL ,
"djbh" varchar(20) ,
"djmc" varchar(30) ,
"djxh" varchar(20) ,
"djrl" numeric(6,2) ,
"lb" varchar(10) ,
"zs" integer ,
"xs" integer ,
"dy" numeric(7,2) ,
"dl" numeric(7,3) ,
"jf" varchar(10) ,
"glyz" varchar(20) ,
"jydj" varchar(20) ,
"xl" varchar(20) ,
"sccj" varchar(40) ,
"ccny" varchar(10) ,
"bfrq" varchar(10) ,
"bfyy" varchar(40) ,
"bh" char(22) ) ;
CREATE UNIQUE INDEX "sbfsdj"
ON "dba"."sbfsdj"
("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
('sbfsdj',
'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
('sbfsdj',
'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
('sbfsdj',
'dba',
'djbh',
'電機編號',
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
('sbfsdj',
'dba',
'djmc',
'電機名稱',
0 ,
'電機名稱',
0,
23 ,
0 ,
77 ,
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
('sbfsdj',
'dba',
'djxh',
'電機型號',
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
('sbfsdj',
'dba',
'djrl',
'電機容量',
0 ,
'電機容量',
0,
24 ,
'[General]',
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
('sbfsdj',
'dba',
'lb',
'類別',
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_mask,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbfsdj',
'dba',
'zs',
'轉速',
0 ,
'轉速',
0,
24 ,
'[General]',
0 ,
77 ,
206 ,
'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
('sbfsdj',
'dba',
'xs',
'相數',
0 ,
'相數',
0,
24 ,
'[General]',
0 ,
77 ,
206 ,
'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
('sbfsdj',
'dba',
'dy',
'電壓',
0 ,
'電壓',
0,
24 ,
'[General]',
0 ,
77 ,
270 ,
'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
('sbfsdj',
'dba',
'dl',
'電流',
0 ,
'電流',
0,
24 ,
'[General]',
0 ,
77 ,
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
('sbfsdj',
'dba',
'jf',
'接法',
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
('sbfsdj',
'dba',
'glyz',
'功率因子',
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
('sbfsdj',
'dba',
'jydj',
'絕緣等級',
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
('sbfsdj',
'dba',
'xl',
'效率',
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
('sbfsdj',
'dba',
'sccj',
'生產廠家',
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
('sbfsdj',
'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
('sbfsdj',
'dba',
'bfrq',
'報廢日期',
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
('sbfsdj',
'dba',
'bfyy',
'報廢原因',
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
('sbfsdj',
'dba',
'bh',
'設備序列號',
0 ,
'設備序列號',
0,
23 ,
0 ,
77 ,
567 ,
'N',
'設備序列號' ) ;
CREATE TABLE "dba"."sbpj"
("bh" char(22) NOT NULL ,
"pjbh" char(5) NOT NULL ,
"pjmc" char(20) ,
"ggxh" char(20) ,
"zzc" char(20) ,
"nx" integer ,
"sl" integer ,
"dj" numeric(10,2) ,
"zz" numeric(10,2) ) ;
CREATE UNIQUE INDEX "sbpj"
ON "dba"."sbpj"
("bh" ,
"pjbh" ) ;
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
('sbpj',
'dba',
-9,
400,
'N',
'N',
0,
34,
'Arial',
-9,
400,
'N',
'N',
0,
34,
'Arial',
-9,
400 ,
'N',
'N',
0,
34,
'Arial',
'設備配件') ;
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
('sbpj',
'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
('sbpj',
'dba',
'pjbh',
'配件編號',
0 ,
'配件編號',
0,
23 ,
0 ,
77 ,
183 ,
'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
('sbpj',
'dba',
'pjmc',
'配件名稱',
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,
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -