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 |