2.基础数据.sql

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

        ('sbk',
       'dba',
       'cwfl',
        '财务分类',
       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',
       'zzc',
        '制造厂',
       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',
       'ccsj',
        '出厂时间',
       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
        ('sbk',
       'dba',
       'ccbh',
        '出厂编号',
       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
        ('sbk',
       'dba',
       'sbzl',
        '设备重量',
       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
        ('sbk',
       'dba',
       'sbcc',
        '设备尺寸',
       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
        ('sbk',
       'dba',
       'fzxsj',
        '复杂系数机',
       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
        ('sbk',
       'dba',
       'fzxsd',
        '复杂系数电',
       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_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('sbk',
       'dba',
       'gys',
        '供应商',
       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_mask,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('sbk',
       'dba',
       'dj',
        '单价',
       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_mask,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('sbk',
       'dba',
       'azjqtfy',
        '安装及其他费用',
       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_mask,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('sbk',
       'dba',
       'synx',
        '使用年限',
       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
        ('sbk',
       'dba',
       'jczbl',
        '净残值比例',
       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_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('sbk',
       'dba',
       'zjqs',
        '折旧起始',
       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',
       'jkgc',
        '进口国产',
       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',
       'jkgb',
        '进口国别',
       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
        ('sbk',
       'dba',
       'sbywmc',
        '设备英文名称',
       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',
       'qybm',
        '启用部门',
       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
        ('sbk',
       'dba',
       'sybm',
        '使用部门',
       0 ,
        '使用部门',
       0,
       23 ,
       0 ,
       0 ,
       0 ,
       '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',
       'czdd',
        '初装地点',
       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
        ('sbk',
       'dba',
       'zyzt',
        '在用状态',
       0 ,
        '在用状态',
       0,
       25 ,
       0 ,
       77 ,
       0 ,
       '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',
       'whzt',
        '完好状态',
       0 ,
        '完好状态',
       0,
       24 ,
       0 ,
       77 ,
       0 ,
       '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',
       'zdts',
        '制度台时',
       0 ,
        '制度台时',
       0,
       24 ,
       0 ,
       77 ,
       0 ,
       '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',
       'lyts',
        '利用台时',
       0 ,
        '利用台时',
       0,
       24 ,
       0 ,
       0 ,
       0 ,
       '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',
       'wxtjts',
        '维修停机台时',
       0 ,
        '维修停机台时',
       0,
       24 ,
       0 ,
       0 ,
       0 ,
       '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',
       'gztjts',
        '故障停机台时',
       0 ,
        '故障停机台时',
       0,
       24 ,
       0 ,
       0 ,
       0 ,
       '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',
       'tp',
        '图片',
       0 ,
        '图片',
       0,
       23 ,
       0 ,
       77 ,
       1207 ,
       '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',
       'bz',
        '备注',
       0 ,
        '备注',
       0,
       23 ,
       0 ,
       77 ,
       1207 ,
       'N',
        '备注' ) ;