Interviewer - Server > Administration and maintenance > Databases > Customer Account (CustomerAccount) table
 
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), and has the following 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
The customer account creation DateTime.
CreatedBy
The user who created the customer account.
IsDisabled
The customer account status.
Description
The customer account description.
See also
Databases