5.技术状态.sql

一个很不错的实验室设备管理系统,用PB作为开发工具,具有一定的代表性.

        pbc_hdr,
        pbc_hpos,
        pbc_jtfy,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('sbztby',
       '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
        ('sbztby',
       '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
        ('sbztby',
       '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
        ('sbztby',
       '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
        ('sbztby',
       '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
        ('sbztby',
       '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_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('sbztby',
       'dba',
       'bygh',
        '保养工号',
       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
        ('sbztby',
       'dba',
       'byjb',
        '保养级别',
       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
        ('sbztby',
       'dba',
       'bydw',
        '保养单位',
       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
        ('sbztby',
       'dba',
       'byfy',
        '保养费用',
       0 ,
        '保养费用',
       0,
       24 ,
        '[General]',
       0 ,
       77 ,
       389 ,
       '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
        ('sbztby',
       'dba',
       'tgts',
        '停工台时',
       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
        ('sbztby',
       '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
        ('sbztby',
       '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
        ('sbztby',
       '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
        ('sbztby',
       'dba',
       'gshj',
        '工时合计',
       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
        ('sbztby',
       'dba',
       'bz',
        '备注',
       0 ,
        '备注',
       0,
       23 ,
       0 ,
       77 ,
       2350 ,
       'N',
        '备注' ) ;
 
CREATE TABLE "dba"."sbztdj"
        ("id" char(22) NOT NULL ,
       "bh" char(22)  ,
       "sbbh" char(12)  ,
       "sbmc" varchar(40)  ,
       "ggxh" varchar(20)  ,
       "sblb" char(10)  ,
       "sybm" varchar(40)  ,
       "djnr1" varchar(60)  ,
       "djjg1" varchar(10)  ,
       "djnr2" varchar(60)  ,
       "djjg2" varchar(10)  ,
       "djnr3" varchar(60)  ,
       "djjg3" varchar(10)  ,
       "djnr4" varchar(60)  ,
       "djjg4" varchar(10)  ,
       "djnr5" varchar(60)  ,
       "djjg5" varchar(10)  ,
       "djnr6" varchar(60)  ,
       "djjg6" varchar(10)  ,
       "djnr7" varchar(60)  ,
       "djjg7" varchar(10)  ,
       "djnr8" varchar(60)  ,
       "djjg8" varchar(10)  ,
       "djnr9" varchar(60)  ,
       "djjg9" varchar(10)  ,
       "djnr10" varchar(60)  ,
       "djjg10" varchar(10)  ,
       "djnr11" varchar(60)  ,
       "djjg11" varchar(10)  ,
       "djnr12" varchar(60)  ,
       "djjg12" varchar(10)  ,
       "djjl" varchar(200)  ,
       "djrq" date  ) ;
 
CREATE UNIQUE INDEX "sbztdj"
        ON "dba"."sbztdj"
        ("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
       ('sbztdj',
        '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
        ('sbztdj',
       '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
        ('sbztdj',
       '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
        ('sbztdj',
       '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
        ('sbztdj',
       '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
        ('sbztdj',
       '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
        ('sbztdj',
       'dba',
       'sblb',
        '设备类别',
       0 ,
        '设备类别',
       0,
       23 ,
       0 ,
       77 ,