﻿-- Table: dynamic_attribute
CREATE TABLE [dynamic_attribute] (
    [gobject_id] int NOT NULL,
    [package_id] int NOT NULL,
    [mx_primitive_id] smallint NOT NULL,
    [mx_attribute_id] smallint NOT NULL,
    [attribute_name] nvarchar(329) NOT NULL,
    [mx_data_type] smallint NOT NULL,
    [is_array] bit NOT NULL,
    [security_classification] smallint NOT NULL,
    [mx_attribute_category] int NOT NULL,
    [lock_type] int NOT NULL,
    [mx_value] text(2147483647) NOT NULL,
    [owned_by_gobject_id] int NOT NULL DEFAULT ((0)),
    [original_lock_type] int NOT NULL DEFAULT ((0)),
    [dynamic_attribute_type] smallint NOT NULL DEFAULT ((0)),
    [bitvalues] smallint NOT NULL DEFAULT ((0)),
    [dynamic_attribute_id] bigint NOT NULL,
    CONSTRAINT [PK_dynamic_attribute] PRIMARY KEY ([gobject_id], [package_id], [mx_primitive_id], [mx_attribute_id], [gobject_id], [mx_primitive_id], [package_id], [gobject_id], [mx_primitive_id], [package_id], [gobject_id], [mx_primitive_id], [package_id])
);
GO

ALTER TABLE [dynamic_attribute] ADD FOREIGN KEY ([package_id]) REFERENCES [primitive_instance] ([package_id]);
GO

