?? f_mis.sql
字號:
/*==============================================================*/
/* 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 */
/*==============================================================*/
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -