m_guarantor

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
m_guarantor_funding_details.guarantor_id FK_m_guarantor_fund_details_m_guarantor R
loan_id int8 19 null
m_loan.id FK_m_guarantor_m_loan R
client_reln_cv_id int4 10 √ null
m_code_value.id FK_m_guarantor_m_code_value R
type_enum int2 5 null
entity_id int8 19 √ null
firstname varchar 50 √ null
lastname varchar 50 √ null
dob date 13 √ null
address_line_1 varchar 500 √ null
address_line_2 varchar 500 √ null
city varchar 50 √ null
state varchar 50 √ null
country varchar 50 √ null
zip varchar 20 √ null
house_phone_number varchar 20 √ null
mobile_number varchar 20 √ null
comment varchar 500 √ null
is_active bool 1 true

Indexes

Constraint Name Type Sort Column(s)
m_guarantor_pkey Primary key Asc id
FK_m_guarantor_m_code_value Performance Asc client_reln_cv_id
FK_m_guarantor_m_loan Performance Asc loan_id

Relationships

Close relationships within degrees of separation