Tables [dbo].[SCHReportLabors]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:59:19 AM Thursday, March 21, 2019
Last Modified1:15:06 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_SCHReportLabors: ReportID\DetailIDForeign Keys FK_SCHReportLabors_ReportID_SCHReports: [dbo].[SCHReports].ReportIDReportIDint4
False
Cluster Primary Key PK_SCHReportLabors: ReportID\DetailIDDetailIDint4
False
Foreign Keys FK_SCHReportLabors_TechnicianID_SCTechnicians: [dbo].[SCTechnicians].TechnicianIDTechnicianIDint4
True
Technicianvarchar(255)255
True
Assistbit1
True
((0))
DispatchDatedatetime8
True
ArrivalDatedatetime8
True
DepartureDatedatetime8
True
TravelHoursfloat8
True
BeginOdometerdecimal(16,1)9
True
EndOdometerdecimal(16,1)9
True
Rolloverbit1
True
Mileagefloat8
True
LaborHoursfloat8
True
LaborRatemoney8
True
OvertimeHoursfloat8
True
OvertimeRatemoney8
True
Amountmoney8
True
((0))
BurdenRatemoney8
True
((0))
Costmoney8
True
((0))
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCHReportLabors: ReportID\DetailIDPK_SCHReportLaborsReportID, DetailID
True
80
NameColumns
FK_SCHReportLabors_ReportID_SCHReportsReportID->[dbo].[SCHReports].[ReportID]
FK_SCHReportLabors_TechnicianID_SCTechniciansTechnicianID->[dbo].[SCTechnicians].[TechnicianID]
CREATE TABLE [dbo].[SCHReportLabors]
(
[ReportID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[TechnicianID] [int] NULL,
[Technician] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Assist] [bit] NULL CONSTRAINT [DF_SCHReportLabors_Assist] DEFAULT ((0)),
[DispatchDate] [datetime] NULL,
[ArrivalDate] [datetime] NULL,
[DepartureDate] [datetime] NULL,
[TravelHours] [float] NULL,
[BeginOdometer] [decimal] (16, 1) NULL,
[EndOdometer] [decimal] (16, 1) NULL,
[Rollover] [bit] NULL,
[Mileage] [float] NULL,
[LaborHours] [float] NULL,
[LaborRate] [money] NULL,
[OvertimeHours] [float] NULL,
[OvertimeRate] [money] NULL,
[Amount] [money] NULL CONSTRAINT [DF_SCHReportLabors_Amount] DEFAULT ((0)),
[BurdenRate] [money] NULL CONSTRAINT [DF_SCHReportLabors_BurdenRate] DEFAULT ((0)),
[Cost] [money] NULL CONSTRAINT [DF_SCHReportLabors_Cost] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCHReportLabors] ADD CONSTRAINT [PK_SCHReportLabors] PRIMARY KEY CLUSTERED  ([ReportID], [DetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCHReportLabors] ADD CONSTRAINT [FK_SCHReportLabors_ReportID_SCHReports] FOREIGN KEY ([ReportID]) REFERENCES [dbo].[SCHReports] ([ReportID])
GO
ALTER TABLE [dbo].[SCHReportLabors] ADD CONSTRAINT [FK_SCHReportLabors_TechnicianID_SCTechnicians] FOREIGN KEY ([TechnicianID]) REFERENCES [dbo].[SCTechnicians] ([TechnicianID])
GO