Tables [dbo].[arg_link_asset_cost]
Properties
PropertyValue
Row Count81
Created10:33:12 PM Thursday, February 10, 2011
Last Modified10:34:29 PM Thursday, February 10, 2011
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key xpkarg_link_asset_cost: own_resource_uuid\cost_idForeign Keys LATCDJOIN01: [dbo].[ca_owned_resource].own_resource_uuidown_resource_uuidbinary(16)16
No
Cluster Primary Key xpkarg_link_asset_cost: own_resource_uuid\cost_idForeign Keys LATCDJOIN03: [dbo].[al_costdet].cost_idcost_idbigint8
No
last_update_dateint4
Yes
version_numberint4
Yes
('0  ')
Foreign Keys FK_ARG_LINK_ASSET_COST_TENANT: [dbo].[ca_tenant].tenanttenantbinary(16)16
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key xpkarg_link_asset_cost: own_resource_uuid\cost_idxpkarg_link_asset_costown_resource_uuid, cost_id
Yes
Foreign Keys Foreign Keys
NameColumns
FK_ARG_LINK_ASSET_COST_TENANTtenant->[dbo].[ca_tenant].[id]
LATCDJOIN01own_resource_uuid->[dbo].[ca_owned_resource].[own_resource_uuid]
LATCDJOIN03cost_id->[dbo].[al_costdet].[cost_id]
SQL Script
CREATE TABLE [dbo].[arg_link_asset_cost]
(
[own_resource_uuid] [binary] (16) NOT NULL,
[cost_id] [bigint] NOT NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__ARG_LINK___VERSI__742F31CF] DEFAULT ('0  '),
[tenant] [binary] (16) NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[arg_link_asset_cost] ADD CONSTRAINT [xpkarg_link_asset_cost] PRIMARY KEY CLUSTERED ([own_resource_uuid], [cost_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[arg_link_asset_cost] ADD CONSTRAINT [FK_ARG_LINK_ASSET_COST_TENANT] FOREIGN KEY ([tenant]) REFERENCES [dbo].[ca_tenant] ([id])
GO
ALTER TABLE [dbo].[arg_link_asset_cost] ADD CONSTRAINT [LATCDJOIN01] FOREIGN KEY ([own_resource_uuid]) REFERENCES [dbo].[ca_owned_resource] ([own_resource_uuid])
GO
ALTER TABLE [dbo].[arg_link_asset_cost] ADD CONSTRAINT [LATCDJOIN03] FOREIGN KEY ([cost_id]) REFERENCES [dbo].[al_costdet] ([cost_id])
GO
Uses