Tables [dbo].[CallInterruptions]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:57:03 AM Thursday, March 21, 2019
Last Modified12:57:03 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow NullsIdentity
IDint4
False
LaborIDint4
False
Namevarchar(50)50
True
Descriptionvarchar(255)255
True
Hoursfloat8
False
DetailIDint4
False
1 - 1
DispatchHistoryIDint4
True
Dispatchdatetime8
True
CREATE TABLE [dbo].[CallInterruptions]
(
[ID] [int] NOT NULL,
[LaborID] [int] NOT NULL,
[Name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Hours] [float] NOT NULL,
[DetailID] [int] NOT NULL IDENTITY(1, 1),
[DispatchHistoryID] [int] NULL,
[Dispatch] [datetime] NULL
) ON [PRIMARY]
GO