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 |
|
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 |
|
streetnumber | TINYTEXT | 255 | √ | null |
|
|
the house number for your patron/borrower’s primary address |
|
streettype | TINYTEXT | 255 | √ | null |
|
|
the street type (Rd., Blvd, etc) for your patron/borrower’s primary address |
|
address | LONGTEXT | 2147483647 | √ | null |
|
|
the first address line for your patron/borrower’s primary address |