crebas.txt

医务收费系统,主要的功能不用我说大家都知道的

/*==============================================================*/
/* Database name:  PhysicalDataModel_1                          */
/* DBMS name:      Microsoft SQL Server 2000                    */
/* Created on:     2003-7-5 15:16:32                            */
/*==============================================================*/


if exists (select 1
            from  sysobjects
           where  id = object_id('dbo.RMK')
            and   type = 'U')
   drop table dbo.RMK
go


if exists (select 1
            from  sysobjects
           where  id = object_id('dbo.YF01')
            and   type = 'U')
   drop table dbo.YF01
go


if exists (select 1
            from  sysobjects
           where  id = object_id('dbo.YF02')
            and   type = 'U')
   drop table dbo.YF02
go


if exists (select 1
            from  sysobjects
           where  id = object_id('dbo.YF03')
            and   type = 'U')
   drop table dbo.YF03
go


if exists (select 1
            from  sysobjects
           where  id = object_id('dbo.YF04')
            and   type = 'U')
   drop table dbo.YF04
go


if exists (select 1
            from  sysobjects
           where  id = object_id('dbo.YF05')
            and   type = 'U')
   drop table dbo.YF05
go


if exists (select 1
            from  sysobjects
           where  id = object_id('dbo.YF06')
            and   type = 'U')
   drop table dbo.YF06
go


if exists (select 1
            from  sysobjects
           where  id = object_id('dbo.YF07')
            and   type = 'U')
   drop table dbo.YF07
go


if exists (select 1
            from  sysobjects
           where  id = object_id('dbo.YF08')
            and   type = 'U')
   drop table dbo.YF08
go


if exists (select 1
            from  sysobjects
           where  id = object_id('dbo.YF09')
            and   type = 'U')
   drop table dbo.YF09
go


if exists (select 1
            from  sysobjects
           where  id = object_id('dbo.YF10')
            and   type = 'U')
   drop table dbo.YF10
go


if exists (select 1
            from  sysobjects
           where  id = object_id('dbo.YF11')
            and   type = 'U')
   drop table dbo.YF11
go


if exists (select 1
            from  sysobjects
           where  id = object_id('dbo.YF12')
            and   type = 'U')
   drop table dbo.YF12
go


if exists (select 1
            from  sysobjects
           where  id = object_id('dbo.YF_month_rpt')
            and   type = 'U')
   drop table dbo.YF_month_rpt
go


if exists (select 1
            from  sysobjects
           where  id = object_id('dbo.YF_month_temp')
            and   type = 'U')
   drop table dbo.YF_month_temp
go


if exists (select 1
            from  sysobjects
           where  id = object_id('dbo.YF_year_rpt')
            and   type = 'U')
   drop table dbo.YF_year_rpt
go


if exists (select 1
            from  sysobjects
           where  id = object_id('dbo.datareport')
            and   type = 'U')
   drop table dbo.datareport
go


if exists (select 1
            from  sysobjects
           where  id = object_id('dbo.doctor')
            and   type = 'U')
   drop table dbo.doctor
go


if exists (select 1
            from  sysobjects
           where  id = object_id('dbo.feiyong')
            and   type = 'U')
   drop table dbo.feiyong
go


if exists (select 1
            from  sysobjects
           where  id = object_id('dbo.feiyong_rpt')
            and   type = 'U')
   drop table dbo.feiyong_rpt
go


if exists (select 1
            from  sysobjects
           where  id = object_id('dbo.leibie')
            and   type = 'U')
   drop table dbo.leibie
go


if exists (select 1
            from  sysobjects
           where  id = object_id('dbo.month_count')
            and   type = 'U')
   drop table dbo.month_count
go


if exists (select 1
            from  sysobjects
           where  id = object_id('dbo.user_load')
            and   type = 'U')
   drop table dbo.user_load
go


/*==============================================================*/
/* Table : RMK                                                  */
/*==============================================================*/
create table dbo.RMK (
号码                   nvarchar(8)          null,
姓名                   nvarchar(8)          null,
性别                   nvarchar(2)          null,
工龄                   float(15)            null,
补偿金                  float(15)            null,
定额                   float(15)            null
)
go


/*==============================================================*/
/* Table : YF01                                                 */
/*==============================================================*/
create table dbo.YF01 (
记录号                  smallint             null,
编号                   nvarchar(8)          null,
姓名                   nvarchar(10)         null,
医药费                  money                null,
类别                   nvarchar(2)          null,
医生                   nvarchar(2)          null,
自负金                  money                null,
日期                   smalldatetime        null
)
go


/*==============================================================*/
/* Table : YF02                                                 */
/*==============================================================*/
create table dbo.YF02 (
记录号                  smallint             null,
编号                   nvarchar(8)          null,
姓名                   nvarchar(10)         null,
医药费                  money                null,
类别                   nvarchar(2)          null,
医生                   nvarchar(2)          null,
自负金                  money                null,
日期                   smalldatetime        null
)
go


/*==============================================================*/
/* Table : YF03                                                 */
/*==============================================================*/
create table dbo.YF03 (
记录号                  smallint             null,
编号                   nvarchar(8)          null,
姓名                   nvarchar(10)         null,
医药费                  money                null,
类别                   nvarchar(2)          null,
医生                   nvarchar(2)          null,
自负金                  money                null,
日期                   smalldatetime        null
)
go


/*==============================================================*/
/* Table : YF04                                                 */
/*==============================================================*/
create table dbo.YF04 (
记录号                  smallint             null,
编号                   nvarchar(8)          null,
姓名                   nvarchar(10)         null,
医药费                  money                null,
类别                   nvarchar(2)          null,
医生                   nvarchar(2)          null,
自负金                  money                null,
日期                   smalldatetime        null
)
go


/*==============================================================*/