📄 house_mis.sql
字号:
/*==============================================================*/
/* Database name: housedb */
/* DBMS name: Microsoft SQL Server 2000 */
/* Created on: 2003-7-29 10:34:03 */
/*==============================================================*/
IF EXISTS (SELECT *
FROM sysdatabases
WHERE name = 'housedb')
DROP DATABASE housedb
GO
CREATE DATABASE housedb
GO
use housedb
go
if exists (select 1
from sysobjects
where id = object_id('qryDCFTZMJ')
and type = 'U')
drop table qryDCFTZMJ
go
if exists (select 1
from sysobjects
where id = object_id('qryFBYT')
and type = 'U')
drop table qryFBYT
go
if exists (select 1
from sysobjects
where id = object_id('qryFT')
and type = 'U')
drop table qryFT
go
if exists (select 1
from sysobjects
where id = object_id('qryGL')
and type = 'U')
drop table qryGL
go
if exists (select 1
from sysobjects
where id = object_id('qryHSDCFT')
and type = 'U')
drop table qryHSDCFT
go
if exists (select 1
from sysobjects
where id = object_id('qryHSQTFT')
and type = 'U')
drop table qryHSQTFT
go
if exists (select 1
from sysobjects
where id = object_id('qryHSYCFT')
and type = 'U')
drop table qryHSYCFT
go
if exists (select 1
from sysobjects
where id = object_id('qryYCFTZMJ')
and type = 'U')
drop table qryYCFTZMJ
go
if exists (select 1
from sysobjects
where id = object_id('qryYT')
and type = 'U')
drop table qryYT
go
if exists (select 1
from sysobjects
where id = object_id('rptFT')
and type = 'U')
drop table rptFT
go
if exists (select 1
from sysobjects
where id = object_id('rptLayer')
and type = 'U')
drop table rptLayer
go
if exists (select 1
from sysobjects
where id = object_id('rptTX')
and type = 'U')
drop table rptTX
go
if exists (select 1
from sysobjects
where id = object_id('tbArea')
and type = 'U')
drop table tbArea
go
if exists (select 1
from sysobjects
where id = object_id('tbFTarea')
and type = 'U')
drop table tbFTarea
go
if exists (select 1
from sysobjects
where id = object_id('tbFeature')
and type = 'U')
drop table tbFeature
go
if exists (select 1
from sysobjects
where id = object_id('tbFir')
and type = 'U')
drop table tbFir
go
if exists (select 1
from sysobjects
where id = object_id('tbHS')
and type = 'U')
drop table tbHS
go
if exists (select 1
from sysobjects
where id = object_id('tbTable')
and type = 'U')
drop table tbTable
go
/*==============================================================*/
/* Table : qryDCFTZMJ */
/*==============================================================*/
create table qryDCFTZMJ (
tbName nvarchar(10) null,
FtKey nvarchar(10) null,
DCZMJ float null
)
go
/*==============================================================*/
/* Table : qryFBYT */
/*==============================================================*/
create table qryFBYT (
tbName nvarchar(10) null,
FtKey nvarchar(10) null,
YTArea float null
)
go
/*==============================================================*/
/* Table : qryFT */
/*==============================================================*/
create table qryFT (
F_tbName nvarchar(10) null,
F_FtKey nvarchar(10) null,
F_Farea float null,
F_Ftype smallint null,
F_JC int null,
F_CS int null,
H_tbName nvarchar(10) null,
H_FtKey nvarchar(10) null,
H_JC int null,
H_CS int null,
H_JCHH nvarchar(8) null,
H_Farea float null,
FTTYPE smallint null
)
go
/*==============================================================*/
/* Table : qryGL */
/*==============================================================*/
create table qryGL (
tbName nvarchar(10) null,
FtKey nvarchar(10) null,
GLArea float null
)
go
/*==============================================================*/
/* Table : qryHSDCFT */
/*==============================================================*/
create table qryHSDCFT (
tbName nvarchar(10) null,
FtKey nvarchar(10) null,
DCFTXS float null,
DCFTMJ float null
)
go
/*==============================================================*/
/* Table : qryHSQTFT */
/*==============================================================*/
create table qryHSQTFT (
tbName nvarchar(10) null,
FtKey nvarchar(10) null,
QTFTXS float null,
QTFTMJ float null
)
go
/*==============================================================*/
/* Table : qryHSYCFT */
/*==============================================================*/
create table qryHSYCFT (
tbName nvarchar(10) null,
FtKey nvarchar(10) null,
YCFTXS float null,
YCFTMJ float null
)
go
/*==============================================================*/
/* Table : qryYCFTZMJ */
/*==============================================================*/
create table qryYCFTZMJ (
tbName nvarchar(10) null,
FtKey nvarchar(10) null,
YCZMJ float null
)
go
/*==============================================================*/
/* Table : qryYT */
/*==============================================================*/
create table qryYT (
tbName nvarchar(10) null,
FtKey nvarchar(10) null,
YTArea float null
)
go
/*==============================================================*/
/* Table : rptFT */
/*==============================================================*/
create table rptFT (
FK nvarchar(255) null,
CH nvarchar(20) null,
Jhmj float null,
Zmj float null,
HSzmj float null,
Ftxs float null,
Cydy nvarchar(20) null,
Ftlx nvarchar(20) null
)
go
/*==============================================================*/
/* Table : rptLayer */
/*==============================================================*/
create table rptLayer (
CH nvarchar(50) null,
ZHS float null,
ZYT float null,
ZHarea float null,
ZYcftmj float null,
ZDcftmj float null,
ZGlmj float null,
ZJzmj float null
)
go
/*==============================================================*/
/* Table : rptTX */
/*==============================================================*/
create table rptTX (
FK nvarchar(255) null,
CH nvarchar(50) null,
HS float null,
YT float null,
Harea float null,
YCftmj float null,
Dcftmj float null,
Glmj float null,
Jzmj float null
)
go
/*==============================================================*/
/* Table : tbArea */
/*==============================================================*/
create table tbArea (
TbName nvarchar(10) null,
FtKey nvarchar(10) null,
CH nvarchar(50) null,
YT float null,
Harea float null,
Qtxs float null,
Qtmj float null,
ycftxs float null,
vYcftmj float null,
Dcftxs float null,
Dcftmj float null,
Glmj float null,
jzmj float null
)
go
/*==============================================================*/
/* Table : tbFTarea */
/*==============================================================*/
create table tbFTarea (
FtKey nvarchar(10) null,
CH nvarchar(20) null,
Jhmj float null,
Zmj float null,
HSzmj float null,
Ftxs float null,
Cydy nvarchar(50) null,
Ftlx nvarchar(50) null
)
go
/*==============================================================*/
/* Table : tbFeature */
/*==============================================================*/
create table tbFeature (
tbName nvarchar(10) null,
Ftkey nvarchar(10) null,
jc int null,
cs int null,
jchh nvarchar(8) null,
Farea float null,
Ftype smallint null,
Harea float null,
Jarea float null,
Linfo nvarchar(50) null,
Memo1 nvarchar(100) null,
Memo2 nvarchar(100) null,
Memo3 nvarchar(100) null,
Memo ntext null
)
go
/*==============================================================*/
/* Table : tbFir */
/*==============================================================*/
create table tbFir (
F_tbName nvarchar(10) null,
F_FtKey nvarchar(10) null,
H_TbName nvarchar(10) null,
H_FtKey nvarchar(10) null,
FTType smallint null
)
go
/*==============================================================*/
/* Table : tbHS */
/*==============================================================*/
create table tbHS (
tbName nvarchar(10) null,
Ftkey nvarchar(10) null,
jc int null,
cs int null,
jchh nvarchar(8) null,
Farea float null,
Ftype smallint null,
Harea float null,
Jarea float null,
Linfo nvarchar(50) null,
Memo1 nvarchar(100) null,
Memo2 nvarchar(100) null,
Memo3 nvarchar(100) null,
Memo ntext null
)
go
/*==============================================================*/
/* Table : tbTable */
/*==============================================================*/
create table tbTable (
LyrName nvarchar(10) null,
zl nvarchar(100) null,
width float null,
height float null,
Bgh nvarchar(50) null,
Rq smalldatetime null,
Bjcdw nvarchar(50) null,
Cly nvarchar(50) null,
Hyy nvarchar(50) null,
Jzmc nvarchar(50) null,
Cs float null,
Zjzmj float null,
Zgymj float null,
Ztljzmj float null,
Zglmj float null,
Zftxs float null,
Column_17 float null,
Memo nvarchar(50) null,
A_DAT image null,
A_ID image null,
A_IND image null,
A_MAP image null,
A_TAB image null,
L_DAT image null,
L_ID image null,
L_MAP image null,
L_TAB image null,
AL_FZ nvarchar(50) null
)
go
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -