Database – Customer Reference Entity (customer_reference_entity)

Description

This holds information on customer references. For information on how to add or edit customer references through the API, see API - Customer References.

Column

Data Type

Column Info

Value Notes

Other

id

int(11)

The id of the entity

name

varchar(255)

Entity name

relation

char(100)

Customer relation code

customerReference.relation.brother

customerReference.relation.coworker

customerReference.relation.daughter

customerReference.relation.father

customerReference.relation.friend

customerReference.relation.husband

customerReference.relation.sister

customerReference.relation.son

customerReference.relation.wife

primary_phone

char(20)

Primary phone number

secondary_phone

char(20)

Secondary Phone Number

address_id

int(11)

ID of associated address

customer_id

int(11)

ID for the customer

created

timestamp

Timestamp of when the entity was created

lastUpdated

timestamp

Timestamp of when the entity was last updated

active

tinyint(4)

Whether or not the entity is active

1 - yes, 0 - no

deleted

tinyint(4)

Whether or not the entity was deleted

1 - yes, 0 - no


How did we do?


Powered by HelpDocs (opens in a new tab)