m_group

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
glim_accounts.group_id FK_group_idR
gsim_accounts.group_id FK_gsim_group_idR
m_group.parent_id Parent_Id_referenceR
m_group_client.group_id m_group_client_ibfk_1R
m_group_roles.group_id FKGroupRoleGroupIdR
m_loan.group_id m_loan_ibfk_1R
m_note.group_id FK_m_note_m_groupR
m_savings_account.group_id FKSA00000000000002R
m_staff_assignment_history.centre_id FK_m_staff_assignment_history_centre_id_m_groupR
scheduled_email_messages_outbound.group_id SEFKGROUP000000001R
sms_messages_outbound.group_id FKGROUP000000001R
external_id VARCHAR 100 √ NULL
status_enum INT 10 300
activation_date DATE 10 √ NULL
office_id BIGINT 19 null
m_office.id m_group_ibfk_1R
staff_id BIGINT 19 √ NULL
m_staff.id FK_m_group_m_staffR
parent_id BIGINT 19 √ NULL
m_group.id Parent_Id_referenceR
level_id INT 10 null
m_group_level.id FK_m_group_levelR
display_name VARCHAR 100 null
hierarchy VARCHAR 100 √ NULL
closure_reason_cv_id INT 10 √ NULL
m_code_value.id FK_m_group_m_codeR
closedon_date DATE 10 √ NULL
activatedon_userid BIGINT 19 √ NULL
submittedon_date DATE 10 √ NULL
submittedon_userid BIGINT 19 √ NULL
closedon_userid BIGINT 19 √ NULL
account_no VARCHAR 20 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
external_id Must be unique Asc external_id
FK_m_group_level Performance Asc level_id
FK_m_group_m_code Performance Asc closure_reason_cv_id
group_office_id Performance Asc office_id
name Must be unique Asc/Asc display_name + level_id
Parent_Id_reference Performance Asc parent_id
staff_id Performance Asc staff_id
uk_m_group_external_id Must be unique Asc/Asc external_id + level_id

Relationships

Close relationships within degrees of separation