m_family_members

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
client_id int8 19 null
m_client.id FK_m_family_members_client_id_m_client R
firstname varchar 50 null
middlename varchar 50 √ null
lastname varchar 50 √ null
qualification varchar 50 √ null
relationship_cv_id int4 10 null
m_code_value.id FK_m_family_members_relationship_m_code_value R
marital_status_cv_id int4 10 √ null
m_code_value.id FK_m_family_members_marital_status_m_code_value R
gender_cv_id int4 10 √ null
m_code_value.id FK_m_family_members_gender_m_code_value R
date_of_birth date 13 √ null
age int4 10 √ null
profession_cv_id int4 10 √ null
m_code_value.id FK_m_family_members_profession_m_code_value R
mobile_number varchar 50 √ null
is_dependent bool 1 √ null

Indexes

Constraint Name Type Sort Column(s)
m_family_members_pkey Primary key Asc id
FK_m_family_members_client_id_m_client Performance Asc client_id
FK_m_family_members_gender_m_code_value Performance Asc gender_cv_id
FK_m_family_members_marital_status_m_code_value Performance Asc marital_status_cv_id
FK_m_family_members_profession_m_code_value Performance Asc profession_cv_id
FK_m_family_members_relationship_m_code_value Performance Asc relationship_cv_id

Relationships

Close relationships within degrees of separation