borrower_modifications

0 rows

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

timestamp

TIMESTAMP

19

CURRENT_TIMESTAMP

verification_token

VARCHAR

255

changed_fields

MEDIUMTEXT

16777215

√

null

borrowernumber

INT

10

0

cardnumber

VARCHAR

32

√

null

surname

LONGTEXT

2147483647

√

null

firstname

MEDIUMTEXT

16777215

√

null

title

LONGTEXT

2147483647

√

null

othernames

LONGTEXT

2147483647

√

null

initials

MEDIUMTEXT

16777215

√

null

Showing 1 to 10 of 71 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc/Asc	verification_token + borrowernumber
borrowernumber	Performance	Asc	borrowernumber
verification_token	Performance	Asc	verification_token

Showing 1 to 3 of 3 entries

Relationships

Close relationships within degrees of separation