m_note

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
client_id BIGINT 19 √ NULL
m_client.id FK7C970897179A0CBR
group_id BIGINT 19 √ NULL
m_group.id FK_m_note_m_groupR
loan_id BIGINT 19 √ NULL
m_loan.id FK7C9708940BE0710R
loan_transaction_id BIGINT 19 √ NULL
m_loan_transaction.id FK7C9708924D26803R
savings_account_id BIGINT 19 √ NULL
m_savings_account.id FK_savings_account_idR
savings_account_transaction_id BIGINT 19 √ NULL
share_account_id BIGINT 19 √ NULL
note_type_enum SMALLINT 5 null
note VARCHAR 1000 √ NULL
created_date DATETIME 19 √ NULL
createdby_id BIGINT 19 √ NULL
m_appuser.id FK7C97089541F0A56R
lastmodified_date DATETIME 19 √ NULL
lastmodifiedby_id BIGINT 19 √ NULL
m_appuser.id FK7C970898F889C3FR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK7C9708924D26803 Performance Asc loan_transaction_id
FK7C9708940BE0710 Performance Asc loan_id
FK7C97089541F0A56 Performance Asc createdby_id
FK7C970897179A0CB Performance Asc client_id
FK7C970898F889C3F Performance Asc lastmodifiedby_id
FK_m_note_m_group Performance Asc group_id
FK_savings_account_id Performance Asc savings_account_id
savings_account_transaction_id Performance Asc savings_account_transaction_id

Relationships

Close relationships within degrees of separation