CREATE TABLE [dbo].[ICModels]
(
[ModelID] [int] NOT NULL IDENTITY(1, 1),
[Model] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MakeID] [int] NOT NULL,
[Remarks] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Active] [bit] NOT NULL,
[Locks] [int] NOT NULL CONSTRAINT [DF_ICModels_Locks] DEFAULT ((0)),
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_ICModels_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_ICModels_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[ShTrackingConfigID] [int] NULL,
[IsHost] [bit] NOT NULL CONSTRAINT [DF_ICModels_IsHost] DEFAULT ((0)),
[IsAccessory] [bit] NOT NULL CONSTRAINT [DF_ICModels_IsAccessory] DEFAULT ((0)),
[IsMetered] [bit] NOT NULL CONSTRAINT [DF_ICModels_IsMetered] DEFAULT ((0)),
[RequireMeteronServiceCalls] [bit] NOT NULL CONSTRAINT [DF_ICModels_RequireMeteronServiceCalls] DEFAULT ((0)),
[PriorityID] [int] NULL,
[PriorityWeight] [decimal] (14, 4) NOT NULL CONSTRAINT [DF_ICModels_PriorityWeight] DEFAULT ((0)),
[UseSystemCBCAParams] [bit] NOT NULL CONSTRAINT [DF_ICModels_UseSystemCBCAParams] DEFAULT ((1)),
[CBNoDays] [int] NOT NULL CONSTRAINT [DF_ICModels_CBNoDays] DEFAULT ((0)),
[CANoDays] [int] NOT NULL CONSTRAINT [DF_ICModels_CANoDays] DEFAULT ((0)),
[CANoCalls] [int] NOT NULL CONSTRAINT [DF_ICModels_CANoCalls] DEFAULT ((0)),
[MeterInstructions] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICModels_MeterInstructions] DEFAULT (''),
[ModelCategoryID] [int] NOT NULL,
[Discontinued] [bit] NOT NULL CONSTRAINT [DF_ICModels_Discontinued] DEFAULT ((0)),
[DBFileHeaderID] [int] NOT NULL CONSTRAINT [DF_ICModels_DBFileHeaderID] DEFAULT ((1)),
[NoteID] [int] NULL,
[NoteFlag] [int] NOT NULL CONSTRAINT [DF_ICModels_NoteFlag] DEFAULT ((0)),
[IntroductionDate] [datetime] NULL,
[MfgDiscontinuedDate] [datetime] NULL,
[ServiceDiscontinuedDate] [datetime] NULL,
[cuTotalTargetRevenue] [money] NULL CONSTRAINT [DF_ICModels_cuTotalTargetRevenue] DEFAULT ((0.00)),
[cuTotalTargetMonthlyVolume] [int] NULL CONSTRAINT [DF_ICModels_cuTotalTargetMonthlyVolume] DEFAULT ((0)),
[cuTotalTargetRevenuePerCopy] [decimal] (18, 4) NULL CONSTRAINT [DF_ICModels_cuTotalTargetRevenuePerCopy] DEFAULT ((0.0000)),
[NoteCount] [int] NOT NULL CONSTRAINT [DF_ICModels_NoteCount] DEFAULT ((0)),
[CBNoClicks] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ICModels_CBNoClicks] DEFAULT ((0)),
[CANoClicks] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ICModels_CANoClicks] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICModels] ADD CONSTRAINT [PK_ICModels] PRIMARY KEY CLUSTERED ([ModelID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICModels] ADD CONSTRAINT [FK_ICModels_DBFileHeaderID_DBFileHeader] FOREIGN KEY ([DBFileHeaderID]) REFERENCES [dbo].[DBFileHeader] ([DBFileHeaderID])
GO
ALTER TABLE [dbo].[ICModels] ADD CONSTRAINT [FK_ICModels_MakeID_ICMakes] FOREIGN KEY ([MakeID]) REFERENCES [dbo].[ICMakes] ([MakeID])
GO
ALTER TABLE [dbo].[ICModels] ADD CONSTRAINT [FK_ICModels_ModelCategoryID_ICModelCategories] FOREIGN KEY ([ModelCategoryID]) REFERENCES [dbo].[ICModelCategories] ([ModelCategoryID])
GO
ALTER TABLE [dbo].[ICModels] ADD CONSTRAINT [FK_ICModels_NoteID_ICModelNotes] FOREIGN KEY ([NoteID]) REFERENCES [dbo].[ICModelNotes] ([NoteID])
GO
ALTER TABLE [dbo].[ICModels] ADD CONSTRAINT [FK_ICModels_PriorityID_SCPriorities] FOREIGN KEY ([PriorityID]) REFERENCES [dbo].[SCPriorities] ([PriorityID])
GO
ALTER TABLE [dbo].[ICModels] ADD CONSTRAINT [FK_ICModels_ShTrackingConfigID_ShTrackingConfigs] FOREIGN KEY ([ShTrackingConfigID]) REFERENCES [dbo].[ShTrackingConfigs] ([ShTrackingConfigID])
GO