m_group

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
glim_accounts.group_id FK_group_id R
gsim_accounts.group_id FK_gsim_group_id R
m_group.parent_id Parent_Id_reference R
m_group_client.group_id m_group_client_ibfk_1 R
m_group_roles.group_id FKGroupRoleGroupId R
m_loan.group_id m_loan_ibfk_1 R
m_note.group_id FK_m_note_m_group R
m_savings_account.group_id fksa00000000000002 R
m_staff_assignment_history.centre_id FK_m_staff_assignment_history_centre_id_m_group R
scheduled_email_messages_outbound.group_id sefkgroup000000001 R
sms_messages_outbound.group_id fkgroup000000001 R
external_id varchar 100 √ null
status_enum int4 10 300
activation_date date 13 √ null
office_id int8 19 null
m_office.id m_group_ibfk_1 R
staff_id int8 19 √ null
m_staff.id FK_m_group_m_staff R
parent_id int8 19 √ null
m_group.id Parent_Id_reference R
level_id int4 10 null
m_group_level.id FK_m_group_level R
display_name varchar 100 null
hierarchy varchar 100 √ null
closure_reason_cv_id int4 10 √ null
m_code_value.id FK_m_group_m_code R
closedon_date date 13 √ null
activatedon_userid int8 19 √ null
submittedon_date date 13 √ null
submittedon_userid int8 19 √ null
closedon_userid int8 19 √ null
account_no varchar 20 null

Indexes

Constraint Name Type Sort Column(s)
m_group_pkey Primary key Asc 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
m_group_external_id_key Must be unique Asc external_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