[dbo].[C2OServiceOperationInstance]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	758
Created	11:43:57 AM Friday, March 26, 2010
Last Modified	11:43:57 AM Friday, March 26, 2010

Name	Data Type	Max Length (Bytes)	Default
RefID	varchar(255)	255	('')
ServiceOpName	varchar(100)	100
State	varchar(50)	50
CallerReference	varchar(100)	100
HostID	varchar(255)	255	('')
CallerType	varchar(7000)	7000
StartTime	datetime	8
EndTime	datetime	8
CallingInstance	varchar(255)	255
ServiceGrpName	varchar(100)	100
NodeID	varchar(255)	255	('')

	Name	Columns	Unique
	PK__C2OServiceOperat__25518C17	RefID

SQL Script

CREATE TABLE [dbo].[C2OServiceOperationInstance]
(
[RefID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__C2OServic__RefID__22751F6C] DEFAULT (''),
[ServiceOpName] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[State] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CallerReference] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HostID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__C2OServic__HostI__236943A5] DEFAULT (''),
[CallerType] [varchar] (7000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StartTime] [datetime] NULL,
[EndTime] [datetime] NULL,
[CallingInstance] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ServiceGrpName] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NodeID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__C2OServic__NodeI__245D67DE] DEFAULT ('')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[C2OServiceOperationInstance] ADD CONSTRAINT [PK__C2OServiceOperat__25518C17] PRIMARY KEY CLUSTERED ([RefID]) ON [PRIMARY]
GO