m_client

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
client_device_registration.client_id FK1_client_device_registration_m_clientR
m_account_transfer_details.from_client_id FK_m_account_transfer_details_from_clientR
m_account_transfer_details.to_client_id FK_m_account_transfer_details_to_clientR
m_client_address.client_id clientaddressfkR
m_client_attendance.client_id FK_m_client_m_client_attendanceR
m_client_charge.client_id FK_m_client_charge_m_clientR
m_client_collateral_management.client_id fkClientC
m_client_identifier.client_id FK_m_client_document_m_clientR
m_client_non_person.client_id FK_client_idR
m_client_transaction.client_id FK_m_client_transaction_m_clientR
m_client_transfer_details.client_id FK_m_client_transfer_details_m_clientR
m_family_members.client_id FK_m_family_members_client_id_m_clientR
m_group_client.client_id m_group_client_ibfk_2R
m_group_roles.client_id FKGroupRoleClientIdR
m_loan.client_id FKB6F935D87179A0CBR
m_note.client_id FK7C970897179A0CBR
m_savings_account.client_id FKSA00000000000001R
m_selfservice_user_client_mapping.client_id m_selfservice_client_idR
m_share_account.client_id m_share_account_ibfk_9R
m_survey_scorecards.client_id m_survey_scorecards_ibfk_5R
request_audit_table.client_id FK1_request_audit_table_m_clientR
scheduled_email_messages_outbound.client_id SEFKCLIENT00000001R
sms_messages_outbound.client_id FKCLIENT00000001R
account_no VARCHAR 20 null
external_id VARCHAR 100 √ NULL
status_enum INT 10 300
sub_status INT 10 √ NULL
m_code_value.id FK_m_client_substatus_m_code_valueR
activation_date DATE 10 √ NULL
office_joining_date DATE 10 √ NULL
office_id BIGINT 19 null
m_office.id FKCE00CAB3E0DD567AR
transfer_to_office_id BIGINT 19 √ NULL
m_office.id FK_m_client_m_officeR
staff_id BIGINT 19 √ NULL
m_staff.id FK_m_client_m_staffR
firstname VARCHAR 50 √ NULL
middlename VARCHAR 50 √ NULL
lastname VARCHAR 50 √ NULL
fullname VARCHAR 100 √ NULL
display_name VARCHAR 100 null
mobile_no VARCHAR 50 √ NULL
is_staff BIT 1 b'0'
gender_cv_id INT 10 √ NULL
m_code_value.id FK1_m_client_gender_m_code_valueR
date_of_birth DATE 10 √ NULL
image_id BIGINT 19 √ NULL
m_image.id FK_m_client_m_imageR
closure_reason_cv_id INT 10 √ NULL
m_code_value.id FK_m_client_m_codeR
closedon_date DATE 10 √ NULL
updated_by BIGINT 19 √ NULL
updated_on DATE 10 √ NULL
submittedon_date DATE 10 √ NULL
submittedon_userid BIGINT 19 √ NULL
activatedon_userid BIGINT 19 √ NULL
closedon_userid BIGINT 19 √ NULL
default_savings_product BIGINT 19 √ NULL
m_savings_product.id FK_m_client_m_savings_productR
default_savings_account BIGINT 19 √ NULL
m_savings_account.id FK_m_client_m_savings_accountR
client_type_cv_id INT 10 √ NULL
m_code_value.id FK_m_client_type_m_code_valueR
client_classification_cv_id INT 10 √ NULL
m_code_value.id FK_m_client_classification_m_code_valueR
reject_reason_cv_id INT 10 √ NULL
m_code_value.id FK_m_client_type_mcode_value_rejectR
rejectedon_date DATE 10 √ NULL
rejectedon_userid BIGINT 19 √ NULL
withdraw_reason_cv_id INT 10 √ NULL
m_code_value.id FK_m_client_type_m_code_value_withdrawR
withdrawn_on_date DATE 10 √ NULL
withdraw_on_userid BIGINT 19 √ NULL
reactivated_on_date DATE 10 √ NULL
reactivated_on_userid BIGINT 19 √ NULL
legal_form_enum INT 10 √ NULL
reopened_on_date DATE 10 √ NULL
reopened_by_userid BIGINT 19 √ NULL
email_address VARCHAR 150 √ NULL
proposed_transfer_date DATE 10 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
account_no Must be unique Asc account_no
client_staff_id Performance Asc staff_id
external_id Must be unique Asc external_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
mobile_no Must be unique Asc mobile_no

Relationships

Close relationships within degrees of separation