Tables [dbo].[C2OMessage]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count1439
Created11:42:02 AM Friday, March 26, 2010
Last Modified11:42:02 AM Friday, March 26, 2010
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
AgentNamevarchar(255)255
Yes
Timestampdatetime8
Yes
LogLevelint4
Yes
ReferenceEntityvarchar(255)255
Yes
Cluster Primary Key PK_C2OMessage_id: ididint4
No
1 - 1
SourceServicevarchar(255)255
Yes
Messagetextmax
Yes
SourceNodevarchar(255)255
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_C2OMessage_id: idPK_C2OMessage_idid
Yes
SQL Script
CREATE TABLE [dbo].[C2OMessage]
(
[AgentName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Timestamp] [datetime] NULL,
[LogLevel] [int] NULL,
[ReferenceEntity] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[id] [int] NOT NULL IDENTITY(1, 1),
[SourceService] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Message] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SourceNode] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[C2OMessage] ADD CONSTRAINT [PK_C2OMessage_id] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
Uses