ALARM/豪恩LHB9000管理软件/Navicat sql/MapDetail.sql

/*
Navicat SQL Server Data Transfer

Source Server         : 9000
Source Server Version : 105000
Source Host           : .\sqlexpress:1433
Source Database       : LHBMS
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 105000
File Encoding         : 65001

Date: 2021-05-11 15:33:24
*/


-- ----------------------------
-- Table structure for MapDetail
-- ----------------------------
DROP TABLE [dbo].[MapDetail]
GO
CREATE TABLE [dbo].[MapDetail] (
[ID] uniqueidentifier NOT NULL DEFAULT (newid()) ,
[MapID] uniqueidentifier NOT NULL ,
[PointName] nvarchar(50) NOT NULL ,
[PointX] nvarchar(50) NULL ,
[pointY] nvarchar(50) NULL ,
[PointType] nvarchar(50) NULL ,
[ZoneType] int NULL ,
[ZoneID] int NULL DEFAULT ((0)) ,
[AreaID] int NULL DEFAULT ((0)) ,
[DeviceID] uniqueidentifier NULL 
)


GO

-- ----------------------------
-- Records of MapDetail
-- ----------------------------

-- ----------------------------
-- Indexes structure for table MapDetail
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table MapDetail
-- ----------------------------
ALTER TABLE [dbo].[MapDetail] ADD PRIMARY KEY ([ID])
GO