求字典表!
请问一下,哪位师兄、师姐有医院管理系统中关于医嘱方面的字典表,要实用的,谢谢啦! 问题点数:100、回复次数:4Top
1 楼myclife(反方向的钟)回复于 2002-05-25 11:24:26 得分 100
我懒得找,我可以将一部分SQL文件给你。Top
2 楼myclife(反方向的钟)回复于 2002-05-25 11:32:10 得分 0
贴出来,省得要我发邮件:
/* ==================================================== */
/*易普医院信息系统 EAP-HIS V60 */
/* Microsoft SQL Server - Scripting */
/* Server: ChinaEAPSVR */
/* Database: THISDB */
/* Creation Date 99-11-15 16:46:53 */
/* YZ.SQL */
/* ==================================================== */
/****** Object: Table YZ_YZB Script Date: 99-11-15 16:57:03 ******/
if exists (select * from sysobjects where id = object_id('YZ_YZB') and sysstat & 0xf = 3)
drop table YZ_YZB
GO
/****** Object: Table YZ_YZBH Script Date: 99-11-15 16:57:03 ******/
if exists (select * from sysobjects where id = object_id('YZ_YZBH') and sysstat & 0xf = 3)
drop table YZ_YZBH
GO
/****** Object: Table YZ_YZXB Script Date: 99-11-15 16:57:03 ******/
if exists (select * from sysobjects where id = object_id('YZ_YZXB') and sysstat & 0xf = 3)
drop table YZ_YZXB
GO
/****** Object: Table YZ_YZXBH Script Date: 99-11-15 16:57:03 ******/
if exists (select * from sysobjects where id = object_id('YZ_YZXBH') and sysstat & 0xf = 3)
drop table YZ_YZXBH
GO
/****** Object: Table YZ_BABY Script Date: 99-11-15 16:57:03 ******/
if exists (select * from sysobjects where id = object_id('YZ_BABY') and sysstat & 0xf = 3)
drop table YZ_BABY
GO
/****** Object: Table YZ_BABYH Script Date: 99-11-15 16:57:03 ******/
if exists (select * from sysobjects where id = object_id('YZ_BABYH') and sysstat & 0xf = 3)
drop table YZ_BABYH
GO
Top
3 楼myclife(反方向的钟)回复于 2002-05-25 11:34:11 得分 0
/****** Object: Table YZ_BQYZ Script Date: 99-11-15 16:57:03 ******/
if exists (select * from sysobjects where id = object_id('YZ_BQYZ') and sysstat & 0xf = 3)
drop table YZ_BQYZ
GO
/****** Object: Table YZ_CHWB Script Date: 99-11-15 16:57:03 ******/
if exists (select * from sysobjects where id = object_id('YZ_CHWB') and sysstat & 0xf = 3)
drop table YZ_CHWB
GO
/****** Object: Table YZ_CHWXZ Script Date: 99-11-15 16:57:03 ******/
if exists (select * from sysobjects where id = object_id('YZ_CHWXZ') and sysstat & 0xf = 3)
drop table YZ_CHWXZ
GO
/****** Object: Table YZ_CHGUI Script Date: 99-11-15 16:57:03 ******/
if exists (select * from sysobjects where id = object_id('YZ_CHGUI') and sysstat & 0xf = 3)
drop table YZ_CHGUI
GO
/****** Object: view YZ_DICT Script Date: 99-11-15 16:57:03 ******/
if exists (select * from sysobjects where id = object_id('YZ_DICT') and type = 'V')
drop view YZ_DICT
GO
/****** Object: VIEW YZ_DICTVW0 Script Date: 99-11-15 16:57:03 ******/
if exists (select * from sysobjects where id = object_id('YZ_DICTVW0') and type = 'V')
drop view YZ_DICTVW0
GO
/****** Object: VIEW YZ_DICTVW1 Script Date: 99-11-15 16:57:03 ******/
if exists (select * from sysobjects where id = object_id('YZ_DICTVW1') and type = 'V')
drop view YZ_DICTVW1
GO
/****** Object: Table YZ_SYSINFO Script Date: 99-11-15 16:57:03 ******/
if exists (select * from sysobjects where id = object_id('YZ_SYSINFO') and sysstat & 0xf = 3)
drop table YZ_SYSINFO
GO
/****** Object: Table YZ_ZXFS Script Date: 99-11-15 16:57:03 ******/
if exists (select * from sysobjects where id = object_id('YZ_ZXFS') and sysstat & 0xf = 3)
drop table YZ_ZXFS
GO
/****** Object: Table YZ_ZXPL Script Date: 99-11-15 16:57:03 ******/
if exists (select * from sysobjects where id = object_id('YZ_ZXPL') and sysstat & 0xf = 3)
drop table YZ_ZXPL
GO
Top
4 楼springer(酷儿)回复于 2002-05-25 11:37:53 得分 0
你帮个忙,找找吧:我还是比较想要其中的内容的^_^。
先谢谢啦!!!Top




