items_last_borrower

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
itemnumber INT 10 null
items.itemnumber items_last_borrower_ibfk_1 C
borrowernumber INT 10 null
borrowers.borrowernumber items_last_borrower_ibfk_2 C
created_on TIMESTAMP 19 current_timestamp()

Indexes

Constraint Name Type Sort Column(s)
items_last_borrower_s_pk Primary key Asc id
borrowernumber Performance Asc borrowernumber
itemnumber Must be unique Asc itemnumber
PRIMARY Must be unique Asc id

Relationships

Close relationships within degrees of separation