Tables [dbo].[ca_link_logical_asset_class_def]
Properties
PropertyValue
Row Count0
Created10:23:59 AM Sunday, December 05, 2010
Last Modified10:24:03 AM Sunday, December 05, 2010
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key XPKca_link_logical_asset_class_def: class_id\logical_asset_uuidForeign Keys $ca_li_r000002fe00000000: [dbo].[ca_class_def].class_idclass_idint4
No
Cluster Primary Key XPKca_link_logical_asset_class_def: class_id\logical_asset_uuidForeign Keys $ca_li_r0000030700000000: [dbo].[ca_logical_asset].logical_asset_uuidlogical_asset_uuidbinary(16)16
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKca_link_logical_asset_class_def: class_id\logical_asset_uuidXPKca_link_logical_asset_class_defclass_id, logical_asset_uuid
Yes
Foreign Keys Foreign Keys
NameColumns
$ca_li_r000002fe00000000class_id->[dbo].[ca_class_def].[class_id]
$ca_li_r0000030700000000logical_asset_uuid->[dbo].[ca_logical_asset].[logical_asset_uuid]
Permissions
TypeActionOwning Principal
GrantDeleteca_itrm_group
GrantInsertca_itrm_group
GrantDeleteswcmadmin
GrantInsertswcmadmin
GrantSelectregadmin
GrantSelectca_itrm_group
GrantUpdateca_itrm_group
GrantSelectswcmadmin
GrantUpdateswcmadmin
SQL Script
CREATE TABLE [dbo].[ca_link_logical_asset_class_def]
(
[class_id] [int] NOT NULL,
[logical_asset_uuid] [binary] (16) NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[ca_link_logical_asset_class_def] ADD CONSTRAINT [XPKca_link_logical_asset_class_def] PRIMARY KEY CLUSTERED ([class_id], [logical_asset_uuid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_link_logical_asset_class_def] ADD CONSTRAINT [$ca_li_r000002fe00000000] FOREIGN KEY ([class_id]) REFERENCES [dbo].[ca_class_def] ([class_id])
GO
ALTER TABLE [dbo].[ca_link_logical_asset_class_def] ADD CONSTRAINT [$ca_li_r0000030700000000] FOREIGN KEY ([logical_asset_uuid]) REFERENCES [dbo].[ca_logical_asset] ([logical_asset_uuid])
GO
GRANT SELECT ON  [dbo].[ca_link_logical_asset_class_def] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[ca_link_logical_asset_class_def] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[ca_link_logical_asset_class_def] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[ca_link_logical_asset_class_def] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[ca_link_logical_asset_class_def] TO [regadmin]
GRANT SELECT ON  [dbo].[ca_link_logical_asset_class_def] TO [swcmadmin]
GRANT INSERT ON  [dbo].[ca_link_logical_asset_class_def] TO [swcmadmin]
GRANT DELETE ON  [dbo].[ca_link_logical_asset_class_def] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[ca_link_logical_asset_class_def] TO [swcmadmin]
GO
Uses