[dbo].[TapiAlertServiceOperation]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
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
Waveform	varchar(255)	255	('')
RepeatTimes	int	4
Phone4	varchar(255)	255	('')
Phone5	varchar(255)	255	('')
Phone3	varchar(255)	255	('')
Phone2	varchar(255)	255	('')
Phone1	varchar(255)	255	('')
RefID	varchar(255)	255	('')

	Name	Columns	Unique
	PK__TapiAlertService__06CD04F7	RefID

SQL Script

CREATE TABLE [dbo].[TapiAlertServiceOperation]
(
[Waveform] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__TapiAlert__Wavef__00200768] DEFAULT (''),
[RepeatTimes] [int] NULL,
[Phone4] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__TapiAlert__Phone__01142BA1] DEFAULT (''),
[Phone5] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__TapiAlert__Phone__02084FDA] DEFAULT (''),
[Phone3] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__TapiAlert__Phone__02FC7413] DEFAULT (''),
[Phone2] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__TapiAlert__Phone__03F0984C] DEFAULT (''),
[Phone1] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__TapiAlert__Phone__04E4BC85] DEFAULT (''),
[RefID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__TapiAlert__RefID__05D8E0BE] DEFAULT ('')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TapiAlertServiceOperation] ADD CONSTRAINT [PK__TapiAlertService__06CD04F7] PRIMARY KEY CLUSTERED ([RefID]) ON [PRIMARY]
GO