Tables [dbo].[CallHistory]
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
CallIDint4
False
CallTypeIDint4
True
Descriptionvarchar(255)255
True
CallDatedatetime8
True
Technicianvarchar(50)50
True
Remarksvarchar(1024)1024
True
EquipmentIDint4
True
IDint4
False
1 - 1
ProblemCodesvarchar(2000)2000
True
RepairCodesvarchar(2000)2000
True
Materialsvarchar(2000)2000
True
CREATE TABLE [dbo].[CallHistory]
(
[CallID] [int] NOT NULL,
[CallTypeID] [int] NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CallDate] [datetime] NULL,
[Technician] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EquipmentID] [int] NULL,
[ID] [int] NOT NULL IDENTITY(1, 1),
[ProblemCodes] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RepairCodes] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Materials] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO