CREATE TABLE [dbo].[SCQContractMeterGroups]
(
[QContractMeterGroupID] [int] NOT NULL IDENTITY(1, 1),
[QContractMeterGroup] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[QContractID] [int] NOT NULL,
[CoveredCopies] [decimal] (14, 4) NULL,
[ApplyToExpiration] [bit] NULL,
[OverageTypeID] [int] NULL,
[UseOverages] [bit] NOT NULL,
[OverageMethodID] [int] NULL,
[OverageRate] [decimal] (18, 6) NOT NULL,
[CreditRate] [decimal] (18, 6) NOT NULL,
[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,
[LastUpdate] [datetime] NOT NULL,
[timestamp] [timestamp] NULL,
[BillMeterGroupBaseAmount] [bit] NOT NULL CONSTRAINT [DF_SCQContractMeterGroups_BillMeterGroupBaseAmount] DEFAULT ((0)),
[BaseRatePerCopy] [decimal] (18, 6) NULL,
[RoundBaseAmountDigits] [int] NOT NULL CONSTRAINT [DF_SCQContractMeterGroups_RoundBaseAmountDigits] DEFAULT ((2)),
[BaseAmount] [money] NULL,
[DistCodeID] [int] NULL,
[OverageBillingCycleID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQContractMeterGroups] ADD CONSTRAINT [PK_SCQContractMeterGroups] PRIMARY KEY CLUSTERED ([QContractMeterGroupID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQContractMeterGroups] ADD CONSTRAINT [FK_SCQContractMeterGroups_OverageBillingCycleID_SCBillingCycles] FOREIGN KEY ([OverageBillingCycleID]) REFERENCES [dbo].[SCBillingCycles] ([BillingCycleID])
GO
ALTER TABLE [dbo].[SCQContractMeterGroups] ADD CONSTRAINT [FK_SCQContractMeterGroups_OverageMethodID_SCOverageMethods] FOREIGN KEY ([OverageMethodID]) REFERENCES [dbo].[SCOverageMethods] ([OverageMethodID])
GO
ALTER TABLE [dbo].[SCQContractMeterGroups] ADD CONSTRAINT [FK_SCQContractMeterGroups_OverageTypeID_SCContractOverageTypes] FOREIGN KEY ([OverageTypeID]) REFERENCES [dbo].[SCContractOverageTypes] ([ContractOverageTypeID])
GO
ALTER TABLE [dbo].[SCQContractMeterGroups] ADD CONSTRAINT [FK_SCQContractMeterGroups_QContractID_SCQContracts] FOREIGN KEY ([QContractID]) REFERENCES [dbo].[SCQContracts] ([QContractID])
GO