Tables [dbo].[C2OFlowchartInstanceObject]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count142
Created11:43:57 AM Friday, March 26, 2010
Last Modified11:43:57 AM Friday, March 26, 2010
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
StartTimedatetime8
Yes
EndTimedatetime8
Yes
Criticalityvarchar(20)20
Yes
ManualExecutionTimevarchar(10)10
Yes
CallerRefvarchar(100)100
Yes
NodeIDvarchar(255)255
No
('')
Statevarchar(45)45
Yes
ProcessExecutionTimevarchar(10)10
Yes
Cluster Primary Key PK__C2OFlowchartInst__208CD6FA: RefIDRefIDvarchar(255)255
No
('')
Debugtinyint1
Yes
UserNamevarchar(45)45
Yes
CallerTypevarchar(45)45
Yes
RefFlowVersionvarchar(255)255
Yes
SystemGrpNamevarchar(50)50
Yes
HostIDvarchar(255)255
No
('')
CallingInstancevarchar(45)45
Yes
ManualCostvarchar(10)10
Yes
RefFlowPathvarchar(7000)7000
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK__C2OFlowchartInst__208CD6FA: RefIDPK__C2OFlowchartInst__208CD6FARefID
Yes
SQL Script
CREATE TABLE [dbo].[C2OFlowchartInstanceObject]
(
[StartTime] [datetime] NULL,
[EndTime] [datetime] NULL,
[Criticality] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ManualExecutionTime] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CallerRef] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NodeID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__C2OFlowch__NodeI__1DB06A4F] DEFAULT (''),
[State] [varchar] (45) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ProcessExecutionTime] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RefID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__C2OFlowch__RefID__1EA48E88] DEFAULT (''),
[Debug] [tinyint] NULL,
[UserName] [varchar] (45) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CallerType] [varchar] (45) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RefFlowVersion] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SystemGrpName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HostID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__C2OFlowch__HostI__1F98B2C1] DEFAULT (''),
[CallingInstance] [varchar] (45) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ManualCost] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RefFlowPath] [varchar] (7000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[C2OFlowchartInstanceObject] ADD CONSTRAINT [PK__C2OFlowchartInst__208CD6FA] PRIMARY KEY CLUSTERED ([RefID]) ON [PRIMARY]
GO
Uses