Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
borrowernumber | INT | 10 | 0 |
|
|
primary key, Koha assigned ID number for patrons/borrowers |
||
cardnumber | VARCHAR | 32 | √ | null |
|
|
unique key, library assigned ID number for patrons/borrowers |
|
surname | LONGTEXT | 2147483647 | √ | null |
|
|
patron/borrower’s last name (surname) |
|
firstname | MEDIUMTEXT | 16777215 | √ | null |
|
|
patron/borrower’s first name |
|
middle_name | LONGTEXT | 2147483647 | √ | null |
|
|
patron/borrower’s middle name |
|
title | LONGTEXT | 2147483647 | √ | null |
|
|
patron/borrower’s title, for example: Mr. or Mrs. |
|
othernames | LONGTEXT | 2147483647 | √ | null |
|
|
any other names associated with the patron/borrower |
|
initials | MEDIUMTEXT | 16777215 | √ | null |
|
|
initials for your patron/borrower |
|
pronouns | LONGTEXT | 2147483647 | √ | null |
|
|
patron/borrower pronouns |
|
streetnumber | TINYTEXT | 255 | √ | null |
|
|
the house number for your patron/borrower’s primary address |