Tables [dbo].[Labor]
PropertyValue
HeapTrue
Row Count (~)0
Created12:57:56 AM Thursday, March 21, 2019
Last Modified1:04:24 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow NullsDefault
LaborIDint4
False
CallIDint4
True
Arrivaldatetime8
True
Departuredatetime8
True
OdometerStartdecimal(16,1)9
True
OdometerEnddecimal(16,1)9
True
TravelHoursfloat8
True
ModifiedDatedatetime8
False
(getdate())
CreateDatedatetime8
False
(getdate())
IsActivebit1
False
((1))
Deletedbit1
False
DispatchHistoryIDint4
True
Dispatchdatetime8
True
ExistsOnServerbit1
False
CREATE TABLE [dbo].[Labor]
(
[LaborID] [int] NOT NULL,
[CallID] [int] NULL,
[Arrival] [datetime] NULL,
[Departure] [datetime] NULL,
[OdometerStart] [decimal] (16, 1) NULL,
[OdometerEnd] [decimal] (16, 1) NULL,
[TravelHours] [float] NULL,
[ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_Labor_ModifiedDate] DEFAULT (getdate()),
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_Labor_CreateDate] DEFAULT (getdate()),
[IsActive] [bit] NOT NULL CONSTRAINT [DF_Labor_IsActive] DEFAULT ((1)),
[Deleted] [bit] NOT NULL,
[DispatchHistoryID] [int] NULL,
[Dispatch] [datetime] NULL,
[ExistsOnServer] [bit] NOT NULL
) ON [PRIMARY]
GO