customer_properties

Owned by Sylvain Paillard
Nov 19, 2020
1 min read

This table represents the content of the customer properties. The customer properties represent calculated data for each customer which should be loaded in the real-time database. By filling this table, the system will will automatically upload and create/update your customer properties in the real-time database.

Field name

Type

Mode

Description

Field name

Type

Mode

Description

customer_id

STRING

REQUIRED

PK - the customer id

property_name

STRING

REQUIRED

PK - the customer property name

property_value

STRING

REQUIRED

PK - the customer property value

confidence

INTEGER

NULLABLE

(optional) a int value giving a confidence value from 0 to 10000

origin

STRING

REQUIRED

please provide a unique key defining the origin system of these data, not used, but useful for debugging / monitoring

creation_tm

TIMESTAMP

REQUIRED

please provide timestampe of the initial creation of this row

last_modified_tm

TIMESTAMP

REQUIRED

please provide timestampe of the last modification of this row