Tables [dbo].[SCContractItemLimits]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:59:13 AM Thursday, March 21, 2019
Last Modified1:15:59 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK__SCContra__10CB719147C499B0: ContractItemLimitIDContractItemLimitIDint4
False
1 - 1
Foreign Keys FK_SCContractItemLimits_ContractID_SCContracts: [dbo].[SCContracts].ContractIDContractIDint4
False
Foreign Keys FK_SCContractItemLimits_ContractDetailID_SCContractDetails: [dbo].[SCContractDetails].ContractDetailIDContractDetailIDint4
True
RelatedItemIDint4
False
LimitTypeint4
False
QuantityLimitdecimal(18,6)9
True
UsageLimitdecimal(18,6)9
True
QuantityUseddecimal(18,6)9
True
QuantityAllocateddecimal(18,6)9
True
Lockedbit1
False
((0))
CreatorIDvarchar(8)8
False
UpdatorIDvarchar(8)8
False
CreateDatedatetime8
False
LastUpdatedatetime8
False
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK__SCContra__10CB719147C499B0: ContractItemLimitIDPK__SCContra__10CB719147C499B0ContractItemLimitID
True
80
NameColumns
FK_SCContractItemLimits_ContractDetailID_SCContractDetailsContractDetailID->[dbo].[SCContractDetails].[ContractDetailID]
FK_SCContractItemLimits_ContractID_SCContractsContractID->[dbo].[SCContracts].[ContractID]
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