ALARM/豪恩LHB9000管理软件/Navicat sql/UserDevice.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:34:30
*/


-- ----------------------------
-- Table structure for UserDevice
-- ----------------------------
DROP TABLE [dbo].[UserDevice]
GO
CREATE TABLE [dbo].[UserDevice] (
[ID] int NOT NULL IDENTITY(1,1) ,
[UserID] nvarchar(50) NULL ,
[DevID] nvarchar(50) NULL ,
[Remark] nvarchar(200) NULL ,
[ModifyDt] datetime NULL DEFAULT (getdate()) 
)


GO

-- ----------------------------
-- Records of UserDevice
-- ----------------------------
SET IDENTITY_INSERT [dbo].[UserDevice] ON
GO
SET IDENTITY_INSERT [dbo].[UserDevice] OFF
GO

-- ----------------------------
-- Indexes structure for table UserDevice
-- ----------------------------

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