5.技术状态.sql

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

       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
        ('sbztdj',
       '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
        ('sbztdj',
       'dba',
       'djnr1',
        '点检内容',
       0 ,
        '点检内容',
       0,
       23 ,
       0 ,
       77 ,
       1441 ,
       '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',
       'djjg1',
        '点检结果',
       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
        ('sbztdj',
       'dba',
       'djnr2',
        '点检内容',
       0 ,
        '点检内容',
       0,
       23 ,
       0 ,
       77 ,
       1441 ,
       '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',
       'djjg2',
        '点检结果',
       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
        ('sbztdj',
       'dba',
       'djnr3',
        '点检内容',
       0 ,
        '点检内容',
       0,
       23 ,
       0 ,
       77 ,
       1441 ,
       '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',
       'djjg3',
        '点检结果',
       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
        ('sbztdj',
       'dba',
       'djnr4',
        '点检内容',
       0 ,
        '点检内容',
       0,
       23 ,
       0 ,
       77 ,
       1441 ,
       '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',
       'djjg4',
        '点检结果',
       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
        ('sbztdj',
       'dba',
       'djnr5',
        '点检内容',
       0 ,
        '点检内容',
       0,
       23 ,
       0 ,
       77 ,
       1441 ,
       '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',
       'djjg5',
        '点检结果',
       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
        ('sbztdj',
       'dba',
       'djnr6',
        '点检内容',
       0 ,
        '点检内容',
       0,
       23 ,
       0 ,
       77 ,
       1441 ,
       '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',
       'djjg6',
        '点检结果',
       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
        ('sbztdj',
       'dba',
       'djnr7',
        '点检内容',
       0 ,
        '点检内容',
       0,
       23 ,
       0 ,
       77 ,
       1441 ,
       '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',
       'djjg7',
        '点检结果',
       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
        ('sbztdj',
       'dba',
       'djnr8',
        '点检内容',
       0 ,
        '点检内容',
       0,
       23 ,
       0 ,
       77 ,
       1441 ,
       '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',
       'djjg8',
        '点检结果',
       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
        ('sbztdj',
       'dba',
       'djnr9',
        '点检内容',
       0 ,
        '点检内容',
       0,
       23 ,
       0 ,
       77 ,
       1441 ,
       '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',
       'djjg9',
        '点检结果',
       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
        ('sbztdj',
       'dba',
       'djnr10',
        '点检内容',
       0 ,
        '点检内容',
       0,
       23 ,
       0 ,
       77 ,
       1441 ,
       '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',
       'djjg10',
        '点检结果',
       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
        ('sbztdj',
       'dba',
       'djnr11',
        '点检内容',
       0 ,
        '点检内容',
       0,
       23 ,
       0 ,
       77 ,
       1441 ,
       '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',
       'djjg11',
        '点检结果',
       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
        ('sbztdj',
       'dba',
       'djnr12',
        '点检内容',
       0 ,
        '点检内容',
       0,
       23 ,
       0 ,
       77 ,
       1441 ,
       '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',
       'djjg12',
        '点检结果',
       0 ,
        '点检结果',
       0,
       23 ,
       0 ,
       77 ,
       293 ,
       'N',
        '点检结果' ) ;
 
insert into "dba".pbcatcol