Newer
Older
USE [EnviromentalMonitoring]
GO
/****** Object: Table [dbo].[Sensor] Script Date: 19/10/2021 16:22:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Sensor](
[sensorID] [int] IDENTITY(1,1) NOT NULL,
[sensorUID] [nvarchar](50) NOT NULL,
[locationLong] [decimal](11, 8) NOT NULL,
[locationLat] [decimal](11, 8) NOT NULL,
[locationCity] [decimal](11, 8) NOT NULL,
[friendlyName] [nvarchar](50) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Sensor](
[sensorID] [int] IDENTITY(1,1) NOT NULL,
[sensorUID] [nvarchar](50) NOT NULL,
[locationLong] [decimal](11, 8) NOT NULL,
[locationLat] [decimal](11, 8) NOT NULL,
[locationCity] [nvarchar](100) NOT NULL,
[friendlyName] [nvarchar](50) NULL
) ON [PRIMARY]
GO