Tables [dbo].[ICModels]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:55:41 AM Thursday, March 21, 2019
Last Modified1:15:30 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_ICModels: ModelIDModelIDint4
False
1 - 1
Modelvarchar(32)32
False
Descriptionvarchar(64)64
False
Foreign Keys FK_ICModels_MakeID_ICMakes: [dbo].[ICMakes].MakeIDMakeIDint4
False
Remarksvarchar(255)255
False
Activebit1
False
Locksint4
False
((0))
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
True
Foreign Keys FK_ICModels_ShTrackingConfigID_ShTrackingConfigs: [dbo].[ShTrackingConfigs].ShTrackingConfigIDShTrackingConfigIDint4
True
IsHostbit1
False
((0))
IsAccessorybit1
False
((0))
IsMeteredbit1
False
((0))
RequireMeteronServiceCallsbit1
False
((0))
Foreign Keys FK_ICModels_PriorityID_SCPriorities: [dbo].[SCPriorities].PriorityIDPriorityIDint4
True
PriorityWeightdecimal(14,4)9
False
((0))
UseSystemCBCAParamsbit1
False
((1))
CBNoDaysint4
False
((0))
CANoDaysint4
False
((0))
CANoCallsint4
False
((0))
MeterInstructionsvarchar(500)500
False
('')
Foreign Keys FK_ICModels_ModelCategoryID_ICModelCategories: [dbo].[ICModelCategories].ModelCategoryIDModelCategoryIDint4
False
Discontinuedbit1
False
((0))
Foreign Keys FK_ICModels_DBFileHeaderID_DBFileHeader: [dbo].[DBFileHeader].DBFileHeaderIDDBFileHeaderIDint4
False
((1))
Foreign Keys FK_ICModels_NoteID_ICModelNotes: [dbo].[ICModelNotes].NoteIDNoteIDint4
True
NoteFlagint4
False
((0))
IntroductionDatedatetime8
True
MfgDiscontinuedDatedatetime8
True
ServiceDiscontinuedDatedatetime8
True
cuTotalTargetRevenuemoney8
True
((0.00))
cuTotalTargetMonthlyVolumeint4
True
((0))
cuTotalTargetRevenuePerCopydecimal(18,4)9
True
((0.0000))
NoteCountint4
False
((0))
CBNoClicksdecimal(18,6)9
False
((0))
CANoClicksdecimal(18,6)9
False
((0))
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_ICModels: ModelIDPK_ICModelsModelID
True
80
NameColumns
FK_ICModels_DBFileHeaderID_DBFileHeaderDBFileHeaderID->[dbo].[DBFileHeader].[DBFileHeaderID]
FK_ICModels_MakeID_ICMakesMakeID->[dbo].[ICMakes].[MakeID]
FK_ICModels_ModelCategoryID_ICModelCategoriesModelCategoryID->[dbo].[ICModelCategories].[ModelCategoryID]
FK_ICModels_NoteID_ICModelNotesNoteID->[dbo].[ICModelNotes].[NoteID]
FK_ICModels_PriorityID_SCPrioritiesPriorityID->[dbo].[SCPriorities].[PriorityID]
FK_ICModels_ShTrackingConfigID_ShTrackingConfigsShTrackingConfigID->[dbo].[ShTrackingConfigs].[ShTrackingConfigID]
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