<<

NAME

Koha::Schema::Result::TicketUpdate

TABLE: ticket_updates

ACCESSORS

id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

primary key

ticket_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 0

id of catalog ticket the update relates to

user_id

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

id of the user who logged the update

assignee_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

id of the user who this ticket was assigned to at this update

public

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

boolean flag to denote whether this update is public

date

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

date and time this update was logged

message

  data_type: 'text'
  is_nullable: 0

update message content

status

  data_type: 'varchar'
  is_nullable: 1
  size: 80

status of ticket at this update

PRIMARY KEY

RELATIONS

assignee

Type: belongs_to

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

ticket

Type: belongs_to

Related object: Koha::Schema::Result::Ticket

user

Type: belongs_to

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

<<