persona_property_history

Owned by Sylvain Paillard
Nov 19, 2020
1 min read

All historic persona properties

Field name

Type

Mode

Description

Field name

Type

Mode

Description

persona_id

STRING

REQUIRED

PK

property_name

STRING

REQUIRED

PK

property_value

STRING

REQUIRED

PK, multiple values for a property are supported

property_ts

TIMESTAMP

REQUIRED

PK, timestamp of property extraction from source

property_action_cd

STRING

REQUIRED

C=CREATE,U=UPDATE,D=DELETE

creation_tm

DATETIME

REQUIRED

technical field

client_id

INTEGER

REQUIRED

technical field

src_sys_id

INTEGER

REQUIRED

technical field