GATEWAY
ORGANIZATIONS
SERVICES
MODELS
ORGANIZATIONS
organization_id
organization_type
organization_name
organization_code
organization_registration_number
organization_created_at
organization_updated_at
organization_deleted_at
organization_record_hash
BRANCHES
branch_id
branch_type
branch_name
branch_code
branch_residential_address
branch_postal_address
branch_phone
branch_mobile
branch_email
branch_website
branch_created_at
branch_updated_at
organization_id
branch_record_hash
DEPARTMENTS
department_id
department_type
department_name
department_code
department_created_at
department_updated_at
department_record_hash
CUSTOMERS
SERVICES
MODELS
CUSTOMERS
customer_id
customer_type
customer_firstname customer_middlename customer_lastname
customer_username
customer_password customer_password_hash
customer_pin customer_residential_address customer_postal_address customer_phone
customer_mobile
customer_email
customer_created_at customer_updated_at customer_branch_id customer_record_hash
CUSTOMER GROUPS
customer_group_id
customer_group_type customer_group_name customer_group_code customer_group_created_at customer_group_updated_at customer_group_record_hash
FINANCIAL TRANSACTIONS
SERVICES
DATABASES
FINANCIAL ACCOUNTS
SERVICES
DATABASES
REPORTING
SERVICES
DATABASES
INTEGRATIONS
SERVICES
DATABASES
AUDIT TRAIL
SERVICES
DATABASES
AUTHENTICATION
SERVICES
MODELS
USERS
user_id
user_firstname
user_middlename
user_lastname
user_username
user_password
user_password_hash
user_pin
user_residential_address
user_postal_address
user_phone
user_mobile
user_email
user_created_at
user_updated_at
user_department_id
user_branch_id
user_record_hash
ROLES
role_id
role_type
role_name
role_code
role_created_at
role_updated_at
role_record_hash
PERMISSIONS
permission_id
permission_type
permission_name
permission_code
permission_created_at
permission_updated_at
permission_record_hash
USER_ROLES
user_role_id
user_role_user_id
user_role_role_id
user_role_role_code
user_role_created_at
user_role_updated_at
user_role_record_hash
USER_PERMISSION
user_permission_id
user_permission_user_id
user_permission_role_id
user_permission_role_code
user_permission_created_at
user_permission_updated_at
user_permission_record_hash
SYSTEM
SERVICES
MODELS
USER PRIVILEGES
NOTIFICATIONS