Tables [dbo].[vis_graph_metadata]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count7
Created2:45:48 PM Saturday, July 19, 2008
Last Modified9:09:07 PM Friday, December 05, 2008
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Primary Key PK__vis_graph_metada__67EEE5DC: ididint4
No
focus_ci_listvarchar(1024)1024
No
graph_levelsmallint2
No
layoutsmallint2
No
Foreign Keys vis_graph_metadata_fk: [dbo].[vis_object_store_master].filter_idfilter_idint4
Yes
hidden_ci_listvarchar(2048)2048
Yes
inactiveint4
No
Indexes UQ__vis_graph_metada__68E30A15: graph_namegraph_namenvarchar(100)200
No
creation_userbinary(16)16
Yes
creation_dateint4
Yes
last_update_userbinary(16)16
Yes
last_update_dateint4
Yes
tenantbinary(16)16
Yes
Indexes Indexes
NameColumnsUnique
Primary Key PK__vis_graph_metada__67EEE5DC: idPK__vis_graph_metada__67EEE5DCid
Yes
UQ__vis_graph_metada__68E30A15graph_name
Yes
Foreign Keys Foreign Keys
NameColumns
vis_graph_metadata_fkfilter_id->[dbo].[vis_object_store_master].[id]
Permissions
TypeActionOwning Principal
GrantDeleteservice_desk_admin_group
GrantInsertservice_desk_admin_group
GrantSelectservice_desk_admin_group
GrantUpdateservice_desk_admin_group
GrantSelectservice_desk_ro_group
SQL Script
CREATE TABLE [dbo].[vis_graph_metadata]
(
[id] [int] NOT NULL,
[focus_ci_list] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[graph_level] [smallint] NOT NULL,
[layout] [smallint] NOT NULL,
[filter_id] [int] NULL,
[hidden_ci_list] [varchar] (2048) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[inactive] [int] NOT NULL,
[graph_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[creation_user] [binary] (16) NULL,
[creation_date] [int] NULL,
[last_update_user] [binary] (16) NULL,
[last_update_date] [int] NULL,
[tenant] [binary] (16) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[vis_graph_metadata] ADD CONSTRAINT [PK__vis_graph_metada__67EEE5DC] PRIMARY KEY NONCLUSTERED ([id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[vis_graph_metadata] ADD CONSTRAINT [UQ__vis_graph_metada__68E30A15] UNIQUE NONCLUSTERED ([graph_name]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[vis_graph_metadata] ADD CONSTRAINT [vis_graph_metadata_fk] FOREIGN KEY ([filter_id]) REFERENCES [dbo].[vis_object_store_master] ([id])
GO
GRANT SELECT ON  [dbo].[vis_graph_metadata] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[vis_graph_metadata] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[vis_graph_metadata] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[vis_graph_metadata] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[vis_graph_metadata] TO [service_desk_ro_group]
GO
Uses