account_transaction_status_history

-1 rows


Description

Table represents the status history of each account transaction. There may be several transaction statuses or states for each transaction over time

Columns

Column Type Size Nulls Auto Default Children Parents Comments
account_transaction_id int8 19 √ null
account_transaction.account_transaction_id account_transaction_status_history_account_transaction_id_fkey R

Ref: Many-to-one with account_transaction
account_transaction_status_history_timestamp timestamptz 35,6 √ null

Time the status change occurred
transaction_locked_until timestamptz 35,6 √ null

Time the status became/becomes active
dim_account_transaction_status_id int4 10 √ null
dim_account_transaction_status.dim_account_transaction_status_id account_transaction_status_history_dim_atsid_fkey R

See table dim_account_transaction_status
account_transaction_status_history_event_timestamp timestamptz 35,6 √ null

Time when the business event occured

Indexes

Constraint Name Type Sort Column(s)
idx_account_transaction_status_history_event_timestamp Performance Asc account_transaction_status_history_event_timestamp
idx_account_transaction_status_history_greatest_timestamp Performance
idx_account_transaction_status_history_id Performance Asc account_transaction_id
idx_account_transaction_status_history_timestamp Performance Asc account_transaction_status_history_timestamp
idx_account_transaction_status_history_transaction_locked_until Performance Asc transaction_locked_until

Relationships

Close relationships within degrees of separation