CREATE TABLE [dbo].[ShAgents]
(
[AgentID] [int] NOT NULL,
[AgentNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[LastName] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FirstName] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MiddleName] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PrefName] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PrefFullName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SSN] [varchar] (11) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Address] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[City] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[State] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Zip] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Country] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[HomePhone] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[WorkPhone] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Email] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Active] [bit] NOT NULL,
[Locks] [int] NOT NULL CONSTRAINT [DF_ShAgents_Locks] DEFAULT ((0)),
[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_ShAgents_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_ShAgents_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[BranchID] [int] NOT NULL,
[UserID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsManager] [bit] NOT NULL CONSTRAINT [DF_ShAgents_IsManager] DEFAULT ((0)),
[ManagerID] [int] NULL,
[ShowInAllBranches] [bit] NOT NULL CONSTRAINT [DF_SHAgents_ShowInAllBranches] DEFAULT ((0)),
[NoteID] [int] NULL,
[NoteFlag] [int] NOT NULL CONSTRAINT [DF_SHAgents_NoteFlag] DEFAULT ((0)),
[ServiceHourCodeID] [int] NULL,
[ShTrackingConfigID] [int] NULL,
[BnSSN] [varbinary] (32) NOT NULL CONSTRAINT [DF_SHAgents_BnSSN] DEFAULT ((0)),
[SSCrpType] [tinyint] NOT NULL CONSTRAINT [DF_SHAgents_SSCrpType] DEFAULT ((0)),
[NoteCount] [int] NOT NULL CONSTRAINT [DF_ShAgents_NoteCount] DEFAULT ((0)),
[IsQueue] [bit] NOT NULL CONSTRAINT [DF_SHAgents_IsQueue] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ShAgents] ADD CONSTRAINT [PK_ShAgents] PRIMARY KEY CLUSTERED ([AgentID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ShAgents] ADD CONSTRAINT [FK_ShAgents_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[ShAgents] ADD CONSTRAINT [FK_ShAgents_ManagerID_ShAgents] FOREIGN KEY ([ManagerID]) REFERENCES [dbo].[ShAgents] ([AgentID])
GO
ALTER TABLE [dbo].[ShAgents] ADD CONSTRAINT [FK_SHAgents_NoteID_SHAgentNotes] FOREIGN KEY ([NoteID]) REFERENCES [dbo].[SHAgentNotes] ([NoteID])
GO
ALTER TABLE [dbo].[ShAgents] ADD CONSTRAINT [FK_ShAgents_ServiceHourCodeID_SHServiceHourCodes] FOREIGN KEY ([ServiceHourCodeID]) REFERENCES [dbo].[SHServiceHourCodes] ([ServiceHourCodeID])
GO
ALTER TABLE [dbo].[ShAgents] ADD CONSTRAINT [FK_ShAgents_ShTrackingConfigID_ShTrackingConfigs] FOREIGN KEY ([ShTrackingConfigID]) REFERENCES [dbo].[ShTrackingConfigs] ([ShTrackingConfigID])
GO
ALTER TABLE [dbo].[ShAgents] ADD CONSTRAINT [FK_ShAgents_UserID_CoUsers] FOREIGN KEY ([UserID]) REFERENCES [dbo].[CoUsers] ([UserID])
GO