﻿-- Table: template_attribute
CREATE TABLE [template_attribute] (
    [gobject_id] int NOT NULL,
    [package_id] int NOT NULL,
    [mx_primitive_id] smallint NOT NULL,
    [mx_attribute_id] smallint NOT NULL,
    [security_classification] int NOT NULL,
    [mx_data_type] smallint NOT NULL,
    [mx_value] text(2147483647) NOT NULL,
    [lock_type] int NOT NULL,
    [original_lock_type] int NOT NULL DEFAULT ((0)),
    [bit_values] smallint NOT NULL DEFAULT ((0)),
    [raw_value] nvarchar(1024) NULL DEFAULT (NULL),
    CONSTRAINT [PK_template_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 [template_attribute] ADD FOREIGN KEY ([package_id]) REFERENCES [primitive_instance] ([package_id]);
GO

