Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
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 |
|
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 |