aqcontacts


Columns

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

claimissues BIT 0 0

should this contact receive serial claims

acqprimary BIT 0 0

is this the primary contact for acquisitions messages

serialsprimary BIT 0 0

is this the primary contact for serials messages

booksellerid INT 10 null
aqbooksellers.id booksellerid_aqcontacts_fk C

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
booksellerid_aqcontacts_fk Performance Asc booksellerid

Relationships