CREATE TABLE [dbo].[Users]
(
[userID] [int] NOT NULL IDENTITY(-1, 1),
[firstName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[lastName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[email] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[company] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[isGuest] [int] NULL CONSTRAINT [DF__Users__isGuest__023D5A04] DEFAULT ((1)),
[securityGroup] [int] NULL CONSTRAINT [DF__Users__securityG__03317E3D] DEFAULT ((0)),
[hasPersonalQueue] [int] NULL CONSTRAINT [DF__Users__hasPerson__0425A276] DEFAULT ((0)),
[personalQueueID] [int] NULL,
[screenName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[isActive] [int] NOT NULL CONSTRAINT [DF__Users__isActive__0519C6AF] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Users] ADD CONSTRAINT [pk_users] PRIMARY KEY CLUSTERED ([userID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Users] ADD CONSTRAINT [fk_users_queues] FOREIGN KEY ([personalQueueID]) REFERENCES [dbo].[Queues] ([queueID])
GO
[dbo].[Users]
![Foreign Keys fk_users_queues: [dbo].[Queues].personalQueueID](../../Images/fk.gif)
