📄 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 + -