labmis_wdgl.sql

十分完善地实现了实验室管理系统

create table dbo.labmis_wdgl
       (wdbh char(4) not null,
       wdmc nvarchar(60) null,
       wdnr text null,
       jdr nvarchar(10) null,
       wdmj char(2) null,
       gjc text null,
       jdsj datetime null) ;
 
alter table dbo.labmis_wdgl
       add constraint wdbh primary key  nonclustered
       (wdbh) ;
 
insert into dbo.pbcattbl
        (pbt_tnam, pbt_tid, 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  ( 'labmis_wdgl',
       object_id('dbo.labmis_wdgl'),
        'dbo',
        -12,  400,  'N',  'N',  0,  34,
        'Arial',
        -12,  400,  'N',  'N',  0,  34,
        'Arial',
        -9,  400,  'N',  'N',  134,  2,
        '宋体',
       ' ') ;
 
insert into dbo.pbcatcol
       (pbc_tnam, pbc_tid, pbc_ownr, pbc_cnam,
       pbc_cid, pbc_labl, pbc_lpos, pbc_hdr,
       pbc_hpos, pbc_jtfy, pbc_mask, pbc_case,
       pbc_hght, pbc_wdth, pbc_ptrn, pbc_bmap,
       pbc_init, pbc_cmnt, pbc_edit, pbc_tag)
        values  ( 'labmis_wdgl',
        object_id('dbo.labmis_wdgl'),
        'dbo',  'wdbh', 1,
        'Wdbh:', 0 ,
        'Wdbh', 0,
       23 , '',
       0 , 77 , 161 ,
        '', 'N',
        '',
        ' ',
        '', '') ;
 
insert into dbo.pbcatcol
       (pbc_tnam, pbc_tid, pbc_ownr, pbc_cnam,
       pbc_cid, pbc_labl, pbc_lpos, pbc_hdr,
       pbc_hpos, pbc_jtfy, pbc_mask, pbc_case,
       pbc_hght, pbc_wdth, pbc_ptrn, pbc_bmap,
       pbc_init, pbc_cmnt, pbc_edit, pbc_tag)
        values  ( 'labmis_wdgl',
        object_id('dbo.labmis_wdgl'),
        'dbo',  'wdmc', 2,
        'Wdmc:', 0 ,
        'Wdmc', 0,
       23 , '',
       0 , 77 , 1441 ,
        '', 'N',
        '',
        ' ',
        '', '') ;
 
insert into dbo.pbcatcol
       (pbc_tnam, pbc_tid, pbc_ownr, pbc_cnam,
       pbc_cid, pbc_labl, pbc_lpos, pbc_hdr,
       pbc_hpos, pbc_jtfy, pbc_mask, pbc_case,
       pbc_hght, pbc_wdth, pbc_ptrn, pbc_bmap,
       pbc_init, pbc_cmnt, pbc_edit, pbc_tag)
        values  ( 'labmis_wdgl',
        object_id('dbo.labmis_wdgl'),
        'dbo',  'wdnr', 3,
        'Wdnr:', 0 ,
        'Wdnr', 0,
       23 , '',
       0 , 77 , 5893 ,
        '', 'N',
        '',
        ' ',
        '', '') ;
 
insert into dbo.pbcatcol
       (pbc_tnam, pbc_tid, pbc_ownr, pbc_cnam,
       pbc_cid, pbc_labl, pbc_lpos, pbc_hdr,
       pbc_hpos, pbc_jtfy, pbc_mask, pbc_case,
       pbc_hght, pbc_wdth, pbc_ptrn, pbc_bmap,
       pbc_init, pbc_cmnt, pbc_edit, pbc_tag)
        values  ( 'labmis_wdgl',
        object_id('dbo.labmis_wdgl'),
        'dbo',  'jdr', 4,
        'Jdr:', 0 ,
        'Jdr', 0,
       23 , '',
       0 , 77 , 293 ,
        '', 'N',
        '',
        ' ',
        '', '') ;
 
insert into dbo.pbcatcol
       (pbc_tnam, pbc_tid, pbc_ownr, pbc_cnam,
       pbc_cid, pbc_labl, pbc_lpos, pbc_hdr,
       pbc_hpos, pbc_jtfy, pbc_mask, pbc_case,
       pbc_hght, pbc_wdth, pbc_ptrn, pbc_bmap,
       pbc_init, pbc_cmnt, pbc_edit, pbc_tag)
        values  ( 'labmis_wdgl',
        object_id('dbo.labmis_wdgl'),
        'dbo',  'wdmj', 5,
        'Wdmj:', 0 ,
        'Wdmj', 0,
       23 , '',
       0 , 77 , 110 ,
        '', 'N',
        '',
        ' ',
        '', '') ;
 
insert into dbo.pbcatcol
       (pbc_tnam, pbc_tid, pbc_ownr, pbc_cnam,
       pbc_cid, pbc_labl, pbc_lpos, pbc_hdr,
       pbc_hpos, pbc_jtfy, pbc_mask, pbc_case,
       pbc_hght, pbc_wdth, pbc_ptrn, pbc_bmap,
       pbc_init, pbc_cmnt, pbc_edit, pbc_tag)
        values  ( 'labmis_wdgl',
        object_id('dbo.labmis_wdgl'),
        'dbo',  'gjc', 6,
        'Gjc:', 0 ,
        'Gjc', 0,
       23 , '',
       0 , 77 , 5893 ,
        '', 'N',
        '',
        ' ',
        '', '') ;
 
insert into dbo.pbcatcol
       (pbc_tnam, pbc_tid, pbc_ownr, pbc_cnam,
       pbc_cid, pbc_labl, pbc_lpos, pbc_hdr,
       pbc_hpos, pbc_jtfy, pbc_mask, pbc_case,
       pbc_hght, pbc_wdth, pbc_ptrn, pbc_bmap,
       pbc_init, pbc_cmnt, pbc_edit, pbc_tag)
        values  ( 'labmis_wdgl',
        object_id('dbo.labmis_wdgl'),
        'dbo',  'jdsj', 7,
        'Jdsj:', 0 ,
        'Jdsj', 0,
       23 , '',
       0 , 77 , 481 ,
        '', 'N',
        '',
        ' ',
        '', '') ;