audit

114 rows


Description

System table for PBJ platform. Table records the last updated timestamp for various tables on corresponding nodes which can be used to look up during ETL

Columns

Column Type Size Nulls Auto Default Children Parents Comments
table_name text 2147483647 null

Metrics table which was processed
node int4 10 null
last_checkout_update.node Implied Constraint R

PBJ node which was processed
updated timestamptz 35,6 to_date('0000-00-00'::text, 'YYYY-MM-DD'::text)

Time the node was last processed

Indexes

Constraint Name Type Sort Column(s)
audit_node Performance Asc node
audit_table_name Performance Asc table_name

Relationships

Close relationships within degrees of separation