1.前期管理.sql

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

CREATE TABLE "dba"."scxx"
        ("id" char(22) NOT NULL ,
       "dlrq" date  ,
       "sbmc" varchar(40)  ,
       "ggxh" varchar(20)  ,
       "jg" numeric(12,2)  ,
       "zzc" varchar(40)  ,
       "dz" varchar(40)  ,
       "yzbm" char(6)  ,
       "lxdh" varchar(20)  ,
       "cz" varchar(20)  ,
       "wz" varchar(40)  ,
       "wxx" varchar(20)  ,
       "aqx" varchar(20)  ,
       "nyxh" varchar(20)  ,
       "shfw" varchar(20)  ,
       "scqk" varchar(20)  ,
       "yhdc" varchar(20)  ,
       "bz" varchar(100)  ) ;
 
CREATE UNIQUE INDEX "scxx"
        ON "dba"."scxx"
        ("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
       ('scxx',
        '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
        ('scxx',
       '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
        ('scxx',
       'dba',
       'dlrq',
        '登录日期',
       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
        ('scxx',
       '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
        ('scxx',
       '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_mask,
        pbc_case,
        pbc_hght,
        pbc_wdth,
        pbc_bmap,
        pbc_cmnt )
        values
        ('scxx',
       'dba',
       'jg',
        '价格',
       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
        ('scxx',
       '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
        ('scxx',
       'dba',
       'dz',
        '地址',
       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
        ('scxx',
       'dba',
       'yzbm',
        '邮政编码',
       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
        ('scxx',
       'dba',
       'lxdh',
        '联系电话',
       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
        ('scxx',
       'dba',
       'cz',
        '传真',
       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
        ('scxx',
       'dba',
       'wz',
        '网址',
       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
        ('scxx',
       'dba',
       'wxx',
        '维修性',
       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
        ('scxx',
       'dba',
       'aqx',
        '安全性',
       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
        ('scxx',
       'dba',
       'nyxh',
        '能源消耗',
       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
        ('scxx',
       'dba',
       'shfw',
        '售后服务',
       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
        ('scxx',
       'dba',
       'scqk',
        '市场情况',
       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
        ('scxx',
       'dba',
       'yhdc',
        '用户调查',
       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
        ('scxx',
       'dba',
       'bz',
        '备注',
       0 ,
        '备注',
       0,
       23 ,
       0 ,
       77 ,
       2350 ,
       'N',
        '备注' ) ;
 
CREATE TABLE "dba"."cgjh"
        ("id" char(22) NOT NULL ,
       "rq" date  ,
       "ysbmc" char(40)  ,
       "ysbbh" char(12)  ,
       "yggxh" char(20)  ,
       "gxyy" varchar(50)  ,
       "sbmc" char(40)  ,
       "ggxh" char(20)  ,
       "zzc" varchar(40)  ,
       "yqjhrq" char(10)  ,
       "dj" numeric(12,2)  ,
       "sl" numeric(12,2)  ,
       "je" numeric(12,2)  ,
       "htrq" date  ,
       "sjjhrq" date  ,
       "azwcrq" date  ,
       "bz" varchar(50)  ) ;
 
CREATE UNIQUE INDEX "cgjh"
        ON "dba"."cgjh"
        ("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
       ('cgjh',
        '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
        ('cgjh',
       '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,