CREATE TABLE [dbo].[SCCalls]
(
[CallID] [int] NOT NULL,
[WorkOrderID] [int] NOT NULL,
[CallNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[EquipmentID] [int] NULL,
[CustomerID] [int] NOT NULL,
[BillToID] [int] NOT NULL,
[ContractID] [int] NULL,
[BillCodeID] [int] NULL,
[Caller] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Date] [datetime] NOT NULL,
[ReqDate] [datetime] NOT NULL,
[EstStartDate] [datetime] NULL,
[PONumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TechnicianID] [int] NOT NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CallTypeID] [int] NOT NULL,
[EstDuration] [int] NOT NULL,
[PriorityID] [int] NOT NULL,
[Notes] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Status] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CancelCodeID] [int] NULL,
[Dispatched] [int] NOT NULL CONSTRAINT [DF_SCCalls_Dispatched] DEFAULT ((0)),
[AddressStreet] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCCalls_AddressStreet] DEFAULT (''),
[AddressCity] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCCalls_AddressCity] DEFAULT (''),
[AddressState] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCCalls_AddressState] DEFAULT (''),
[AddressZip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCCalls_AddressZip] DEFAULT (''),
[AddressCountry] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCCalls_AddressCountry] DEFAULT (''),
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_SCCalls_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCCalls_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[OnHoldCodeID] [int] NULL,
[OnHoldReleaseDate] [datetime] NULL,
[OnHoldReleaserID] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResponseCalcOverrideDate] [datetime] NULL,
[RescheduledCallID] [int] NULL,
[CloseDate] [datetime] NULL,
[CancelDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCCalls_CancelDescription] DEFAULT (''),
[Callback] [bit] NOT NULL CONSTRAINT [DF_SCCalls_Callback] DEFAULT ((0)),
[CallBackOverriddenByID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCCalls_CallBackOverriddenByID] DEFAULT (''),
[CallBackCallID] [int] NULL,
[BranchID] [int] NOT NULL,
[JobID] [int] NULL,
[UntilDueLastCalcDate] [datetime] NULL,
[StartPriorityID] [int] NULL,
[DesiredResponseTime] [int] NULL,
[UntilDue] [int] NULL,
[CallAlert] [bit] NOT NULL CONSTRAINT [DF_SCCalls_CallAlert] DEFAULT ((0)),
[CallAlertOverriddenByID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCCalls_CallAlertOverriddenByID] DEFAULT (''),
[CheckOutTime] [datetime] NULL,
[BadSynchData] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Message] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DBFileHeaderID] [int] NOT NULL CONSTRAINT [DF_SCCalls_DBFileHeaderID] DEFAULT ((1)),
[EquipDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EquipSerialNumber] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EquipModelID] [int] NULL,
[AutoGenerateEquipOnInvoice] [bit] NOT NULL CONSTRAINT [DF_SCCalls_AutoGenerateEquipOnInvoice] DEFAULT ((0)),
[CustomerTimeZoneCodeID] [int] NULL,
[CustomerTimeZoneBias] [decimal] (14, 4) NULL,
[ServiceHourCodeID] [int] NOT NULL CONSTRAINT [DF_SCCalls_ServiceHourCodeID] DEFAULT ((1)),
[DayBeginTime] [datetime] NULL,
[DayEndTime] [datetime] NULL,
[MasterCallID] [int] NULL,
[ServerTimezoneBias] [decimal] (14, 4) NULL,
[CustomerTimezoneDST] [bit] NOT NULL CONSTRAINT [DF_SCCalls_CustomerTimezoneDST] DEFAULT ((0)),
[NoteID] [int] NULL,
[NoteFlag] [int] NOT NULL CONSTRAINT [DF_SCCalls_NoteFlag] DEFAULT ((0)),
[SendInvoiceToTech] [int] NOT NULL CONSTRAINT [DF_SCCalls_SendInvoiceToTech] DEFAULT ((0)),
[CallOrder] [int] NOT NULL CONSTRAINT [DF_SCCalls_CallOrder] DEFAULT ((-1)),
[CallerContactID] [int] NULL,
[DependentCallID] [int] NULL,
[NoteCount] [int] NOT NULL CONSTRAINT [DF_SCCalls_NoteCount] DEFAULT ((0)),
[ItemID] [int] NULL,
[ContractDetailID] [int] NULL,
[LocationID] [int] NOT NULL,
[SLACodeID] [int] NULL,
[ReportHoldID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [PK_SCCalls] PRIMARY KEY CLUSTERED ([CallID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_BillCodeID_SCBillCodes] FOREIGN KEY ([BillCodeID]) REFERENCES [dbo].[SCBillCodes] ([BillCodeID])
GO
ALTER TABLE [dbo].[SCCalls] WITH NOCHECK ADD CONSTRAINT [FK_SCCalls_BillToID_ARCustomers] FOREIGN KEY ([BillToID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_CallerContactID_CMContacts] FOREIGN KEY ([CallerContactID]) REFERENCES [dbo].[CMContacts] ([ContactID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_CallTypeID_SCCallTypes] FOREIGN KEY ([CallTypeID]) REFERENCES [dbo].[SCCallTypes] ([CallTypeID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_CancelCodeID_SCCancelCodes] FOREIGN KEY ([CancelCodeID]) REFERENCES [dbo].[SCCancelCodes] ([CancelCodeID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_ContractDetailID_SCContractDetails] FOREIGN KEY ([ContractDetailID]) REFERENCES [dbo].[SCContractDetails] ([ContractDetailID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_ContractID_SCContracts] FOREIGN KEY ([ContractID]) REFERENCES [dbo].[SCContracts] ([ContractID])
GO
ALTER TABLE [dbo].[SCCalls] WITH NOCHECK ADD CONSTRAINT [FK_SCCalls_CustomerID_ARCustomers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_CustomerTimeZoneCodeID_SHTimeZoneCodes] FOREIGN KEY ([CustomerTimeZoneCodeID]) REFERENCES [dbo].[SHTimeZoneCodes] ([TimeZoneCodeID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_DBFileHeaderID_DBFileHeader] FOREIGN KEY ([DBFileHeaderID]) REFERENCES [dbo].[DBFileHeader] ([DBFileHeaderID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_DependentCallID_SCCalls] FOREIGN KEY ([DependentCallID]) REFERENCES [dbo].[SCCalls] ([CallID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_EquipmentID_SCEquipments] FOREIGN KEY ([EquipmentID]) REFERENCES [dbo].[SCEquipments] ([EquipmentID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_EquipModelID_ICModels] FOREIGN KEY ([EquipModelID]) REFERENCES [dbo].[ICModels] ([ModelID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_ItemID_ICItems] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems] ([ItemID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_JobID_ICJobs] FOREIGN KEY ([JobID]) REFERENCES [dbo].[ICJobs] ([JobID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_LocationID_ARCustomers] FOREIGN KEY ([LocationID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_MasterCallID_SCCalls] FOREIGN KEY ([MasterCallID]) REFERENCES [dbo].[SCCalls] ([CallID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_NoteID_SCCallNotes] FOREIGN KEY ([NoteID]) REFERENCES [dbo].[SCCallNotes] ([NoteID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_OnHoldCodeID_ShOnHoldCodes] FOREIGN KEY ([OnHoldCodeID]) REFERENCES [dbo].[ShOnHoldCodes] ([OnHoldCodeID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_PriorityID_SCPriorities] FOREIGN KEY ([PriorityID]) REFERENCES [dbo].[SCPriorities] ([PriorityID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_RescheduledCallID_SCCalls] FOREIGN KEY ([RescheduledCallID]) REFERENCES [dbo].[SCCalls] ([CallID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_ServiceHourCodeID_SHServiceHourCodes] FOREIGN KEY ([ServiceHourCodeID]) REFERENCES [dbo].[SHServiceHourCodes] ([ServiceHourCodeID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_SLACodeID_SCSLACodes] FOREIGN KEY ([SLACodeID]) REFERENCES [dbo].[SCSLACodes] ([SLACodeID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_StartPriorityID_SCPriorities] FOREIGN KEY ([StartPriorityID]) REFERENCES [dbo].[SCPriorities] ([PriorityID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_TechnicianID_SCTechnicians] FOREIGN KEY ([TechnicianID]) REFERENCES [dbo].[SCTechnicians] ([TechnicianID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_WorkOrderID_SCWorkOrders] FOREIGN KEY ([WorkOrderID]) REFERENCES [dbo].[SCWorkOrders] ([WorkOrderID])
GO