m_staff

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
m_appuser.staff_id fk_m_appuser_002 R
m_cashiers.staff_id FK_m_cashiers_m_staff R
m_client.staff_id FK_m_client_m_staff R
m_group.staff_id FK_m_group_m_staff R
m_loan.loan_officer_id FK_m_loan_m_staff R
m_loan_officer_assignment_history.loan_officer_id fk_m_loan_officer_assignment_history_0002 R
m_savings_officer_assignment_history.savings_officer_id fk_m_savings_officer_assignment_history_0002 R
m_staff_assignment_history.staff_id FK_m_staff_assignment_history_m_staff R
scheduled_email_messages_outbound.staff_id sefkstaff000000001 R
sms_messages_outbound.staff_id fkstaff000000001 R
is_loan_officer bool 1 false
office_id int8 19 √ null
m_office.id FK_m_staff_m_office R
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 int2 5 √ null
organisational_role_parent_staff_id int8 19 √ null
is_active bool 1 true
joining_date date 13 √ null
image_id int8 19 √ null
m_image.id FK_m_staff_m_image R
email_address varchar 254 √ null

Indexes

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

Relationships

Close relationships within degrees of separation