ESF.rar_二手房 管理 信息系统

use master go if exists (select * from dbo.sysdatabases where name = 'DBHouse') drop database DBHouse GO create database DBHouse go use DBManPower go if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbUser]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tbUser] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbRegion]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tbRegion] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbItem]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tbItem] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbStru]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tbStru] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbSaleMan]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tbSaleMan] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbHouse]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tbHouse] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbHousePre]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tbHousePre] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbContractp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tbContractp] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbHouseSale]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tbHouseSale] GO CREATE TABLE [dbo].[tbUser] ( UserId char(10) NOT NULL , UserPassword char(8) NOT NULL , UserKind varchar(20) NOT NULL, PRIMARY KEY (UserId) ) GO CREATE TABLE [dbo].[tbRegion] ( RegId char(5) NOT NULL , RegName varchar(30) NOT NULL , PRIMARY KEY (RegId) ) GO CREATE TABLE [dbo].[tbItem] ( ItemId char(5) NOT NULL, ItemName varchar(30) NOT NULL, PRIMARY KEY (ItemId) ) GO CREATE TABLE [dbo].[tbStru] ( StruId char(5) NOT NULL , StruName varchar(30) NOT NULL , PRIMARY KEY (StruId) ) GO CREATE TABLE [dbo].[tbSaleMan] ( SaleManId char(8) NOT NULL , SaleManName varchar(30) NOT NULL , Gender varchar(2) NULL , Position varchar(10) NULL , Tel varchar(15) NULL , RegId varchar(5) NULL , PRIMARY KEY (SaleManId) ) GO CREATE TABLE [dbo].[tbHouse] ( HouseId char(8) NOT NULL , HouseName varchar(30) NOT NULL , RegId char(5) NULL , ItemId char(5) NULL , ItemYear char(4) NULL , ItemCop varchar(30) NULL , StruId char(5) NULL , Area decimal NULL , Floor varchar(2) NULL , AllFloor varchar(2) NULL , Unit varchar(2) NULL , CarArea decimal NULL , School varchar(30) NULL , Bus varchar(30) NULL , Street varchar(30) NULL , Chamber varchar(30) NULL , DoorNumber char(1) NULL , Squer varchar(30) NULL , Est varchar(30) NULL , Fitment varchar(6) NULL , ServiceFee money NULL , Belong varchar(8) NULL , Price money NULL , State varchar(8) NULL , PRIMARY KEY (HouseId) ) GO CREATE TABLE [dbo].[tbHousePre] ( HouseId char(8) NOT NULL , HouseName varchar(30) NOT NULL, ViewTime char(8) NOT NULL , ViewYMD char(10) NULL , ClientNum varchar(30) NULL, ClientIDCard char(18) NULL , PRIMARY KEY (HouseId,ViewTime) ) GO CREATE TABLE [dbo].[tbContractp] ( HouseId char(8) NOT NULL , HouseName varchar(30) NOT NULL, SignDate char(10) NOT NULL , SaleMoney money NULL , TaxDes varchar(30) NULL, Tax money NULL , MediMoney money NULL , PreMoney money NULL , Area decimal NULL , Belong varchar(8) NULL, YContact varchar(50) NULL, YTel varchar(20) NULL, YIDCard varchar(20) NULL, JContact varchar(20) NULL, JTel varchar(20) NULL, JIDCard varchar(20) NULL, YTimeLimit datetime NULL, JTimeLimit datetime NULL, Present varchar(50) NULL, Jdelegate varchar(30) NULL, Ydelegate varchar(30) NULL, BManName varchar(30) NULL, PRIMARY KEY (HouseId,SignDate) ) GO CREATE TABLE [dbo].[tbHouseSale] ( HouseId char(8) NOT NULL , HouseName varchar(30) NOT NULL , RegId char(5) NULL , ItemId char(5) NULL , ItemYear char(4) NULL , ItemCop varchar(30) NULL , StruId char(5) NULL , Area decimal NULL , Floor varchar(2) NULL , AllFloor varchar(2) NULL , Unit varchar(2) NULL , CarArea decimal NULL , School varchar(30) NULL , Bus varchar(30) NULL , Street varchar(30) NULL , Chamber varchar(30) NULL , DoorNumber char(1) NULL , Squer varchar(30) NULL , Est varchar(30) NULL , Fitment varchar(6) NULL , ServiceFee money NULL , Belong varchar(8) NULL , Price money NULL , SaleDate char(10) NULL , PRIMARY KEY (HouseId) ) GO