[dbo].[ca_cic_offline

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	4:35:54 PM Wednesday, March 24, 2010
Last Modified	4:35:54 PM Wednesday, March 24, 2010

Name	Data Type	Max Length (Bytes)
ca_offline_baseline_id	int	4
ca_offline_baseline_name	nvarchar(255)	510
messages_staged	int	4
messages_processed	int	4
checksum	nvarchar(50)	100

	Name	Columns	Unique
	PK_ca_cic_offline_manager_baseline_id	ca_offline_baseline_id

SQL Script

CREATE TABLE [dbo].[ca_cic_offline_manager]
(
[ca_offline_baseline_id] [int] NOT NULL,
[ca_offline_baseline_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[messages_staged] [int] NULL,
[messages_processed] [int] NULL,
[checksum] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_cic_offline_manager] ADD CONSTRAINT [PK_ca_cic_offline_manager_baseline_id] PRIMARY KEY CLUSTERED ([ca_offline_baseline_id]) ON [PRIMARY]
GO