Table: Customer Reference Entity

Table: Customer Reference Entity

This holds information about references for customers.

Column Data Type Column Info Value Notes Other
idint(11)The id of the entity
namevarchar(255)Entity name
relationchar(100)Customer relation codecustomerReference.relation.*
primary_phonechar(20)Primary phone number
secondary_phonechar(20)Secondary Phone Number
address_idint(11)ID of associated address
customer_idint(11)ID for the customer
createdtimestampTimestamp of when the entity was created
lastUpdatedtimestampTimestamp of when the entity was last updated
activetinyint(4)Whether or not the entity is active1 - yes, 0 - no
deletedtinyint(4)Whether or not the entity was deleted1 - yes, 0 - no

< Back to List