| 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 |
