?? 2.基礎數據.sql
字號:
CREATE TABLE "dba"."department"
("bh" char(10) NOT NULL ,
"bm" char(40) ,
"zg" char(8) ,
"dh" char(20) ,
"js" integer DEFAULT 1,
"mx" char(1) DEFAULT 'Y') ;
CREATE UNIQUE INDEX "department"
ON "dba"."department"
("bh" ) ;
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
('department',
'dba',
-10,
400,
'N',
'N',
0,
34,
'Arial',
-10,
400,
'N',
'N',
0,
34,
'Arial',
-10,
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
('department',
'dba',
'bh',
'編號',
0 ,
'編號',
0,
23 ,
0 ,
65 ,
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
('department',
'dba',
'bm',
'部門',
0 ,
'部門',
0,
23 ,
0 ,
0 ,
0 ,
'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
('department',
'dba',
'zg',
'主管',
0 ,
'主管',
0,
23 ,
0 ,
0 ,
0 ,
'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
('department',
'dba',
'dh',
'電話',
0 ,
'電話',
0,
23 ,
0 ,
0 ,
0 ,
'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
('department',
'dba',
'js',
'級數',
0 ,
'級數',
0,
24 ,
0 ,
0 ,
0 ,
'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
('department',
'dba',
'mx',
'明細',
0 ,
'明細',
0,
25 ,
0 ,
0 ,
0 ,
'N',
'明細' ) ;
CREATE TABLE "dba"."sblb"
("bh" char(10) NOT NULL ,
"sblb" varchar(40) ,
"js" integer DEFAULT 1,
"mx" char(1) DEFAULT 'Y') ;
CREATE UNIQUE INDEX "sblb"
ON "dba"."sblb"
("bh" ) ;
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
('sblb',
'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
('sblb',
'dba',
'bh',
'類別編號',
0 ,
'類別編號',
0,
25 ,
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
('sblb',
'dba',
'sblb',
'設備類別',
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
('sblb',
'dba',
'js',
'級數',
0 ,
'級數',
0,
25 ,
'[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_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sblb',
'dba',
'mx',
'明細',
0 ,
'明細',
0,
25 ,
0 ,
77 ,
87 ,
'N',
'明細' ) ;
CREATE TABLE "dba"."sbglry"
("id" char(22) NOT NULL ,
"bh" char(10) ,
"xm" char(10) NOT NULL ,
"xb" char(2) ,
"csny" date ,
"whcd" char(10) ,
"gzdw" char(20) ,
"zw" char(20) ,
"zc" char(10) ,
"jsdj" char(10) ,
"lb" char(10) ,
"gz" char(10) ,
"zzfw" char(30) ,
"gzzsmc" char(20) ,
"fzjg" char(30) ,
"fzrq" date ,
"csbgzrq" date ,
"dwdh" char(20) ,
"jtdh" char(20) ,
"ch" char(20) ,
"zp" char(40) ,
"bz" char(200) ) ;
CREATE UNIQUE INDEX "sbglry"
ON "dba"."sbglry"
("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
('sbglry',
'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
('sbglry',
'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
('sbglry',
'dba',
'bh',
'編號',
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
('sbglry',
'dba',
'xm',
'姓名',
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
('sbglry',
'dba',
'xb',
'性別',
0 ,
'性別',
0,
23 ,
0 ,
77 ,
110 ,
'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
('sbglry',
'dba',
'csny',
'出生年月',
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
('sbglry',
'dba',
'whcd',
'文化程度',
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
('sbglry',
'dba',
'gzdw',
'工作單位',
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
('sbglry',
'dba',
'zw',
'職務',
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
('sbglry',
'dba',
'zc',
'職稱',
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
('sbglry',
'dba',
'jsdj',
'技術等級',
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
('sbglry',
'dba',
'lb',
'類別',
0 ,
'類別',
0,
23 ,
0 ,
77 ,
293 ,
'N',
'類別' ) ;
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -