pending_action Table

This table lists the latest actions that have been recommended by the market. The table repopulates at a configurable interval (not necessarily every 10-minute market cycle). When it repopulates, all actions are replaced with the latest action recommendations.

This table does not include actions that are in progress.

pending_action

pending_action table

Column Name

Type

Nullable

Primary

Description

recommendation_time

timestamp with time zone

false

false

The time the action was recommended.

action_oid

bigint

false

false

oid of the action in the system.

type

action_type

false

false

The type of the action.

severity

severity

false

false

The severity of the action.

category

action_category

false

false

The category of the action.

target_entity_id

bigint

false

false

The oid of the target entity.

involved_entities

bigint[]

true

false

The oids of the involved entities (includes the target entity).

description

text

false

false

The text description of the action.

savings

double precision

false

false

Savings (or, if negative, investment) of the action.

attrs

jsonb

true

false

Additional (often type-specific) information for the action.

For example, in resizes this will contain the commodity type and from/to amounts.

Sample Use Cases

N/A