<<

NAME

Koha::Schema::Result::Ticket

TABLE: tickets

ACCESSORS

id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

primary key

source

  data_type: 'enum'
  default_value: 'catalog'
  extra: {list => ["catalog"]}
  is_nullable: 0

source of ticket

reporter_id

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

id of the patron who reported the ticket

reported_date

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

date and time this ticket was reported

title

  data_type: 'text'
  is_nullable: 0

ticket title

body

  data_type: 'text'
  is_nullable: 0

ticket details

status

  data_type: 'varchar'
  is_nullable: 1
  size: 80

current status of the ticket

assignee_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

id of the user who this ticket is assigned to

resolver_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

id of the user who resolved the ticket

resolved_date

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

date and time this ticket was resolved

biblio_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

id of biblio linked

PRIMARY KEY

RELATIONS

assignee

Type: belongs_to

Related object: Koha::Schema::Result::Borrower

biblio

Type: belongs_to

Related object: Koha::Schema::Result::Biblio

reporter

Type: belongs_to

Related object: Koha::Schema::Result::Borrower

resolver

Type: belongs_to

Related object: Koha::Schema::Result::Borrower

ticket_updates

Type: has_many

Related object: Koha::Schema::Result::TicketUpdate

<<