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


-- ----------------------------
-- Table structure for Person
-- ----------------------------
DROP TABLE [dbo].[Person]
GO
CREATE TABLE [dbo].[Person] (
[ID] uniqueidentifier NOT NULL ,
[Name] nvarchar(50) NOT NULL ,
[Address] nvarchar(100) NULL ,
[Telphone] nvarchar(30) NULL ,
[IsValid] tinyint NULL ,
[RegDate] datetime NULL ,
[Remark] nvarchar(50) NULL 
)


GO

-- ----------------------------
-- Records of Person
-- ----------------------------
INSERT INTO [dbo].[Person] ([ID], [Name], [Address], [Telphone], [IsValid], [RegDate], [Remark]) VALUES (N'3E1EEC51-959E-4BFE-954E-2F9B327E7BA8', N'李四', N'深圳南山', N'13800138001', N'1', N'2016-03-21 17:42:04.353', null)
GO
GO
INSERT INTO [dbo].[Person] ([ID], [Name], [Address], [Telphone], [IsValid], [RegDate], [Remark]) VALUES (N'BBF023E6-9975-4071-92F9-A55B1C254E15', N'小陈', N'深圳南山', N'13800138001', N'1', N'2016-03-25 09:24:29.587', null)
GO
GO

-- ----------------------------
-- Indexes structure for table Person
-- ----------------------------

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