m_guarantor

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
m_guarantor_funding_details.guarantor_id FK_m_guarantor_fund_details_m_guarantorR
loan_id BIGINT 19 null
m_loan.id FK_m_guarantor_m_loanR
client_reln_cv_id INT 10 √ NULL
m_code_value.id FK_m_guarantor_m_code_valueR
type_enum SMALLINT 5 null
entity_id BIGINT 19 √ NULL
firstname VARCHAR 50 √ NULL
lastname VARCHAR 50 √ NULL
dob DATE 10 √ 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 BIT 1 b'1'

Indexes

Constraint Name Type Sort Column(s)
PRIMARY 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