CREATE TABLE [dbo].[SCContractItemLimits]
(
[ContractItemLimitID] [int] NOT NULL IDENTITY(1, 1),
[ContractID] [int] NOT NULL,
[ContractDetailID] [int] NULL,
[RelatedItemID] [int] NOT NULL,
[LimitType] [int] NOT NULL,
[QuantityLimit] [decimal] (18, 6) NULL,
[UsageLimit] [decimal] (18, 6) NULL,
[QuantityUsed] [decimal] (18, 6) NULL,
[QuantityAllocated] [decimal] (18, 6) NULL,
[Locked] [bit] NOT NULL CONSTRAINT [DF_SCContractItemLimits_Locked] DEFAULT ((0)),
[CreatorID] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL,
[LastUpdate] [datetime] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCContractItemLimits] ADD CONSTRAINT [PK__SCContra__10CB719147C499B0] PRIMARY KEY CLUSTERED ([ContractItemLimitID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCContractItemLimits] ADD CONSTRAINT [FK_SCContractItemLimits_ContractDetailID_SCContractDetails] FOREIGN KEY ([ContractDetailID]) REFERENCES [dbo].[SCContractDetails] ([ContractDetailID])
GO
ALTER TABLE [dbo].[SCContractItemLimits] ADD CONSTRAINT [FK_SCContractItemLimits_ContractID_SCContracts] FOREIGN KEY ([ContractID]) REFERENCES [dbo].[SCContracts] ([ContractID])
GO