CREATE TABLE [dbo].[arg_class_def]
(
[class_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[class_label] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[class_alias] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[table_name] [nvarchar] (32) 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_class__versi__69C6B1F5] DEFAULT ('0'),
[customizable] [smallint] NULL,
[cacheable] [smallint] NOT NULL CONSTRAINT [DF__arg_class__cache__1705CEC5] DEFAULT ('0'),
[app_filter] [smallint] NOT NULL CONSTRAINT [DF__arg_class__app_f__17F9F2FE] DEFAULT ('2'),
[core] [int] NOT NULL CONSTRAINT [DF__ARG_CLASS___CORE__15A53433] DEFAULT ('1'),
[top_level] [int] NULL,
[audited] [int] NULL CONSTRAINT [DF__ARG_CLASS__AUDIT__1699586C] DEFAULT ('0'),
[primary_object] [int] NULL CONSTRAINT [DF__ARG_CLASS__PRIMA__178D7CA5] DEFAULT ('0'),
[tenancy_option] [int] NULL CONSTRAINT [DF__ARG_CLASS__TENAN__1881A0DE] DEFAULT ('0'),
[config_id] [int] NULL CONSTRAINT [DF__ARG_CLASS__CONFI__1975C517] DEFAULT (NULL),
[importable] [int] NULL CONSTRAINT [DF__ARG_CLASS_DEF_IMPORTABLE] DEFAULT ('0'),
[api_internal] [int] NULL CONSTRAINT [DF__ARG_CLASS_DEF_API_INTRNL] DEFAULT ('1'),
[class_name_override] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[link_object] [int] NULL CONSTRAINT [DF__ARG_CLASS_DEF_LNK_OBJ] DEFAULT ('0')
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[arg_class_def] ADD CONSTRAINT [XPKarg_class_def] PRIMARY KEY CLUSTERED ([class_name]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [syscdindex03] ON [dbo].[arg_class_def] ([class_template]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [syscdindex04] ON [dbo].[arg_class_def] ([control_object], [control_name]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [syscdindex02] ON [dbo].[arg_class_def] ([table_name]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[arg_class_def] ADD CONSTRAINT [SCDSCDJOIN01] FOREIGN KEY ([class_template]) REFERENCES [dbo].[arg_class_def] ([class_name])
GO
ALTER TABLE [dbo].[arg_class_def] ADD CONSTRAINT [SCDSTDJOIN01] FOREIGN KEY ([table_name]) REFERENCES [dbo].[arg_table_def] ([table_name])
GO
ALTER TABLE [dbo].[arg_class_def] ADD CONSTRAINT [SCDTOJOIN01] FOREIGN KEY ([tenancy_option]) REFERENCES [dbo].[arg_tenancy_option] ([id])
GO
GRANT SELECT ON  [dbo].[arg_class_def] TO [swcmadmin]
GRANT INSERT ON  [dbo].[arg_class_def] TO [swcmadmin]
GRANT DELETE ON  [dbo].[arg_class_def] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[arg_class_def] TO [swcmadmin]
GO