m_client

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
m_account_transfer_details.from_client_id FK_m_account_transfer_details_from_client R
m_account_transfer_details.to_client_id FK_m_account_transfer_details_to_client R
m_client_address.client_id clientaddressfk R
m_client_attendance.client_id FK_m_client_m_client_attendance R
m_client_charge.client_id FK_m_client_charge_m_client R
m_client_collateral_management.client_id fkClient C
m_client_identifier.client_id FK_m_client_document_m_client R
m_client_non_person.client_id FK_client_id R
m_client_transaction.client_id FK_m_client_transaction_m_client R
m_client_transfer_details.client_id FK_m_client_transfer_details_m_client R
m_family_members.client_id FK_m_family_members_client_id_m_client R
m_group_client.client_id m_group_client_ibfk_2 R
m_group_roles.client_id FKGroupRoleClientId R
m_loan.client_id fkb6f935d87179a0cb R
m_note.client_id fk7c970897179a0cb R
m_savings_account.client_id fksa00000000000001 R
m_share_account.client_id m_share_account_ibfk_9 R
m_survey_scorecards.client_id m_survey_scorecards_ibfk_5 R
m_wc_loan.client_id FK_m_wc_loan_client R
scheduled_email_messages_outbound.client_id sefkclient00000001 R
sms_messages_outbound.client_id fkclient00000001 R
account_no varchar 20 null
external_id varchar 100 √ null
status_enum int4 10 300
sub_status int4 10 √ null
m_code_value.id FK_m_client_substatus_m_code_value R
activation_date date 13 √ null
office_joining_date date 13 √ null
office_id int8 19 null
m_office.id fkce00cab3e0dd567a R
transfer_to_office_id int8 19 √ null
m_office.id FK_m_client_m_office R
staff_id int8 19 √ null
m_staff.id FK_m_client_m_staff R
firstname varchar 50 √ null
middlename varchar 50 √ null
lastname varchar 50 √ null
fullname varchar 160 √ null
display_name varchar 160 null
mobile_no varchar 50 √ null
is_staff bool 1 false
gender_cv_id int4 10 √ null
m_code_value.id FK1_m_client_gender_m_code_value R
date_of_birth date 13 √ null
image_id int8 19 √ null
m_image.id FK_m_client_m_image R
closure_reason_cv_id int4 10 √ null
m_code_value.id FK_m_client_m_code R
closedon_date date 13 √ null
updated_by int8 19 √ null
updated_on date 13 √ null
submittedon_date date 13 √ null
activatedon_userid int8 19 √ null
closedon_userid int8 19 √ null
default_savings_product int8 19 √ null
m_savings_product.id FK_m_client_m_savings_product R
default_savings_account int8 19 √ null
m_savings_account.id FK_m_client_m_savings_account R
client_type_cv_id int4 10 √ null
m_code_value.id FK_m_client_type_m_code_value R
client_classification_cv_id int4 10 √ null
m_code_value.id FK_m_client_classification_m_code_value R
reject_reason_cv_id int4 10 √ null
m_code_value.id FK_m_client_type_mcode_value_reject R
rejectedon_date date 13 √ null
rejectedon_userid int8 19 √ null
withdraw_reason_cv_id int4 10 √ null
m_code_value.id FK_m_client_type_m_code_value_withdraw R
withdrawn_on_date date 13 √ null
withdraw_on_userid int8 19 √ null
reactivated_on_date date 13 √ null
reactivated_on_userid int8 19 √ null
legal_form_enum int4 10 √ null
reopened_on_date date 13 √ null
reopened_by_userid int8 19 √ null
email_address varchar 254 √ null
proposed_transfer_date date 13 √ null
created_on_utc timestamptz 35,6 null
created_by int8 19 null
m_appuser.id FK_client_created_by R
last_modified_by int8 19 null
m_appuser.id FK_client_last_modified_by R
last_modified_on_utc timestamptz 35,6 null

Indexes

Constraint Name Type Sort Column(s)
m_client_pkey Primary key Asc id
client_staff_id Performance Asc staff_id
FK1_m_client_gender_m_code_value Performance Asc gender_cv_id
FK_m_client_classification_m_code_value Performance Asc client_classification_cv_id
FK_m_client_m_code Performance Asc closure_reason_cv_id
FK_m_client_m_image Performance Asc image_id
FK_m_client_m_office Performance Asc transfer_to_office_id
FK_m_client_m_savings_account Performance Asc default_savings_account
FK_m_client_m_savings_product Performance Asc default_savings_product
FK_m_client_substatus_m_code_value Performance Asc sub_status
FK_m_client_type_m_code_value Performance Asc client_type_cv_id
FK_m_client_type_m_code_value_withdraw Performance Asc withdraw_reason_cv_id
FK_m_client_type_mcode_value_reject Performance Asc reject_reason_cv_id
fkce00cab3e0dd567a Performance Asc office_id
m_client_account_no_key Must be unique Asc account_no
m_client_external_id_key Must be unique Asc external_id
m_client_mobile_no_key Must be unique Asc mobile_no

Relationships

Close relationships within degrees of separation