m_portfolio_command_source

15 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
action_name VARCHAR 50 null
entity_name VARCHAR 50 null
office_id BIGINT 19 √ NULL
group_id BIGINT 19 √ NULL
client_id BIGINT 19 √ NULL
loan_id BIGINT 19 √ NULL
savings_account_id BIGINT 19 √ NULL
api_get_url VARCHAR 100 null
resource_id BIGINT 19 √ NULL
subresource_id BIGINT 19 √ NULL
command_as_json TEXT 65535 null
maker_id BIGINT 19 null
m_appuser.id FK_m_maker_m_appuserR
made_on_date DATETIME 19 null
checker_id BIGINT 19 √ NULL
m_appuser.id FK_m_checker_m_appuserR
checked_on_date DATETIME 19 √ NULL
processing_result_enum SMALLINT 5 null
product_id BIGINT 19 √ NULL
transaction_id VARCHAR 100 √ NULL
creditbureau_id BIGINT 19 √ NULL
organisation_creditbureau_id BIGINT 19 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY 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_office_id Performance Asc office_id
processing_result_enum Performance Asc processing_result_enum

Relationships

Close relationships within degrees of separation