m_note

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
client_id int8 19 √ null
m_client.id fk7c970897179a0cb R
group_id int8 19 √ null
m_group.id FK_m_note_m_group R
loan_id int8 19 √ null
m_loan.id fk7c9708940be0710 R
loan_transaction_id int8 19 √ null
m_loan_transaction.id fk7c9708924d26803 R
savings_account_id int8 19 √ null
m_savings_account.id FK_savings_account_id R
savings_account_transaction_id int8 19 √ null
share_account_id int8 19 √ null
note_type_enum int2 5 null
note text 2147483647 √ null
created_date timestamp 29,6 √ null
created_by int8 19 null
m_appuser.id fk7c97089541f0a56 R
lastmodified_date timestamp 29,6 √ null
last_modified_by int8 19 null
m_appuser.id fk7c970898f889c3f R
created_on_utc timestamptz 35,6 null
last_modified_on_utc timestamptz 35,6 null

Indexes

Constraint Name Type Sort Column(s)
m_note_pkey Primary key Asc id
fk7c9708924d26803 Performance Asc loan_transaction_id
fk7c9708940be0710 Performance Asc loan_id
fk7c97089541f0a56 Performance Asc created_by
fk7c970897179a0cb Performance Asc client_id
fk7c970898f889c3f Performance Asc last_modified_by
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