6.设备维修.sql

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

 
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
        ('sbwxss',
       '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
        ('sbwxss',
       '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
        ('sbwxss',
       'dba',
       'qtgs',
        '其他工时',
       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
        ('sbwxss',
       'dba',
       'gsfy',
        '工时费用',
       0 ,
        '工时费用',
       0,
       24 ,
        '[General]',
       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_mask,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('sbwxss',
       'dba',
       'clfy',
        '材料费用',
       0 ,
        '材料费用',
       0,
       24 ,
        '[General]',
       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_mask,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('sbwxss',
       'dba',
       'glfy',
        '管理费用',
       0 ,
        '管理费用',
       0,
       24 ,
        '[General]',
       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_mask,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('sbwxss',
       'dba',
       'qtfy',
        '其他费用',
       0 ,
        '其他费用',
       0,
       24 ,
        '[General]',
       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_mask,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('sbwxss',
       'dba',
       'jhts',
        '计划台时',
       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
        ('sbwxss',
       'dba',
       'jhgs',
        '计划工时',
       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
        ('sbwxss',
       'dba',
       'jhfy',
        '计划费用',
       0 ,
        '计划费用',
       0,
       24 ,
        '[General]',
       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
        ('sbwxss',
       'dba',
       'bz',
        '备注',
       0 ,
        '备注',
       0,
       23 ,
       0 ,
       77 ,
       2350 ,
       'N',
        '备注' ) ;
 
CREATE TABLE "dba"."sbwxbj"
        ("id" char(22) NOT NULL ,
       "wxid" char(22) NOT NULL ,
       "bjbh" varchar(10)  ,
       "mc" varchar(30)  ,
       "ggxh" varchar(20)  ,
       "dw" varchar(10)  ,
       "dj" numeric(10,2)  ,
       "sl" numeric(10,2)  ,
       "je" numeric(10,2)  ) ;
 
CREATE UNIQUE INDEX "sbwxbj"
        ON "dba"."sbwxbj"
        ("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
       ('sbwxbj',
        'dba',
        -9,
        400,
        'N',
        'N',
        134,
        2,
        '宋体',
        -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
        ('sbwxbj',
       'dba',
       'id',
        '序列号',
       0 ,
        '序列号',
       0,
       23 ,
       0 ,
       57 ,
       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
        ('sbwxbj',
       'dba',
       'wxid',
        '维修序号',
       0 ,
        '维修序号',
       0,
       23 ,
       0 ,
       57 ,
       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
        ('sbwxbj',
       'dba',
       'bjbh',
        '备件编号',
       0 ,
        '备件编号',
       0,
       23 ,
       0 ,
       57 ,
       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
        ('sbwxbj',
       'dba',
       'mc',
        '名称',
       0 ,
        '名称',
       0,
       23 ,
       0 ,
       57 ,
       750 ,
       '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
        ('sbwxbj',
       'dba',
       'ggxh',
        '规格型号',
       0 ,
        '规格型号',
       0,
       23 ,
       0 ,
       57 ,
       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
        ('sbwxbj',
       'dba',
       'dw',
        '单位',
       0 ,
        '单位',
       0,
       23 ,
       0 ,
       57 ,
       293 ,
       '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
        ('sbwxbj',
       'dba',
       'dj',
        '单价',
       0 ,
        '单价',
       0,
       24 ,
        '[General]',
       0 ,
       57 ,
       343 ,
       '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
        ('sbwxbj',
       'dba',
       'sl',
        '数量',
       0 ,
        '数量',
       0,
       24 ,
        '[General]',
       0 ,
       57 ,
       343 ,
       '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
        ('sbwxbj',
       'dba',
       'je',
        '金额',
       0 ,
        '金额',
       0,
       24 ,
        '[General]',
       0 ,
       57 ,
       343 ,
       'N',
        '金额' ) ;