m_staff

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
m_appuser.staff_id fk_m_appuser_002R
m_cashiers.staff_id FK_m_cashiers_m_staffR
m_client.staff_id FK_m_client_m_staffR
m_group.staff_id FK_m_group_m_staffR
m_loan.loan_officer_id FK_m_loan_m_staffR
m_loan_officer_assignment_history.loan_officer_id fk_m_loan_officer_assignment_history_0002R
m_savings_officer_assignment_history.savings_officer_id fk_m_savings_officer_assignment_history_0002R
m_staff_assignment_history.staff_id FK_m_staff_assignment_history_m_staffR
scheduled_email_messages_outbound.staff_id SEFKSTAFF000000001R
sms_messages_outbound.staff_id FKSTAFF000000001R
is_loan_officer BIT 1 b'0'
office_id BIGINT 19 √ NULL
m_office.id FK_m_staff_m_officeR
firstname VARCHAR 50 √ NULL
lastname VARCHAR 50 √ NULL
display_name VARCHAR 102 null
mobile_no VARCHAR 50 √ NULL
external_id VARCHAR 100 √ NULL
organisational_role_enum SMALLINT 5 √ NULL
organisational_role_parent_staff_id BIGINT 19 √ NULL
is_active BIT 1 b'1'
joining_date DATE 10 √ NULL
image_id BIGINT 19 √ NULL
m_image.id FK_m_staff_m_imageR
email_address VARCHAR 150 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
display_name Must be unique Asc display_name
external_id Must be unique Asc external_id
FK_m_staff_m_image Performance Asc image_id
FK_m_staff_m_office Performance Asc office_id
mobile_no Must be unique Asc mobile_no

Relationships

Close relationships within degrees of separation