﻿-- Table: autobind_device_topic
CREATE TABLE [autobind_device_topic] (
    [dio_id] int NOT NULL,
    [sg_mx_primitive_id] smallint NOT NULL DEFAULT ((0)),
    [overridden_naming_rule_id] int NULL,
    [default_xlate_rule_id] int NOT NULL DEFAULT ((0)),
    CONSTRAINT [PK_autobind_device_topic] PRIMARY KEY ([dio_id], [sg_mx_primitive_id], [overridden_naming_rule_id], [dio_id])
);
GO

ALTER TABLE [autobind_device_topic] ADD FOREIGN KEY ([dio_id]) REFERENCES [autobind_device] ([dio_id]);
GO

