Table customers

From Zen Cart(tm) Wiki
Jump to: navigation, search

Database Version

1.3.5


Description

Stores all the main customer information.


Table Details

Primary Key

customers_id

Indexed Fields

customers_email_address
customers_referral
customers_group_pricing
customers_nick
customers_newsletter


Columns

customers_id Primary Key

A unique, auto incremented value, to identify each customer record.
Type: int(11)
Null: No
Default:
Extra: auto_increment


customers_gender

The gender of the customer. Can be set to m (male) or f (female).
Type: char(1)
Null: No
Default:


customers_firstname

The first name of the customer.
Type: varchar(32)
Null: No
Default:


customers_lastname

The last name of the customer.
Type: varchar(32)
Null: No
Default:


customers_dob

The date of birth of the customer.
Type: datetime
Null: No
Default: 0001-01-01 00:00:00


customers_email_address Index

The email address of the customer.
Type: varchar(96)
Null: No
Default:


customers_nick Index

The nickname (for the purposes of phpBB linkage) of the customer.
Type: varchar(96)
Null: No
Default:


customers_default_address_id

The default address book entry to use for this customer.
Type: int(11)
Null: No
Default: 0


customers_telephone

The telephone number of the customer.
Type: varchar(32)
Null: No
Default:


customers_fax

The fax number of the customer.
Type: varchar(32)
Null: Yes
Default: NULL


customers_password

The password of the customer (stored encrypted).
Type: varchar(40)
Null: No
Default:


customers_newsletter Index

Is the customer signed up for the newsletter? Can be set to 0 (no) or 1 (yes).
Type: char(1)
Null: Yes
Default: NULL


customers_group_pricing Index

The group (if any) that the customer belongs to for group pricing purposes.
Type: int(11)
Null: No
Default: 0


customers_email_format

What format will the customer receive emails in. Can be set to TEXT or HTML.
Type: varchar(4)
Null: No
Default: TEXT


customers_authorization

What level of authorization does the customer have?
Options:
  • 0 = Approved
  • 1 = Pending Approval - Must be Authorized to Browse
  • 2 = Pending Approval - May Browse But Sees No Prices
  • 3 = Pending Approval - May browse with prices but may not buy
Type: int(1)
Null: No
Default: 0


customers_referral Index

The referral-code set for how this customer was acquired.
Depending on system configuration, this information may be entered by the customer, by the administrator, or set by the first coupon-code redeemed by the customer.
Type: varchar(32)
Null: No
Default:


Default Entries

customers_id: 1
customers_gender: m
customers_firstname: Bill
customers_lastname: Smith
customers_dob: 2001-01-01 00:00:00
customers_email_address: root@localhost
customers_nick:
customers_default_address_id: 1
customers_telephone: 12345
customers_fax:
customers_password: d95e8fa7f20a009372eb3477473fcd34:1c
customers_newsletter: 0
customers_group_pricing: 0
customers_email_format: TEXT
customers_authorization: 0
customers_referral: