CREATE TABLE [dbo].[arg_join_member]
(
[join_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[member_instance] [int] NOT NULL,
[left_side_table] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[left_side_field] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[left_side_value] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[right_side_table] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[right_side_field] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[right_side_value] [nvarchar] (255) 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_join___versi__2E70E1FD] DEFAULT ('0'),
[core] [int] NOT NULL CONSTRAINT [DF__ARG_JOIN_M__CORE__6A30C649] DEFAULT ('1')
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[arg_join_member] ADD CONSTRAINT [XPKarg_join_member] PRIMARY KEY CLUSTERED ([join_name], [member_instance]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [sysjmindex02] ON [dbo].[arg_join_member] ([left_side_table], [left_side_field]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [sysjmindex03] ON [dbo].[arg_join_member] ([right_side_table], [right_side_field]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[arg_join_member] ADD CONSTRAINT [SJMSFDJOIN01] FOREIGN KEY ([left_side_table], [left_side_field]) REFERENCES [dbo].[arg_field_def] ([table_name], [field_name])
GO
ALTER TABLE [dbo].[arg_join_member] ADD CONSTRAINT [SJMSFDJOIN02] FOREIGN KEY ([right_side_table], [right_side_field]) REFERENCES [dbo].[arg_field_def] ([table_name], [field_name])
GO
ALTER TABLE [dbo].[arg_join_member] ADD CONSTRAINT [SJMSJDJOIN01] FOREIGN KEY ([join_name]) REFERENCES [dbo].[arg_join_def] ([join_name])
GO
GRANT SELECT ON  [dbo].[arg_join_member] TO [swcmadmin]
GRANT INSERT ON  [dbo].[arg_join_member] TO [swcmadmin]
GRANT DELETE ON  [dbo].[arg_join_member] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[arg_join_member] TO [swcmadmin]
GO