Messageinbound Datakeys Table Schema (messageinbound_datakeys)


Description

Inbound Message data item secret keys.

messageinbound_datakeys table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
handler bigint 10 null
messageinbound_handlers.id messdata_han2_fk R

The handler that this key belongs to.

datavalue bigint 10 null

The integer value of the data item that this key belongs to.

datakey varchar 64 null

The secret key for this data item.

timecreated bigint 10 null

The time that the data key was created.

expires bigint 10 null

The expiry time of this key.

Table contained -1 rows

messageinbound_datakeys table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
messdata_han_ix Performance Asc handler
messdata_handat_uix Must be unique Asc/Asc handler + datavalue

messageinbound_datakeys table relationships