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