tjakobsen

USE [CTXRM_STAT]
GO
/****** Object:  Table [dbo].[KMD_Apps]    Script Date: 05/07/2008 17:28:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[KMD_Apps](
    [AppID] [INT] IDENTITY(1,1) NOT NULL,
    [FK_APPNAMEID] [INT] NOT NULL,
    [CustID] [INT] NOT NULL,
    [ContractID] [INT] NOT NULL,
 CONSTRAINT [PK_KMD_Apps] PRIMARY KEY CLUSTERED
(
    [AppID] ASC
) ON [PRIMARY]
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[KMD_Apps]  WITH NOCHECK ADD  CONSTRAINT [FK_KMD_Apps_KMD_Contracts] FOREIGN KEY([ContractID])
REFERENCES [dbo].[KMD_Contracts] ([ContractID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[KMD_Apps] CHECK CONSTRAINT [FK_KMD_Apps_KMD_Contracts]
GO
ALTER TABLE [dbo].[KMD_Apps]  WITH NOCHECK ADD  CONSTRAINT [FK_KMD_Apps_KMD_Customers] FOREIGN KEY([CustID])
REFERENCES [dbo].[KMD_Customers] ([CustID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[KMD_Apps] CHECK CONSTRAINT [FK_KMD_Apps_KMD_Customers]
GO
ALTER TABLE [dbo].[KMD_Apps]  WITH NOCHECK ADD  CONSTRAINT [FK_KMD_Apps_LU_APPNAME] FOREIGN KEY([FK_APPNAMEID])
REFERENCES [dbo].[LU_APPNAME] ([PK_APPNAMEID])
GO
ALTER TABLE [dbo].[KMD_Apps] CHECK CONSTRAINT [FK_KMD_Apps_LU_APPNAME]