m_appuser

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
acc_gl_closure.createdby_id FK_acc_gl_closure_m_appuserR
acc_gl_closure.lastmodifiedby_id FK_acc_gl_closure_m_appuser_2R
acc_gl_journal_entry.createdby_id FK_acc_gl_journal_entry_m_appuserR
acc_gl_journal_entry.lastmodifiedby_id FK_acc_gl_journal_entry_m_appuser_2R
m_adhoc.createdby_id createdby_idR
m_adhoc.lastmodifiedby_id lastmodifiedby_idR
m_appuser_previous_password.user_id m_appuser_previous_password_ibfk_1R
m_appuser_role.appuser_id FK7662CE59B4100309R
m_client_transaction.appuser_id FK_m_client_transaction_m_appuserR
m_client_transfer_details.submitted_by FK_m_client_transfer_details_m_appuserR
m_import_document.createdby_id FK_m_import_m_appuserR
m_loan.approvedon_userid FK_approvedon_useridR
m_loan.closedon_userid FK_closedon_useridR
m_loan.disbursedon_userid FK_disbursedon_useridR
m_loan.rejectedon_userid FK_rejectedon_useridR
m_loan.submittedon_userid FK_submittedon_useridR
m_loan.withdrawnon_userid FK_withdrawnon_useridR
m_loan_reschedule_request.approved_by_user_id m_loan_reschedule_request_ibfk_4R
m_loan_reschedule_request.rejected_by_user_id m_loan_reschedule_request_ibfk_5R
m_loan_reschedule_request.submitted_by_user_id m_loan_reschedule_request_ibfk_3R
m_note.createdby_id FK7C97089541F0A56R
m_note.lastmodifiedby_id FK7C970898F889C3FR
m_pocket.app_user_id FK__m_appuser__pocketR
m_portfolio_command_source.checker_id FK_m_checker_m_appuserR
m_portfolio_command_source.maker_id FK_m_maker_m_appuserR
m_provisioning_criteria.createdby_id m_provisioning_criteria_ibfk_1R
m_provisioning_criteria.lastmodifiedby_id m_provisioning_criteria_ibfk_2R
m_provisioning_history.createdby_id m_provisioning_history_ibfk_1R
m_provisioning_history.lastmodifiedby_id m_provisioning_history_ibfk_2R
m_rate.approve_user FK_M_RATE_APPROVE_USERR
m_rate.createdby_id FK_M_RATE_CREATE_USERR
m_report_mailing_job.createdby_id m_report_mailing_job_ibfk_1R
m_report_mailing_job.lastmodifiedby_id m_report_mailing_job_ibfk_2R
m_report_mailing_job.run_as_userid m_report_mailing_job_ibfk_4R
m_selfservice_user_client_mapping.appuser_id m_selfservice_appuser_idR
m_share_account.activated_userid m_share_account_ibfk_6R
m_share_account.approved_userid m_share_account_ibfk_4R
m_share_account.closed_userid m_share_account_ibfk_7R
m_share_account.lastmodifiedby_id m_share_account_ibfk_8R
m_share_account.rejected_userid m_share_account_ibfk_5R
m_share_account.submitted_userid m_share_account_ibfk_3R
m_share_product.createdby_id m_share_product_ibfk_1R
m_share_product.lastmodifiedby_id m_share_product_ibfk_2R
m_share_product_dividend_pay_out.createdby_id FK_m_share_product_dividend_pay_out_createdby_idR
m_share_product_dividend_pay_out.lastmodifiedby_id FK_m_share_product_dividend_pay_out_lastmodifiedby_idR
m_survey_scorecards.user_id m_survey_scorecards_ibfk_4R
m_tax_component.createdby_id FK_tax_component_createdbyR
m_tax_component.lastmodifiedby_id FK_tax_component_lastmodifiedbyR
m_tax_component_history.createdby_id FK_tax_component_history_createdbyR
m_tax_component_history.lastmodifiedby_id FK_tax_component_history_lastmodifiedbyR
m_tax_group.createdby_id FK_tax_group_createdbyR
m_tax_group.lastmodifiedby_id FK_tax_group_lastmodifiedbyR
m_tax_group_mappings.createdby_id FK_tax_group_mappings_createdbyR
m_tax_group_mappings.lastmodifiedby_id FK_tax_group_mappings_lastmodifiedbyR
notification_mapper.user_id notification_mapper_ibfk_2R
topic_subscriber.user_id fk_topic_has_m_appuser_m_appuser1R
twofactor_access_token.appuser_id fk_2fa_access_token_user_idR
is_deleted BIT 1 b'0'
office_id BIGINT 19 √ NULL
m_office.id FKB3D587CE0DD567AR
staff_id BIGINT 19 √ NULL
m_staff.id fk_m_appuser_002R
username VARCHAR 100 null
firstname VARCHAR 100 null
lastname VARCHAR 100 null
password VARCHAR 255 null
email VARCHAR 100 null
firsttime_login_remaining BIT 1 null
nonexpired BIT 1 null
nonlocked BIT 1 null
nonexpired_credentials BIT 1 null
enabled BIT 1 null
last_time_password_updated DATE 10 '1970-01-01'
password_never_expires BIT 1 √ NULL

define if the password, should be check for validity period or not
is_self_service_user BIT 1 b'0'
cannot_change_password BIT 1 √ b'0'

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
fk_m_appuser_002x Performance Asc staff_id
FKB3D587CE0DD567A Performance Asc office_id
last_time_password_updated Performance Asc last_time_password_updated
username_org Must be unique Asc username

Relationships

Close relationships within degrees of separation