| id |
INT |
10 |
|
√ |
null |
|
|
primary key and unique number assigned by Koha |
| name |
VARCHAR |
100 |
√ |
|
null |
|
|
name of contact at vendor |
| position |
VARCHAR |
100 |
√ |
|
null |
|
|
contact person’s position |
| phone |
VARCHAR |
100 |
√ |
|
null |
|
|
contact’s phone number |
| altphone |
VARCHAR |
100 |
√ |
|
null |
|
|
contact’s alternate phone number |
| fax |
VARCHAR |
100 |
√ |
|
null |
|
|
contact’s fax number |
| email |
VARCHAR |
100 |
√ |
|
null |
|
|
contact’s email address |
| notes |
LONGTEXT |
2147483647 |
√ |
|
null |
|
|
notes related to the contact |
| orderacquisition |
BIT |
0 |
|
|
0 |
|
|
should this contact receive acquisition orders |
| claimacquisition |
BIT |
0 |
|
|
0 |
|
|
should this contact receive acquisitions claims |
