/*==============================================================*/
/* 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
/*==============================================================*/
/* Table : YF05 */
/*==============================================================*/
create table dbo.YF05 (
记录号 smallint null,
编号 nvarchar(8) null,
姓名 nvarchar(10) null,
医药费 money null,
类别 nvarchar(2) null,
医生 nvarchar(2) null,
自负金 money null,
日期 smalldatetime null
)
go
/*==============================================================*/
/* T