NAME

Koha::Schema::Result::Booking

TABLE: `bookings`

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

primary key

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

foreign key from the borrowers table defining which patron this booking is for

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

foreign key from the biblio table defining which bib record this booking is on

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

foreign key from the items table defining the specific item the patron has placed a booking for

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

Identifier for booking pickup library

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the start date of the booking

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the end date of the booking

  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: current_timestamp
  is_nullable: 0

the timestamp for when a booking was created

  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: current_timestamp
  is_nullable: 0

the timestamp for when a booking has been updated

  data_type: 'enum'
  default_value: 'new'
  extra: {list => ["new","cancelled","completed"]}
  is_nullable: 0

current status of the booking

  data_type: 'varchar'
  is_nullable: 1
  size: 80

optional authorised value BOOKING_CANCELLATION

Type: belongs_to

Type: belongs_to

Type: belongs_to

Type: belongs_to