/*
 Navicat Premium Data Transfer

 Source Server         : DESKTOP-SCT31AM
 Source Server Type    : SQL Server
 Source Server Version : 13001601
 Source Catalog        : WIDESEA_DB
 Source Schema         : dbo

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

 Date: 25/01/2024 11:03:06
*/


-- ----------------------------
-- Table structure for dt_geometry_data
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[dt_geometry_data]') AND type IN ('U'))
	DROP TABLE [dbo].[dt_geometry_data]
GO

CREATE TABLE [dbo].[dt_geometry_data] (
  [TypeId] int  IDENTITY(1,1) NOT NULL,
  [Description] nvarchar(100) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [a] float(53)  NOT NULL,
  [b] float(53)  NOT NULL,
  [c] float(53)  NOT NULL,
  [d] float(53)  NOT NULL,
  [e] float(53)  NOT NULL,
  [f] float(53)  NOT NULL,
  [g] float(53)  NOT NULL,
  [h] float(53)  NOT NULL
)
GO

ALTER TABLE [dbo].[dt_geometry_data] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of dt_geometry_data
-- ----------------------------
SET IDENTITY_INSERT [dbo].[dt_geometry_data] ON
GO

INSERT INTO [dbo].[dt_geometry_data] ([TypeId], [Description], [a], [b], [c], [d], [e], [f], [g], [h]) VALUES (N'1', N'TSW-003D (915KKD)', N'69', N'12', N'126', N'-28', N'972', N'185', N'27', N'70')
GO

INSERT INTO [dbo].[dt_geometry_data] ([TypeId], [Description], [a], [b], [c], [d], [e], [f], [g], [h]) VALUES (N'2', N'TSW-051 (840HESA)', N'70', N'12', N'128', N'-30', N'900', N'197', N'27', N'70')
GO

INSERT INTO [dbo].[dt_geometry_data] ([TypeId], [Description], [a], [b], [c], [d], [e], [f], [g], [h]) VALUES (N'3', N'TSW-005 (840HDSA)', N'70', N'12', N'128', N'-30', N'898', N'185', N'27', N'70')
GO

SET IDENTITY_INSERT [dbo].[dt_geometry_data] OFF
GO


-- ----------------------------
-- Auto increment value for dt_geometry_data
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[dt_geometry_data]', RESEED, 3)
GO


-- ----------------------------
-- Primary Key structure for table dt_geometry_data
-- ----------------------------
ALTER TABLE [dbo].[dt_geometry_data] ADD CONSTRAINT [PK__dt_geome__516F03B53F710A80] PRIMARY KEY CLUSTERED ([TypeId])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO