Tables [dbo].[al_event_information_schema]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count36
Created10:33:02 PM Thursday, February 10, 2011
Last Modified10:34:23 PM Thursday, February 10, 2011
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key event_inform_schema_pk: class_nameForeign Keys event_inform_schema_fk4: [dbo].[arg_class_def].class_nameclass_namenvarchar(255)510
No
Foreign Keys event_inform_schema_fk1: [dbo].[arg_class_def].aud_fired_evt_link_class_nameaud_fired_evt_link_class_namenvarchar(255)510
No
Foreign Keys event_inform_schema_fk2: [dbo].[arg_class_def].aud_pointer_class_nameaud_pointer_class_namenvarchar(255)510
No
Foreign Keys event_inform_schema_fk3: [dbo].[arg_class_def].aud_view_class_nameaud_view_class_namenvarchar(255)510
No
primarykeysvarchar(1024)1024
No
creation_usernvarchar(64)128
Yes
creation_dateint4
Yes
last_update_usernvarchar(64)128
Yes
last_update_dateint4
Yes
version_numberint4
Yes
('0 ')
Foreign Keys event_inform_schema_fk5: [dbo].[arg_class_def].aud_class_nameaud_class_namenvarchar(255)510
Yes
Foreign Keys event_inform_schema_fk6: [dbo].[arg_class_def].aud_watch_timer_class_nameaud_watch_timer_class_namenvarchar(255)510
Yes
arg_hist_pointer_tablenvarchar(255)510
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key event_inform_schema_pk: class_nameevent_inform_schema_pkclass_name
Yes
Foreign Keys Foreign Keys
NameColumns
event_inform_schema_fk1aud_fired_evt_link_class_name->[dbo].[arg_class_def].[class_name]
event_inform_schema_fk2aud_pointer_class_name->[dbo].[arg_class_def].[class_name]
event_inform_schema_fk3aud_view_class_name->[dbo].[arg_class_def].[class_name]
event_inform_schema_fk4class_name->[dbo].[arg_class_def].[class_name]
event_inform_schema_fk5aud_class_name->[dbo].[arg_class_def].[class_name]
event_inform_schema_fk6aud_watch_timer_class_name->[dbo].[arg_class_def].[class_name]
SQL Script
CREATE TABLE [dbo].[al_event_information_schema]
(
[class_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[aud_fired_evt_link_class_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[aud_pointer_class_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[aud_view_class_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[primarykeys] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT 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__AL_EVT_INFO_SCHEMA_VERSION] DEFAULT ('0 '),
[aud_class_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[aud_watch_timer_class_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[arg_hist_pointer_table] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[al_event_information_schema] ADD CONSTRAINT [event_inform_schema_pk] PRIMARY KEY CLUSTERED ([class_name]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[al_event_information_schema] ADD CONSTRAINT [event_inform_schema_fk1] FOREIGN KEY ([aud_fired_evt_link_class_name]) REFERENCES [dbo].[arg_class_def] ([class_name])
GO
ALTER TABLE [dbo].[al_event_information_schema] ADD CONSTRAINT [event_inform_schema_fk2] FOREIGN KEY ([aud_pointer_class_name]) REFERENCES [dbo].[arg_class_def] ([class_name])
GO
ALTER TABLE [dbo].[al_event_information_schema] ADD CONSTRAINT [event_inform_schema_fk3] FOREIGN KEY ([aud_view_class_name]) REFERENCES [dbo].[arg_class_def] ([class_name])
GO
ALTER TABLE [dbo].[al_event_information_schema] ADD CONSTRAINT [event_inform_schema_fk4] FOREIGN KEY ([class_name]) REFERENCES [dbo].[arg_class_def] ([class_name])
GO
ALTER TABLE [dbo].[al_event_information_schema] ADD CONSTRAINT [event_inform_schema_fk5] FOREIGN KEY ([aud_class_name]) REFERENCES [dbo].[arg_class_def] ([class_name])
GO
ALTER TABLE [dbo].[al_event_information_schema] ADD CONSTRAINT [event_inform_schema_fk6] FOREIGN KEY ([aud_watch_timer_class_name]) REFERENCES [dbo].[arg_class_def] ([class_name])
GO
Uses
Used By