USE [Clancy_Exp_Database]
GO
/****** Object:  Table [dbo].[tblDHInterceptsCustom]    Script Date: 03/09/2010 07:29:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tblDHInterceptsCustom](
	[PackageID] [int] NOT NULL,
	[PackageName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Owner] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[DataSet] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[Hole_Id] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[mFrom] [real] NOT NULL,
	[mTo] [real] NOT NULL,
	[Element] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[IntervalWidth] [real] NULL,
	[Grade] [real] NULL,
	[InterceptDescription] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[MinCutOff] [real] NOT NULL,
	[MaxCutOff] [real] NOT NULL,
	[MinIntercept] [real] NOT NULL,
	[MaxInternalWaste] [real] NOT NULL,
	[CoElement1Name] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[CoElement1Grade] [real] NULL,
	[CoElement2Name] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[CoElement2Grade] [real] NULL,
	[CoElement3Name] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[CoElement3Grade] [real] NULL,
	[CoElement4Name] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[CoElement4Grade] [real] NULL,
	[CoElement5Name] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[CoElement5Grade] [real] NULL,
	[CoElement6Name] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[CoElement6Grade] [real] NULL,
	[Load_Date] [datetime] NULL CONSTRAINT [DF_tblDHInterceptsCustom_DateStamp]  DEFAULT (getdate()),
	[Loaded_By] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_tblDHInterceptsCustom_Loaded_By]  DEFAULT (suser_sname()),
	[Modified_Date] [datetime] NULL,
	[Modified_By] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[ts] [timestamp] NULL,
	[DeSurvey_Grid_ID] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[DeSurvey_East] [float] NULL,
	[DeSurvey_North] [float] NULL,
	[DeSurvey_RL] [real] NULL,
 CONSTRAINT [PK_tblDHInterceptsCustom] PRIMARY KEY CLUSTERED 
(
	[PackageID] ASC,
	[Owner] ASC,
	[DataSet] ASC,
	[Hole_Id] ASC,
	[mFrom] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[tblDHInterceptsCustom]  WITH CHECK ADD  CONSTRAINT [FK_tblDHInterceptsCustom_tblDHColl] FOREIGN KEY([DataSet], [Hole_Id])
REFERENCES [dbo].[tblDHColl] ([DataSet], [Hole_ID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[tblDHInterceptsCustom] CHECK CONSTRAINT [FK_tblDHInterceptsCustom_tblDHColl]