Tables [dbo].[e2e_wrm_wrm]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
HeapYes
Row Count0
Created11:07:13 AM Wednesday, March 07, 2007
Last Modified11:09:37 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
sourceidint4
No
identifieridint4
No
transactionidint4
No
typeidint4
No
newsumstatidint4
Yes
urlidint4
Yes
urldescriptionvarchar(256)256
Yes
warnthresint4
Yes
critthresint4
Yes
resptimeint4
Yes
firstbytemsint4
Yes
groupidint4
Yes
newrespstatidint4
Yes
newaccuracystatidint4
Yes
statuscodeint4
Yes
statusmessageidint4
Yes
bytesrecint4
Yes
activedetailidint4
Yes
timestartdatetime8
No
timeenddatetime8
No
contentcheckidint4
Yes
retrycountint4
Yes
connecttimemsint4
Yes
pingtimemsint4
Yes
issentint4
Yes
((0))
requestnameidint4
Yes
agedateint4
Yes
Permissions
TypeActionOwning Principal
GrantDeleteapmadmin
GrantInsertapmadmin
GrantSelectapmadmin
GrantUpdateapmadmin
SQL Script
CREATE TABLE [dbo].[e2e_wrm_wrm]
(
[sourceid] [int] NOT NULL,
[identifierid] [int] NOT NULL,
[transactionid] [int] NOT NULL,
[typeid] [int] NOT NULL,
[newsumstatid] [int] NULL,
[urlid] [int] NULL,
[urldescription] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[warnthres] [int] NULL,
[critthres] [int] NULL,
[resptime] [int] NULL,
[firstbytems] [int] NULL,
[groupid] [int] NULL,
[newrespstatid] [int] NULL,
[newaccuracystatid] [int] NULL,
[statuscode] [int] NULL,
[statusmessageid] [int] NULL,
[bytesrec] [int] NULL,
[activedetailid] [int] NULL,
[timestart] [datetime] NOT NULL,
[timeend] [datetime] NOT NULL,
[contentcheckid] [int] NULL,
[retrycount] [int] NULL,
[connecttimems] [int] NULL,
[pingtimems] [int] NULL,
[issent] [int] NULL CONSTRAINT [DF__e2e_wrm_w__issen__3469B275] DEFAULT ((0)),
[requestnameid] [int] NULL,
[agedate] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[e2e_wrm_wrm] TO [apmadmin]
GRANT INSERT ON  [dbo].[e2e_wrm_wrm] TO [apmadmin]
GRANT DELETE ON  [dbo].[e2e_wrm_wrm] TO [apmadmin]
GRANT UPDATE ON  [dbo].[e2e_wrm_wrm] TO [apmadmin]
GO
Uses
Used By