3.设备附件.sql

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

CREATE TABLE "dba"."sbfsdj"
        ("id" char(22) NOT NULL ,
       "djbh" varchar(20)  ,
       "djmc" varchar(30)  ,
       "djxh" varchar(20)  ,
       "djrl" numeric(6,2)  ,
       "lb" varchar(10)  ,
       "zs" integer  ,
       "xs" integer  ,
       "dy" numeric(7,2)  ,
       "dl" numeric(7,3)  ,
       "jf" varchar(10)  ,
       "glyz" varchar(20)  ,
       "jydj" varchar(20)  ,
       "xl" varchar(20)  ,
       "sccj" varchar(40)  ,
       "ccny" varchar(10)  ,
       "bfrq" varchar(10)  ,
       "bfyy" varchar(40)  ,
       "bh" char(22)  ) ;
 
CREATE UNIQUE INDEX "sbfsdj"
        ON "dba"."sbfsdj"
        ("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
       ('sbfsdj',
        '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
        ('sbfsdj',
       '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
        ('sbfsdj',
       'dba',
       'djbh',
        '电机编号',
       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
        ('sbfsdj',
       'dba',
       'djmc',
        '电机名称',
       0 ,
        '电机名称',
       0,
       23 ,
       0 ,
       77 ,
       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
        ('sbfsdj',
       'dba',
       'djxh',
        '电机型号',
       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_mask,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('sbfsdj',
       'dba',
       'djrl',
        '电机容量',
       0 ,
        '电机容量',
       0,
       24 ,
        '[General]',
       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
        ('sbfsdj',
       'dba',
       'lb',
        '类别',
       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_mask,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('sbfsdj',
       'dba',
       'zs',
        '转速',
       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
        ('sbfsdj',
       'dba',
       'xs',
        '相数',
       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
        ('sbfsdj',
       'dba',
       'dy',
        '电压',
       0 ,
        '电压',
       0,
       24 ,
        '[General]',
       0 ,
       77 ,
       270 ,
       '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
        ('sbfsdj',
       'dba',
       'dl',
        '电流',
       0 ,
        '电流',
       0,
       24 ,
        '[General]',
       0 ,
       77 ,
       270 ,
       '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
        ('sbfsdj',
       'dba',
       'jf',
        '接法',
       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
        ('sbfsdj',
       'dba',
       'glyz',
        '功率因子',
       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
        ('sbfsdj',
       'dba',
       'jydj',
        '绝缘等级',
       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
        ('sbfsdj',
       'dba',
       'xl',
        '效率',
       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
        ('sbfsdj',
       'dba',
       'sccj',
        '生产厂家',
       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
        ('sbfsdj',
       'dba',
       'ccny',
        '出厂年月',
       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
        ('sbfsdj',
       'dba',
       'bfrq',
        '报废日期',
       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
        ('sbfsdj',
       'dba',
       'bfyy',
        '报废原因',
       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
        ('sbfsdj',
       'dba',
       'bh',
        '设备序列号',
       0 ,
        '设备序列号',
       0,
       23 ,
       0 ,
       77 ,
       567 ,
       'N',
        '设备序列号' ) ;
 
CREATE TABLE "dba"."sbpj"
        ("bh" char(22) NOT NULL ,
       "pjbh" char(5) NOT NULL ,
       "pjmc" char(20)  ,
       "ggxh" char(20)  ,
       "zzc" char(20)  ,
       "nx" integer  ,
       "sl" integer  ,
       "dj" numeric(10,2)  ,
       "zz" numeric(10,2)  ) ;
 
CREATE UNIQUE INDEX "sbpj"
        ON "dba"."sbpj"
        ("bh" ,
       "pjbh" ) ;
 
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
       ('sbpj',
        '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
        ('sbpj',
       '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
        ('sbpj',
       'dba',
       'pjbh',
        '配件编号',
       0 ,
        '配件编号',
       0,
       23 ,
       0 ,
       77 ,
       183 ,
       '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
        ('sbpj',
       'dba',
       'pjmc',
        '配件名称',
       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,