CREATE TABLE [dbo].[arg_attribute_def]
(
[class_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[attribute_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[attribute_label] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[attribute_alias] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[relation_type] [smallint] NULL,
[table_name] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[field_name] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[attribute_type] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[join_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[class_template] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[extensible] [smallint] NULL,
[control_object] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[control_name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__arg_attri__versi__66EA454A] DEFAULT ('0'),
[customizable] [smallint] NULL,
[related_base_attribute] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[api_property_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[api_object_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[api_updatable] [int] NULL,
[hierarchy] [smallint] NULL,
[app_filter] [smallint] NOT NULL CONSTRAINT [DF__arg_attri__app_f__1611AA8C] DEFAULT ('2'),
[inactive] [smallint] NULL CONSTRAINT [DF__arg_attri__inact__2E5A6E80] DEFAULT ((0)),
[api_searchable] [int] NULL CONSTRAINT [DF__arg_attri__api_s__2F4E92B9] DEFAULT ((1)),
[core] [int] NOT NULL CONSTRAINT [DF__ARG_ATTRIB__CORE__118A8A8C] DEFAULT ('1 '),
[is_selectable] [int] NULL CONSTRAINT [DF__ARG_ATTRI__IS_SE__127EAEC5] DEFAULT ('0'),
[api_internal] [int] NULL CONSTRAINT [DF__ARG_ATTRI__API_I__1372D2FE] DEFAULT ('0'),
[config_id] [int] NULL,
[default_attribute] [int] NOT NULL CONSTRAINT [DF__ARG_ATTRI__DEFAU__1466F737] DEFAULT ('0'),
[sp_eligible] [int] NULL CONSTRAINT [DF__ARG_ATTRI__SP_EL__155B1B70] DEFAULT ('0'),
[service_provider_eligible] [int] NULL CONSTRAINT [DF__arg_attri__servi__35076C0F] DEFAULT ('0'),
[attribute_name_override] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[arg_attribute_def] ADD CONSTRAINT [XPKarg_attribute_def] PRIMARY KEY CLUSTERED ([class_name], [attribute_name]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [sysadindex04] ON [dbo].[arg_attribute_def] ([class_template]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [sysadindex05] ON [dbo].[arg_attribute_def] ([control_object], [control_name]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [sysadindex03] ON [dbo].[arg_attribute_def] ([join_name]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [sysadindex02] ON [dbo].[arg_attribute_def] ([table_name], [field_name]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[arg_attribute_def] ADD CONSTRAINT [arg_attribute_def_fk01] FOREIGN KEY ([config_id]) REFERENCES [dbo].[al_configuration_def] ([id])
GO
ALTER TABLE [dbo].[arg_attribute_def] ADD CONSTRAINT [SADSADJOIN01] FOREIGN KEY ([attribute_type]) REFERENCES [dbo].[arg_class_def] ([class_name])
GO
ALTER TABLE [dbo].[arg_attribute_def] ADD CONSTRAINT [SADSADJOIN02] FOREIGN KEY ([class_name], [related_base_attribute]) REFERENCES [dbo].[arg_attribute_def] ([class_name], [attribute_name])
GO
ALTER TABLE [dbo].[arg_attribute_def] ADD CONSTRAINT [SADSCDJOIN01] FOREIGN KEY ([class_name]) REFERENCES [dbo].[arg_class_def] ([class_name])
GO
ALTER TABLE [dbo].[arg_attribute_def] ADD CONSTRAINT [SADSCDJOIN02] FOREIGN KEY ([class_template]) REFERENCES [dbo].[arg_class_def] ([class_name])
GO
ALTER TABLE [dbo].[arg_attribute_def] ADD CONSTRAINT [SADSFDJOIN01] FOREIGN KEY ([table_name], [field_name]) REFERENCES [dbo].[arg_field_def] ([table_name], [field_name])
GO
ALTER TABLE [dbo].[arg_attribute_def] ADD CONSTRAINT [SADSJDJOIN01] FOREIGN KEY ([join_name]) REFERENCES [dbo].[arg_join_def] ([join_name])
GO
GRANT SELECT ON  [dbo].[arg_attribute_def] TO [swcmadmin]
GRANT INSERT ON  [dbo].[arg_attribute_def] TO [swcmadmin]
GRANT DELETE ON  [dbo].[arg_attribute_def] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[arg_attribute_def] TO [swcmadmin]
GO