CREATE TABLE [dbo].[arg_field_def]
(
[table_name] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[field_name] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[field_description] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[additional_info] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[actual_table_name] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[actual_field_name] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[data_type] [smallint] NULL,
[data_size] [smallint] NULL,
[field_unique] [smallint] NULL,
[field_required] [smallint] NULL,
[primary_key] [smallint] NULL,
[foreign_key] [smallint] NULL,
[extended] [smallint] NULL,
[generate_reminder] [smallint] NULL,
[generate_event] [smallint] NULL,
[auditable] [smallint] NULL,
[attribute_popup] [smallint] NULL,
[attribute_autopopup] [smallint] NULL,
[attribute_formatted] [smallint] NULL,
[attribute_hidden] [smallint] NULL,
[attribute_codedpopup] [smallint] NULL,
[attribute_audited] [smallint] NULL,
[mass_change] [smallint] NULL,
[label_customizable] [smallint] NULL,
[user_field] [smallint] NULL,
[report_included] [smallint] NULL,
[lookup_included] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[list_id] [int] 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_field__versi__0662F0A3] DEFAULT ('0'),
[instance] [smallint] NULL,
[location_type_id] [int] NULL,
[ishierarchy] [smallint] NULL,
[inactive] [smallint] NULL CONSTRAINT [DF__arg_field__inact__78BD77DE] DEFAULT ((0)),
[created_by_uapm] [smallint] NULL CONSTRAINT [DF__arg_field__creat__79B19C17] DEFAULT ((0)),
[core] [int] NOT NULL CONSTRAINT [DF__ARG_FIELD___CORE__75785BC3] DEFAULT ('1')
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[arg_field_def] ADD CONSTRAINT [XPKarg_field_def] PRIMARY KEY CLUSTERED ([table_name], [field_name]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[arg_field_def] ADD CONSTRAINT [SFDLDJOIN18] FOREIGN KEY ([list_id]) REFERENCES [dbo].[arg_listdef] ([ldid]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[arg_field_def] ADD CONSTRAINT [SFDSTDJOIN01] FOREIGN KEY ([table_name]) REFERENCES [dbo].[arg_table_def] ([table_name])
GO
ALTER TABLE [dbo].[arg_field_def] ADD CONSTRAINT [SFDSTDJOIN02] FOREIGN KEY ([actual_table_name], [actual_field_name]) REFERENCES [dbo].[arg_field_def] ([table_name], [field_name])
GO
ALTER TABLE [dbo].[arg_field_def] ADD CONSTRAINT [SFDTYPJOIN01] FOREIGN KEY ([location_type_id]) REFERENCES [dbo].[ca_location_type] ([id])
GO
GRANT SELECT ON  [dbo].[arg_field_def] TO [swcmadmin]
GRANT INSERT ON  [dbo].[arg_field_def] TO [swcmadmin]
GRANT DELETE ON  [dbo].[arg_field_def] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[arg_field_def] TO [swcmadmin]
GO