Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE [DATAREADER]
- GO
- /****** Object: Table [dbo].[OPCUAItem] Script Date: 23/7/2019 5:13:53 PM ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[OPCUAItem](
- [ID] [int] IDENTITY(1,1) NOT NULL,
- [OPCUAID] [int] NOT NULL,
- [OPCUAItemName] [nvarchar](max) NOT NULL,
- [NodeID] [nvarchar](max) NOT NULL,
- [Value] [nvarchar](max) NULL,
- [MathOperator] [nchar](1) NULL,
- [ConvertorVal] [decimal](18, 0) NULL,
- [IS_DELETED] [bit] NOT NULL,
- [CreatedDate] [datetime] NULL,
- [ModifiedDate] [datetime] NULL,
- [StringToAppend] [nvarchar](max) NULL,
- [AppendPosition] [nvarchar](max) NULL,
- CONSTRAINT [PK_OPCUAItem] PRIMARY KEY CLUSTERED
- (
- [ID] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
- GO
- ALTER TABLE [dbo].[OPCUAItem] WITH CHECK ADD CONSTRAINT [FK_OPCUAItem_OPCUAController] FOREIGN KEY([OPCUAID])
- REFERENCES [dbo].[OPCUAController] ([ID])
- GO
- ALTER TABLE [dbo].[OPCUAItem] CHECK CONSTRAINT [FK_OPCUAItem_OPCUAController]
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement