CREATE TABLE [dbo].[profile_expression_step]
(
[profile_expression_step_id] [binary] (16) NOT NULL,
[group_expression_step_id] [binary] (16) NULL,
[inventory_profile_id] [binary] (16) NOT NULL,
[sequence_number] [int] NOT NULL,
[not_indicator] [tinyint] NOT NULL,
[following_boolean_operator] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[expression_step_type_id] [nvarchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[sw_def_uuid] [binary] (16) NULL,
[creation_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[profile_expression_step] ADD CONSTRAINT [XPKprofile_expression_step] PRIMARY KEY CLUSTERED ([profile_expression_step_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[profile_expression_step] ADD CONSTRAINT [$profi_r00001c3d00000000] FOREIGN KEY ([inventory_profile_id]) REFERENCES [dbo].[inventory_profile] ([inventory_profile_id])
GO
ALTER TABLE [dbo].[profile_expression_step] ADD CONSTRAINT [$profi_r00001c4700000000] FOREIGN KEY ([group_expression_step_id]) REFERENCES [dbo].[profile_expression_step] ([profile_expression_step_id])
GO
ALTER TABLE [dbo].[profile_expression_step] ADD CONSTRAINT [$profi_r00001c5100000000] FOREIGN KEY ([sw_def_uuid]) REFERENCES [dbo].[ca_software_def] ([sw_def_uuid])
GO