2.基础数据.sql

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

 
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
        ('sbglry',
       'dba',
       'gz',
        '工种',
       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
        ('sbglry',
       'dba',
       'zzfw',
        '职责范围',
       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
        ('sbglry',
       'dba',
       'gzzsmc',
        '工种证书名称',
       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
        ('sbglry',
       'dba',
       'fzjg',
        '发证机关',
       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
        ('sbglry',
       'dba',
       'fzrq',
        '发证日期',
       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
        ('sbglry',
       'dba',
       'csbgzrq',
        '从事本工种日期',
       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
        ('sbglry',
       'dba',
       'dwdh',
        '单位电话',
       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
        ('sbglry',
       'dba',
       'jtdh',
        '家庭电话',
       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
        ('sbglry',
       'dba',
       'ch',
        '传呼',
       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
        ('sbglry',
       'dba',
       'zp',
        '照片',
       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
        ('sbglry',
       'dba',
       'bz',
        '备注',
       0 ,
        '备注',
       0,
       23 ,
       0 ,
       77 ,
       4641 ,
       'N',
        '备注' ) ;
 
CREATE TABLE "dba"."sbk"
               ("bh" char(22) NOT NULL ,
              "sbbh" char(12) NOT NULL ,
              "zch" char(12)  ,
              "sbmc" char(40) NOT NULL ,
              "ggxh" char(20)  ,
              "yt" char(6)  ,
              "zc" char(4)  ,
              "lksj" date NOT NULL ,
              "qysj" date NOT NULL ,
              "yz" numeric(12,2) NOT NULL ,
              "sblx" char(20)  ,
              "abc" char(1)  ,
              "sblb" char(6)  ,
              "cwfl" char(10)  ,
              "zzc" char(40)  ,
              "ccsj" date  ,
              "ccbh" char(20)  ,
              "sbzl" numeric(10,3)  ,
              "sbcc" char(20)  ,
              "fzxsj" numeric(5,1)  ,
              "fzxsd" numeric(5,1)  ,
              "gys" char(40)  ,
              "dj" numeric(12,2) NOT NULL ,
              "azjqtfy" numeric(12,2)  ,
              "synx" integer NOT NULL ,
              "jczbl" numeric(5,2)  ,
              "zjqs" date NOT NULL ,
              "jkgc" char(4)  ,
              "jkgb" char(10)  ,
              "sbywmc" char(40)  ,
              "qybm" char(40) NOT NULL ,
              "sybm" char(40)  ,
              "czdd" char(40)  ,
              "zyzt" char(4)  ,
              "whzt" integer  ,
              "zdts" numeric(5,1)  ,
              "lyts" numeric(5,1)  ,
              "wxtjts" numeric(5,1)  ,
              "gztjts" numeric(5,1)  ,
              "tp" varchar(50)  ,
              "bz" varchar(50)
       , PRIMARY KEY ("bh")) ;
 
CREATE UNIQUE INDEX "sbbh"
        ON "dba"."sbk"
        ("sbbh" ) ;
 
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
       ('sbk',
        '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
        ('sbk',
       'dba',
       'bh',
        '编号',
       0 ,
        '编号',
       0,
       23 ,
       0 ,
       77 ,
       604 ,
       '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
        ('sbk',
       'dba',
       'sbbh',
        '设备编号',
       0 ,
        '设备编号',
       0,
       25 ,
       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
        ('sbk',
       'dba',
       'zch',
        '资产号',
       0 ,
        '资产号',
       0,
       25 ,
       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
        ('sbk',
       '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
        ('sbk',
       '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
        ('sbk',
       'dba',
       'yt',
        '用途',
       0 ,
        '用途',
       0,
       23 ,
       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_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('sbk',
       'dba',
       'zc',
        '主次',
       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
        ('sbk',
       'dba',
       'lksj',
        '立卡时间',
       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
        ('sbk',
       'dba',
       'qysj',
        '启用时间',
       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_mask,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('sbk',
       'dba',
       'yz',
        '原值',
       0 ,
        '原值',
       0,
       24 ,
        '[General]',
       0 ,
       77 ,
       481 ,
       '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
        ('sbk',
       'dba',
       'sblx',
        '设备类型',
       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
        ('sbk',
       'dba',
       'abc',
        'ABC类',
       0 ,
        'ABC类',
       0,
       25 ,
       0 ,
       77 ,
       87 ,
       'N',
        'ABC类' ) ;
 
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
        ('sbk',
       'dba',
       'sblb',
        '设备类别',
       0 ,
        '设备类别',
       0,
       23 ,
       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_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values