Waveform-TABLE.sql

USE [PortalPerf]
GO

/****** Object:  Table [dbo].[Waveform]    Script Date: 11/1/2017 8:41:25 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Waveform](
	[WaveformID] [BIGINT] IDENTITY(-9223372036854775808,1) NOT NULL,
	[SampleCount] [INT] NOT NULL,
	[TypeName] [VARCHAR](50) NULL,
	[TypeID] [SMALLINT] NOT NULL,
	[Samples] [VARBINARY](MAX) NOT NULL,
	[Compressed] [BIT] NOT NULL,
	[TopicSessionID] [INT] NOT NULL,
	[StartTimeUTC] [DATETIME2](7) NOT NULL,
	[EndTimeUTC] [DATETIME2](7) NOT NULL,
	[CreateDate] [DATETIME2](7) NOT NULL,
 CONSTRAINT [PK_Waveform_StartTimeUTC_WaveformID] PRIMARY KEY CLUSTERED 
(
	[StartTimeUTC] ASC,
	[WaveformID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[Waveform] ADD  CONSTRAINT [DF_Waveform_CreateDate]  DEFAULT (SYSUTCDATETIME()) FOR [CreateDate]
GO