Customer Account (CustomerAccount) table
The Customer Account (CustomerAccounts) table is part of the mrUserData database. The table holds information regarding each customer account: customer account ID, displayed name, account description, and so on.
Structure
CREATE TABLE [dbo].[CustomerAccount](
[CustomerAccountID] [uniqueidentifier] NOT NULL,
[CustomerAccountName] [nvarchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DisplayName] [nvarchar](128) NOT NULL,
[CreatedOn] [datetime] NULL,
[CreatedBy] [nvarchar](250) NULL,
[IsDisabled] [bit] NULL,
[Description] [nvarchar](250) NULL
CONSTRAINT [PK_CustomerAccount] PRIMARY KEY CLUSTERED
(
[CustomerAccountID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
Columns
CustomerAccountID
The unique identifier for the customer account.
CustomerAccountName
The customer account name.
DisplayName
The customer account display name.
CreatedOn
When the customer account was created.
CreatedBy
The user who created the customer account.
IsDisabled
The customer account status.
Description
The customer account description.
See also