CREATE TABLE [dbo].[Security_OpenPortInfo] (
    [OpenPortInfoGuid] UNIQUEIDENTIFIER NOT NULL,
    [DeviceGuid]       UNIQUEIDENTIFIER NOT NULL,
    [Port]             INT              NOT NULL,
    [Protocol]         NVARCHAR (300)   NOT NULL,
    [Description]      NVARCHAR (300)   NOT NULL,
    [DateCreated]      DATETIME         NOT NULL,
    [DateModified]     DATETIME         NOT NULL,
    [OMRowVersion]     ROWVERSION       NOT NULL
);
GO
ALTER TABLE [dbo].[Security_OpenPortInfo] WITH NOCHECK
    ADD CONSTRAINT [Security_OpenPortInfo_Device_FK] FOREIGN KEY ([DeviceGuid]) REFERENCES [dbo].[Device] ([DeviceGuid]);
GO
ALTER TABLE [dbo].[Security_OpenPortInfo] WITH CHECK CHECK CONSTRAINT [Security_OpenPortInfo_Device_FK];
GO