﻿-- Table: attribute_definition
CREATE TABLE [attribute_definition] (
    [attribute_definition_id] int NOT NULL,
    [primitive_definition_id] int NOT NULL,
    [attribute_name] nvarchar(329) NOT NULL,
    [mx_attribute_id] smallint NOT NULL,
    [has_config_set_handler] bit NOT NULL,
    [mx_data_type] smallint NOT NULL,
    [is_array] bit NOT NULL,
    [security_classification] smallint NOT NULL,
    [security_classification_needs_deployed] bit NOT NULL,
    [mx_attribute_category] int NOT NULL,
    [is_frequently_accessed] bit NOT NULL,
    [is_locked] bit NOT NULL,
    [is_locked_needs_deployed] bit NOT NULL,
    [mx_value] text(2147483647) NOT NULL,
    [mx_value_needs_deployed] bit NOT NULL,
    CONSTRAINT [PK_attribute_definition] PRIMARY KEY ([primitive_definition_id], [mx_attribute_id], [primitive_definition_id])
);
GO

ALTER TABLE [attribute_definition] ADD FOREIGN KEY ([primitive_definition_id]) REFERENCES [primitive_definition] ([primitive_definition_id]);
GO

