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