<<

NAME

Koha::Schema::Result::Aqbasket

TABLE: aqbasket

ACCESSORS

basketno

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

primary key, Koha defined number

basketname

  data_type: 'varchar'
  is_nullable: 1
  size: 50

name given to the basket at creation

note

  data_type: 'longtext'
  is_nullable: 1

the internal note added at basket creation

booksellernote

  data_type: 'longtext'
  is_nullable: 1

the vendor note added at basket creation

contractnumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

links this basket to the aqcontract table (aqcontract.contractnumber)

creationdate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date the basket was created

closedate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date the basket was closed

booksellerid

  data_type: 'integer'
  default_value: 1
  is_foreign_key: 1
  is_nullable: 0

the Koha assigned ID for the vendor (aqbooksellers.id)

authorisedby

  data_type: 'varchar'
  is_nullable: 1
  size: 10

the borrowernumber of the person who created the basket

booksellerinvoicenumber

  data_type: 'longtext'
  is_nullable: 1

appears to always be NULL

basketgroupid

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

links this basket to its group (aqbasketgroups.id)

deliveryplace

  data_type: 'varchar'
  is_nullable: 1
  size: 10

basket delivery place

billingplace

  data_type: 'varchar'
  is_nullable: 1
  size: 10

basket billing place

branch

  data_type: 'varchar'
  is_foreign_key: 1
  is_nullable: 1
  size: 10

basket branch

is_standing

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

orders in this basket are standing

create_items

  data_type: 'enum'
  extra: {list => ["ordering","receiving","cataloguing"]}
  is_nullable: 1

when items should be created for orders in this basket

PRIMARY KEY

RELATIONS

aqbasketusers

Type: has_many

Related object: Koha::Schema::Result::Aqbasketuser

aqorders

Type: has_many

Related object: Koha::Schema::Result::Aqorder

basketgroupid

Type: belongs_to

Related object: Koha::Schema::Result::Aqbasketgroup

booksellerid

Type: belongs_to

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

branch

Type: belongs_to

Related object: Koha::Schema::Result::Branch

contractnumber

Type: belongs_to

Related object: Koha::Schema::Result::Aqcontract

edifact_messages

Type: has_many

Related object: Koha::Schema::Result::EdifactMessage

borrowernumbers

Type: many_to_many

Composing rels: "aqbasketusers" -> borrowernumber

<<