m_portfolio_command_source

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
action_name varchar 50 null
entity_name varchar 50 null
office_id int8 19 √ null
group_id int8 19 √ null
client_id int8 19 √ null
loan_id int8 19 √ null
savings_account_id int8 19 √ null
api_get_url varchar 100 null
resource_id int8 19 √ null
subresource_id int8 19 √ null
command_as_json text 2147483647 null
maker_id int8 19 null
m_appuser.id FK_m_maker_m_appuser R
made_on_date timestamp 29,6 √ null
checker_id int8 19 √ null
m_appuser.id FK_m_checker_m_appuser R
checked_on_date timestamp 29,6 √ null
status int2 5 null
product_id int8 19 √ null
transaction_id varchar 100 √ null
creditbureau_id int8 19 √ null
organisation_creditbureau_id int8 19 √ null
made_on_date_utc timestamptz 35,6 null
checked_on_date_utc timestamptz 35,6 √ null
job_name varchar 100 √ null
idempotency_key varchar 50 NULL::character varying
resource_external_id varchar 100 √ null
subresource_external_id varchar 100 √ null
result text 2147483647 √ null
result_status_code int4 10 √ null
loan_external_id varchar 100 √ null
is_sanitized bool 1 false
client_ip varchar 100 √ null

Indexes

Constraint Name Type Sort Column(s)
m_portfolio_command_source_pkey Primary key Asc id
action_name Performance Asc action_name
checked_on_date Performance Asc checked_on_date
entity_name Performance Asc/Asc entity_name + resource_id
FK_m_checker_m_appuser Performance Asc checker_id
FK_m_maker_m_appuser Performance Asc maker_id
made_on_date Performance Asc made_on_date
portfolio_command_source_composite_index Performance Asc/Asc/Asc action_name + entity_name + idempotency_key
portfolio_command_source_office_id Performance Asc office_id
processing_result_enum Performance Asc status
unique_portfolio_command_source Must be unique Asc/Asc/Asc action_name + entity_name + idempotency_key

Relationships

Close relationships within degrees of separation