Tables [dbo].[C2ORuntimeObjectsArch]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count129
Created11:42:02 AM Friday, March 26, 2010
Last Modified11:42:02 AM Friday, March 26, 2010
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentityDefault
compressedStatetinyint1
Yes
((0))
ModifiedStartTimedatetime8
Yes
SecurityContextGrpvarchar(255)255
Yes
DocumentTypevarchar(255)255
Yes
DiscriminatorTypevarchar(255)255
Yes
EditStatevarchar(25)25
Yes
NodeNamevarchar(255)255
Yes
RunStatevarchar(25)25
Yes
Callervarchar(255)255
Yes
compressedLogtinyint1
Yes
((0))
ParentIDint4
Yes
OperationNamevarchar(255)255
Yes
VersionNovarchar(255)255
Yes
AgentNamevarchar(255)255
Yes
BaseOIDint4
Yes
Starteddatetime8
Yes
ServiceIdvarchar(255)255
Yes
ActualStartTimedatetime8
Yes
Instancevarchar(255)255
Yes
RootIDint4
Yes
ModifiedDatedatetime8
Yes
Endeddatetime8
Yes
CallerNodevarchar(255)255
Yes
CreationDatedatetime8
Yes
ROIDint4
No
SecurityContextIDvarchar(255)255
Yes
Cluster Primary Key PK_C2ORuntimeObjectsArch_OID: OIDOIDint4
No
1 - 1
LogXMLtextmax
Yes
EditedByvarchar(255)255
Yes
StateXMLtextmax
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_C2ORuntimeObjectsArch_OID: OIDPK_C2ORuntimeObjectsArch_OIDOID
Yes
SQL Script
CREATE TABLE [dbo].[C2ORuntimeObjectsArch]
(
[compressedState] [tinyint] NULL CONSTRAINT [DF__C2ORuntim__compr__15502E78] DEFAULT ((0)),
[ModifiedStartTime] [datetime] NULL,
[SecurityContextGrp] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DocumentType] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DiscriminatorType] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EditState] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NodeName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RunState] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Caller] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[compressedLog] [tinyint] NULL CONSTRAINT [DF__C2ORuntim__compr__164452B1] DEFAULT ((0)),
[ParentID] [int] NULL,
[OperationName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VersionNo] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AgentName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BaseOID] [int] NULL,
[Started] [datetime] NULL,
[ServiceId] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ActualStartTime] [datetime] NULL,
[Instance] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RootID] [int] NULL,
[ModifiedDate] [datetime] NULL,
[Ended] [datetime] NULL,
[CallerNode] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreationDate] [datetime] NULL,
[ROID] [int] NOT NULL,
[SecurityContextID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OID] [int] NOT NULL IDENTITY(1, 1),
[LogXML] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EditedBy] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StateXML] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[C2ORuntimeObjectsArch] ADD CONSTRAINT [PK_C2ORuntimeObjectsArch_OID] PRIMARY KEY CLUSTERED ([OID]) ON [PRIMARY]
GO
Uses
Used By