Table testsql_comments.aqcontacts Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int 10  √ 
z3950servers.id Implied Constraint R
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 mediumtext 16777215  √  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
aqbooksellers.id booksellerid_aqcontacts_fk C

Table contained 0 rows at Mon Jun 26 09:07 NZST 2017

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

Close relationships  within of separation: