borrower_relationships

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
guarantor_id INT 10 null
borrowers.borrowernumber r_guarantor C
guarantee_id INT 10 null
borrowers.borrowernumber r_guarantee C
relationship VARCHAR 100 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
guarantor_guarantee_idx Must be unique Asc/Asc guarantor_id + guarantee_id
r_guarantee Performance Asc guarantee_id

Relationships

Close relationships within degrees of separation