Tables [dbo].[ICTransactionWarrantyVoids]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:57:43 AM Thursday, March 21, 2019
Last Modified1:03:57 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_ICTransactionWarrantyVoids: ICTransactionWarrantyVoidIDICTransactionWarrantyVoidIDint4
False
1 - 1
TransactionWarrantyGroupIDint4
False
Quantityint4
False
((0))
IsVoidbit1
False
((0))
VoidingReasonvarchar(255)255
False
('')
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_ICTransactionWarrantyVoids: ICTransactionWarrantyVoidIDPK_ICTransactionWarrantyVoidsICTransactionWarrantyVoidID
True
80
CREATE TABLE [dbo].[ICTransactionWarrantyVoids]
(
[ICTransactionWarrantyVoidID] [int] NOT NULL IDENTITY(1, 1),
[TransactionWarrantyGroupID] [int] NOT NULL,
[Quantity] [int] NOT NULL CONSTRAINT [DF_ICTransactionWarrantyVoids_Quantity] DEFAULT ((0)),
[IsVoid] [bit] NOT NULL CONSTRAINT [DF_ICTransactionWarrantyVoids_IsVoid] DEFAULT ((0)),
[VoidingReason] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICTransactionWarrantyVoids_VoidingReason] DEFAULT ('')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICTransactionWarrantyVoids] ADD CONSTRAINT [PK_ICTransactionWarrantyVoids] PRIMARY KEY CLUSTERED  ([ICTransactionWarrantyVoidID]) ON [PRIMARY]
GO