CREATE TABLE [dbo].[Device_Alarm_Log](
	[LogId] [bigint] IDENTITY(1,1) NOT NULL,
	[DeviceName] [varchar](100) NOT NULL,
	[Location] [varchar](100) NOT NULL,
	[Value] [decimal](18, 4) NOT NULL,
	[AlarmType] [varchar](20) NOT NULL,
	[LoggedAt] [datetime] NOT NULL,

);

CREATE TABLE [dbo].[Device_Config](
	[ConfigId] [int] IDENTITY(1,1) NOT NULL,
	[DeviceName] [varchar](50) NOT NULL,
	[Location] [varchar](50) NOT NULL,
	[IPAddress] [varchar](50) NOT NULL,
	[Port] [int] NOT NULL,
	[SlaveId] [tinyint] NOT NULL,
	[RegisterAddress] [int] NOT NULL,
	[RegisterType] [varchar](20) NULL,
	[DataType] [varchar](50) NULL,
	[ScaleFactor] [decimal](10, 4) NULL,
	[ParameterName] [varchar](50) NULL,
	[Unit] [varchar](20) NULL,
	[RangeMin] [decimal](10, 4) NULL,
	[RangeMax] [decimal](10, 4) NULL,
	[LowAlarm] [decimal](10, 4) NULL,
	[HighAlarm] [decimal](10, 4) NULL,
	[IsActive] [bit] NOT NULL,
	[CreatedAt] [datetime] NOT NULL,

);

CREATE TABLE [dbo].[SCADA_Device_Config](
	[ConfigId] [int] IDENTITY(1,1) NOT NULL,
	[DeviceName] [varchar](50) NOT NULL,
	[Location] [varchar](50) NOT NULL,
	[IPAddress] [varchar](50) NOT NULL,
	[Port] [int] NOT NULL,
	[SlaveId] [tinyint] NOT NULL,
	[RegisterAddress] [int] NOT NULL,
	[RegisterType] [varchar](20) NOT NULL,
	[DataType] [varchar](50) NOT NULL,
	[ScaleFactor] [decimal](10, 4) NOT NULL,
	[ParameterName] [varchar](50) NOT NULL,
	[Unit] [varchar](20) NOT NULL,
	[RangeMin] [decimal](10, 4) NOT NULL,
	[RangeMax] [decimal](10, 4) NOT NULL,
	[IsActive] [bit] NOT NULL,
	[CreatedAt] [datetime] NOT NULL,

);

CREATE TABLE [dbo].[SCADA_Device_Log](
	[LogId] [bigint] IDENTITY(1,1) NOT NULL,
	[DeviceName] [varchar](100) NOT NULL,
	[Location] [varchar](100) NOT NULL,
	[Value] [decimal](18, 4) NOT NULL,
	[LoggedAt] [datetime] NOT NULL,
);