CREATE TABLE [dbo].[arg_hierarchy_values]
(
[hierarchy_id] [int] NOT NULL,
[hierarchy_value_id] [int] NOT NULL,
[hierarchy_value] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[parent_id] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[inactive] [int] NOT NULL,
[last_update_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[arg_hierarchy_values] ADD CONSTRAINT [PK__arg_hierarchy_va__4A65773A] PRIMARY KEY CLUSTERED ([hierarchy_value_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [arg_hierarchy_values_idx_01] ON [dbo].[arg_hierarchy_values] ([hierarchy_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [arg_hierarchy_values_idx_02] ON [dbo].[arg_hierarchy_values] ([parent_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[arg_hierarchy_values] ADD CONSTRAINT [HVHDJOIN01] FOREIGN KEY ([hierarchy_id]) REFERENCES [dbo].[arg_hierarchy_def] ([hierarchy_id])
GO
GRANT SELECT ON  [dbo].[arg_hierarchy_values] TO [swcmadmin]
GRANT INSERT ON  [dbo].[arg_hierarchy_values] TO [swcmadmin]
GRANT DELETE ON  [dbo].[arg_hierarchy_values] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[arg_hierarchy_values] TO [swcmadmin]
GO