Tables [dbo].[SCQReportMaterialWarranties]
PropertyValue
Row Count (~)0
Created1:00:09 AM Thursday, March 21, 2019
Last Modified1:00:09 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_SCQReportMaterialWarranties: SCQReportMaterialWarrantyIDSCQReportMaterialWarrantyIDint4
False
1 - 1
CallIDint4
False
DetailIDint4
False
WarrantyIDint4
False
ItemWarrantyTypeIDint4
False
WarrantyMeterTypeIDint4
True
PartEndDatedatetime8
True
PartEndMeterdecimal(18,6)9
True
LaborEndDatedatetime8
True
LaborEndMeterdecimal(18,6)9
True
WarrantyEndDatedatetime8
True
WarrantyEndMeterdecimal(18,6)9
True
timestamptimestamp8
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCQReportMaterialWarranties: SCQReportMaterialWarrantyIDPK_SCQReportMaterialWarrantiesSCQReportMaterialWarrantyID
True
80
CREATE TABLE [dbo].[SCQReportMaterialWarranties]
(
[SCQReportMaterialWarrantyID] [int] NOT NULL IDENTITY(1, 1),
[CallID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[WarrantyID] [int] NOT NULL,
[ItemWarrantyTypeID] [int] NOT NULL,
[WarrantyMeterTypeID] [int] NULL,
[PartEndDate] [datetime] NULL,
[PartEndMeter] [decimal] (18, 6) NULL,
[LaborEndDate] [datetime] NULL,
[LaborEndMeter] [decimal] (18, 6) NULL,
[WarrantyEndDate] [datetime] NULL,
[WarrantyEndMeter] [decimal] (18, 6) NULL,
[timestamp] [timestamp] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQReportMaterialWarranties] ADD CONSTRAINT [PK_SCQReportMaterialWarranties] PRIMARY KEY CLUSTERED  ([SCQReportMaterialWarrantyID]) ON [PRIMARY]
GO