5.技术状态.sql

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

        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('sbztgz',
       'dba',
       'gzlx',
        '故障类型',
       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
        ('sbztgz',
       'dba',
       'gzyy',
        '故障原因',
       0 ,
        '故障原因',
       0,
       23 ,
       0 ,
       77 ,
       4641 ,
       'N',
        '故障原因' ) ;
 
CREATE TABLE "dba"."sbztsg"
        ("id" char(22) NOT NULL ,
       "bh" char(22) NOT NULL ,
       "fsrq" date  ,
       "pcrq" date  ,
       "sbbh" char(12)  ,
       "sbmc" char(40)  ,
       "sybm" char(40)  ,
       "sgxz" char(4)  ,
       "tjts" numeric(5,1)  ,
       "tjss" numeric(12,2)  ,
       "wxfy" numeric(12,2)  ,
       "sgzr" char(10)  ,
       "sgjg" varchar(200)  ,
       "yyfx" varchar(200)  ,
       "xfqk" varchar(200)  ,
       "yfcs" varchar(200)  ) ;
 
CREATE UNIQUE INDEX "sbztsg"
        ON "dba"."sbztsg"
        ("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
       ('sbztsg',
        '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
        ('sbztsg',
       '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
        ('sbztsg',
       '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
        ('sbztsg',
       'dba',
       'fsrq',
        '发生日期',
       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
        ('sbztsg',
       'dba',
       'pcrq',
        '排除日期',
       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
        ('sbztsg',
       '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
        ('sbztsg',
       '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
        ('sbztsg',
       '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
        ('sbztsg',
       'dba',
       'sgxz',
        '事故性质',
       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_mask,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('sbztsg',
       'dba',
       'tjts',
        '停机台时',
       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
        ('sbztsg',
       'dba',
       'tjss',
        '停机损失',
       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
        ('sbztsg',
       'dba',
       'wxfy',
        '维修费用',
       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_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('sbztsg',
       'dba',
       'sgzr',
        '事故责任',
       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
        ('sbztsg',
       'dba',
       'sgjg',
        '事故经过',
       0 ,
        '事故经过',
       0,
       23 ,
       0 ,
       77 ,
       1038 ,
       '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
        ('sbztsg',
       'dba',
       'yyfx',
        '原因分析',
       0 ,
        '原因分析',
       0,
       23 ,
       0 ,
       77 ,
       1038 ,
       '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
        ('sbztsg',
       'dba',
       'xfqk',
        '修复情况',
       0 ,
        '修复情况',
       0,
       23 ,
       0 ,
       77 ,
       1038 ,
       '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
        ('sbztsg',
       'dba',
       'yfcs',
        '预防措施',
       0 ,
        '预防措施',
       0,
       23 ,
       0 ,
       77 ,
       1038 ,
       'N',
        '预防措施' ) ;
 
CREATE TABLE "dba"."sbztby"
        ("id" char(22) NOT NULL ,
       "bh" char(22) NOT NULL ,
       "sbbh" char(12)  ,
       "sbmc" char(40)  ,
       "ggxh" char(20)  ,
       "sybm" char(40)  ,
       "qsrq" date  ,
       "jsrq" date  ,
       "bygh" char(10)  ,
       "byjb" char(4)  ,
       "bydw" varchar(40)  ,
       "byfy" numeric(12,2)  ,
       "tgts" integer  ,
       "qggs" numeric(5,1)  ,
       "jggs" numeric(5,1)  ,
       "dggs" numeric(5,1)  ,
       "gshj" numeric(5,1)  ,
       "bz" varchar(100)  ) ;
 
CREATE UNIQUE INDEX "sbztby"
        ON "dba"."sbztby"
        ("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
       ('sbztby',
        '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
        ('sbztby',
       '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
        ('sbztby',
       'dba',
       'bh',
        '设备序列号',
       0 ,
        '设备序列号',
       0,
       23 ,
       0 ,
       77 ,
       567 ,
       'N',
        '设备序列号' ) ;
 
insert into "dba".pbcatcol
       (pbc_tnam,
        pbc_ownr,
        pbc_cnam,
        pbc_labl,
        pbc_lpos,