CREATE TABLE [dbo].[arg_assetver]
(
[own_resource_uuid] [binary] (16) NOT NULL,
[avivid] [bigint] NOT NULL,
[model_uuid] [binary] (16) NULL,
[avacqdt] [datetime] NULL,
[avstatus] [int] NULL,
[avstatdt] [datetime] NULL,
[avcurrnt] [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_asset__versi__61316BF4] DEFAULT ('0'),
[tenant] [binary] (16) NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[arg_assetver] ADD CONSTRAINT [xpkarg_assetver] PRIMARY KEY CLUSTERED ([own_resource_uuid], [avivid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [avindex03] ON [dbo].[arg_assetver] ([avivid], [own_resource_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [avindex02] ON [dbo].[arg_assetver] ([avstatus]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [avindex04] ON [dbo].[arg_assetver] ([model_uuid], [avivid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[arg_assetver] ADD CONSTRAINT [ATAVJOIN01] FOREIGN KEY ([own_resource_uuid]) REFERENCES [dbo].[ca_owned_resource] ([own_resource_uuid])
GO
ALTER TABLE [dbo].[arg_assetver] ADD CONSTRAINT [AVIVJOIN01] FOREIGN KEY ([model_uuid], [avivid]) REFERENCES [dbo].[arg_itemver] ([model_uuid], [ivid])
GO
ALTER TABLE [dbo].[arg_assetver] ADD CONSTRAINT [AVRSJOIN01] FOREIGN KEY ([avstatus]) REFERENCES [dbo].[ca_resource_status] ([id])
GO
ALTER TABLE [dbo].[arg_assetver] ADD CONSTRAINT [FK_ARG_ASSETVER_TENANT] FOREIGN KEY ([tenant]) REFERENCES [dbo].[ca_tenant] ([id])
GO
GRANT SELECT ON  [dbo].[arg_assetver] TO [amsgroup]
GRANT SELECT ON  [dbo].[arg_assetver] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[arg_assetver] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[arg_assetver] TO [swcmadmin]
GRANT INSERT ON  [dbo].[arg_assetver] TO [swcmadmin]
GRANT DELETE ON  [dbo].[arg_assetver] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[arg_assetver] TO [swcmadmin]
GO