account_balances

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

customer_id

int4

10

√

null

customer.customer_id

Implied Constraint

R

last_changed

timestamptz

35,6

√

null

account_balance

numeric

131089

√

null

Relationships

Close relationships within degrees of separation

View Definition

SELECT account_transaction.customer_id,
    max(recent_account_transaction_timestamp.account_transaction_status_history_timestamp) AS last_changed,
    sum(account_transaction.transaction_amount) AS account_balance
   FROM ((account_transaction
     JOIN ( SELECT account_transaction_status_history.account_transaction_id,
            account_transaction_status_history.dim_account_transaction_status_id,
            account_transaction_status_history.account_transaction_status_history_timestamp,
            rank() OVER (PARTITION BY account_transaction_status_history.account_transaction_id ORDER BY account_transaction_status_history.account_transaction_status_history_timestamp DESC) AS rnk
           FROM account_transaction_status_history
          WHERE ((GREATEST(account_transaction_status_history.account_transaction_status_history_timestamp, account_transaction_status_history.transaction_locked_until, account_transaction_status_history.account_transaction_status_history_event_timestamp))::date < CURRENT_DATE)) recent_account_transaction_timestamp USING (account_transaction_id))
     JOIN dim_account_transaction_status USING (dim_account_transaction_status_id))
  WHERE ((dim_account_transaction_status.account_transaction_status_name = 'NOT_LIMBO_COMMITTED'::text) AND (recent_account_transaction_timestamp.rnk = 1))
  GROUP BY account_transaction.customer_id;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views