[dbo].[HARALLUSERS]

Property	Value
Row Count	3
Created	4:59:30 AM Monday, March 02, 2009
Last Modified	5:00:28 AM Monday, March 02, 2009

	Name	Data Type	Collation	Max Length (Bytes)	Default
$Indexes HARALLUSERS_OBJIDNAME: USROBJID\USERNAME$	USROBJID	int		4
$Indexes HARALLUSERS_OBJIDNAME: USROBJID\USERNAME$	USERNAME	varchar(128)	SQL_Latin1_General_CP1_CS_AS	128
	LOGINDATE	datetime		8
	LASTLOGIN	datetime		8
	LOGGEDIN	char(1)	SQL_Latin1_General_CP1_CI_AS	1
	REALNAME	varchar(128)	SQL_Latin1_General_CP1_CI_AS	128
	PHONENUMBER	varchar(32)	SQL_Latin1_General_CP1_CI_AS	32
	EXTENSION	varchar(8)	SQL_Latin1_General_CP1_CI_AS	8
	FAXNUMBER	varchar(32)	SQL_Latin1_General_CP1_CI_AS	32
	ENCRYPTPSSWD	varchar(32)	SQL_Latin1_General_CP1_CI_AS	32
	CREATIONTIME	datetime		8	(getutcdate())
	CREATORID	int		4
	MODIFIEDTIME	datetime		8	(getutcdate())
	MODIFIERID	int		4
	EMAIL	varchar(128)	SQL_Latin1_General_CP1_CI_AS	128
	NOTE	varchar(2000)	SQL_Latin1_General_CP1_CI_AS	2000

	Name	Columns	Unique
	HARALLUSERS_PK	USROBJID
	HARALLUSERS_OBJIDNAME	USROBJID, USERNAME

Name	Level 2 Type	Level 2 Name	Value
Caption			The HARALLUSERS table stores the object user information including active and deleted users.
Caption	COLUMN	CREATIONTIME	Time user was created
Caption	COLUMN	CREATORID	Object ID of user to create
Caption	COLUMN	EMAIL	Email address of user
Caption	COLUMN	ENCRYPTPSSWD	Encrypted password
Caption	COLUMN	EXTENSION	Phone extension of user
Caption	COLUMN	FAXNUMBER	Fax number of user
Caption	COLUMN	LASTLOGIN	Time of last login
Caption	COLUMN	LOGGEDIN	User logged in (Y/N)
Caption	COLUMN	LOGINDATE	Time of initial login
Caption	COLUMN	MODIFIEDTIME	Time user profile was modified
Caption	COLUMN	MODIFIERID	Object ID of user that last modified this user
Caption	COLUMN	NOTE	User-defined note
Caption	COLUMN	PHONENUMBER	Phone number of user
Caption	COLUMN	REALNAME	Real name of user
Caption	COLUMN	USERNAME	Name of user
Caption	COLUMN	USROBJID	Object ID of user

SQL Script

CREATE TABLE [dbo].[HARALLUSERS]
(
[USROBJID] [int] NOT NULL,
[USERNAME] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[LOGINDATE] [datetime] NULL,
[LASTLOGIN] [datetime] NULL,
[LOGGEDIN] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[REALNAME] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PHONENUMBER] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EXTENSION] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FAXNUMBER] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ENCRYPTPSSWD] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CREATIONTIME] [datetime] NOT NULL CONSTRAINT [DF__HARALLUSE__CREAT__00551192] DEFAULT (getutcdate()),
[CREATORID] [int] NOT NULL,
[MODIFIEDTIME] [datetime] NOT NULL CONSTRAINT [DF__HARALLUSE__MODIF__014935CB] DEFAULT (getutcdate()),
[MODIFIERID] [int] NOT NULL,
[EMAIL] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NOTE] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARALLUSERS] ADD CONSTRAINT [HARALLUSERS_PK] PRIMARY KEY CLUSTERED ([USROBJID]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [HARALLUSERS_OBJIDNAME] ON [dbo].[HARALLUSERS] ([USROBJID], [USERNAME]) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'Caption', N'The HARALLUSERS table stores the object user information including active and deleted users.', 'SCHEMA', N'dbo', 'TABLE', N'HARALLUSERS', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Time user was created', 'SCHEMA', N'dbo', 'TABLE', N'HARALLUSERS', 'COLUMN', N'CREATIONTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of user to create', 'SCHEMA', N'dbo', 'TABLE', N'HARALLUSERS', 'COLUMN', N'CREATORID'
GO
EXEC sp_addextendedproperty N'Caption', N'Email address of user', 'SCHEMA', N'dbo', 'TABLE', N'HARALLUSERS', 'COLUMN', N'EMAIL'
GO
EXEC sp_addextendedproperty N'Caption', N'Encrypted password', 'SCHEMA', N'dbo', 'TABLE', N'HARALLUSERS', 'COLUMN', N'ENCRYPTPSSWD'
GO
EXEC sp_addextendedproperty N'Caption', N'Phone extension of user', 'SCHEMA', N'dbo', 'TABLE', N'HARALLUSERS', 'COLUMN', N'EXTENSION'
GO
EXEC sp_addextendedproperty N'Caption', N'Fax number of user', 'SCHEMA', N'dbo', 'TABLE', N'HARALLUSERS', 'COLUMN', N'FAXNUMBER'
GO
EXEC sp_addextendedproperty N'Caption', N'Time of last login', 'SCHEMA', N'dbo', 'TABLE', N'HARALLUSERS', 'COLUMN', N'LASTLOGIN'
GO
EXEC sp_addextendedproperty N'Caption', N'User logged in (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARALLUSERS', 'COLUMN', N'LOGGEDIN'
GO
EXEC sp_addextendedproperty N'Caption', N'Time of initial login', 'SCHEMA', N'dbo', 'TABLE', N'HARALLUSERS', 'COLUMN', N'LOGINDATE'
GO
EXEC sp_addextendedproperty N'Caption', N'Time user profile was modified', 'SCHEMA', N'dbo', 'TABLE', N'HARALLUSERS', 'COLUMN', N'MODIFIEDTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of user that last modified this user', 'SCHEMA', N'dbo', 'TABLE', N'HARALLUSERS', 'COLUMN', N'MODIFIERID'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined note', 'SCHEMA', N'dbo', 'TABLE', N'HARALLUSERS', 'COLUMN', N'NOTE'
GO
EXEC sp_addextendedproperty N'Caption', N'Phone number of user', 'SCHEMA', N'dbo', 'TABLE', N'HARALLUSERS', 'COLUMN', N'PHONENUMBER'
GO
EXEC sp_addextendedproperty N'Caption', N'Real name of user', 'SCHEMA', N'dbo', 'TABLE', N'HARALLUSERS', 'COLUMN', N'REALNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Name of user', 'SCHEMA', N'dbo', 'TABLE', N'HARALLUSERS', 'COLUMN', N'USERNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of user', 'SCHEMA', N'dbo', 'TABLE', N'HARALLUSERS', 'COLUMN', N'USROBJID'
GO