CREATE TABLE [dbo].[arg_linkdef]
(
[ndadid] [int] NOT NULL,
[ndid] [smallint] NOT NULL,
[ndtext] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[nd2obty] [smallint] NULL,
[nd2subty] [int] NULL,
[ndreqd] [smallint] 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_linkd__versi__4830B400] DEFAULT ('0')
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[arg_linkdef] ADD CONSTRAINT [XPKarg_linkdef] PRIMARY KEY CLUSTERED ([ndadid], [ndid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [ndindex02] ON [dbo].[arg_linkdef] ([ndadid], [ndtext]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[arg_linkdef] ADD CONSTRAINT [NDADJOIN01] FOREIGN KEY ([ndadid]) REFERENCES [dbo].[arg_actiondf] ([adid])
GO
ALTER TABLE [dbo].[arg_linkdef] ADD CONSTRAINT [NDSLJOIN02] FOREIGN KEY ([nd2subty]) REFERENCES [dbo].[ca_resource_family] ([id])
GO
GRANT SELECT ON  [dbo].[arg_linkdef] TO [amsgroup]
GRANT SELECT ON  [dbo].[arg_linkdef] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[arg_linkdef] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[arg_linkdef] TO [swcmadmin]
GRANT INSERT ON  [dbo].[arg_linkdef] TO [swcmadmin]
GRANT DELETE ON  [dbo].[arg_linkdef] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[arg_linkdef] TO [swcmadmin]
GO