Clients

This atble holds a single record per client for use when more than one client's printers are being monitored and the results stored in a single database (this could also be used to separate departments withing a company or university etc.)

Fields

  • Client Id - The unique identifier of this client record
  • Client Name - Th ehuman readable client name to use on printer reports etc.

Code

CREATE TABLE [Clients](
	[Client Id] [uniqueidentifier] NOT NULL CONSTRAINT [DF_Clients_Client Id]  DEFAULT (newid()),
	[Client Name] [varchar](200) NULL,
 CONSTRAINT [PK_Clients] PRIMARY KEY CLUSTERED 
(
	[Client Id] ASC
)
GO

Last edited Dec 7, 2009 at 7:47 PM by Merrion, version 1

Comments

No comments yet.