<<

NAME

Koha::Schema::Result::Aqcontact

TABLE: aqcontacts

ACCESSORS

id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

primary key and unique number assigned by Koha

name

  data_type: 'varchar'
  is_nullable: 1
  size: 100

name of contact at vendor

position

  data_type: 'varchar'
  is_nullable: 1
  size: 100

contact person's position

phone

  data_type: 'varchar'
  is_nullable: 1
  size: 100

contact's phone number

altphone

  data_type: 'varchar'
  is_nullable: 1
  size: 100

contact's alternate phone number

fax

  data_type: 'varchar'
  is_nullable: 1
  size: 100

contact's fax number

email

  data_type: 'varchar'
  is_nullable: 1
  size: 100

contact's email address

notes

  data_type: 'longtext'
  is_nullable: 1

notes related to the contact

orderacquisition

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

should this contact receive acquisition orders

claimacquisition

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

should this contact receive acquisitions claims

claimissues

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

should this contact receive serial claims

acqprimary

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

is this the primary contact for acquisitions messages

serialsprimary

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

is this the primary contact for serials messages

booksellerid

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 0

PRIMARY KEY

RELATIONS

booksellerid

Type: belongs_to

Related object: Koha::Schema::Result::Aqbookseller

<<