Tables [dbo].[SCReportMaterialWarranties]
PropertyValue
Row Count (~)0
Created1:00:18 AM Thursday, March 21, 2019
Last Modified1:00:18 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_SCReportMaterialWarranties: SCReportMaterialWarrantyIDSCReportMaterialWarrantyIDint4
False
1 - 1
ReportIDint4
False
DetailIDint4
False
WarrantyCodeIDint4
False
ItemWarrantyTypeIDint4
False
MostRecentActualdecimal(18,6)9
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_SCReportMaterialWarranties: SCReportMaterialWarrantyIDPK_SCReportMaterialWarrantiesSCReportMaterialWarrantyID
True
80
CREATE TABLE [dbo].[SCReportMaterialWarranties]
(
[SCReportMaterialWarrantyID] [int] NOT NULL IDENTITY(1, 1),
[ReportID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[WarrantyCodeID] [int] NOT NULL,
[ItemWarrantyTypeID] [int] NOT NULL,
[MostRecentActual] [decimal] (18, 6) 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].[SCReportMaterialWarranties] ADD CONSTRAINT [PK_SCReportMaterialWarranties] PRIMARY KEY CLUSTERED  ([SCReportMaterialWarrantyID]) ON [PRIMARY]
GO