0 rows


Column Type Size Nulls Auto Default Children Parents Comments
reportid INT 10 null

unique identifier assigned by Koha

title VARCHAR 40

report subject line

content VARCHAR 255

report message content

borrowernumber INT 10 0
borrowers.borrowernumber problem_reports_ibfk1C

the user who created the problem report

branchcode VARCHAR 10
branches.branchcode problem_reports_ibfk2C

borrower’s branch

username VARCHAR 75 null

OPAC username

problempage TEXT 65535 null

page the user triggered the problem report form from

recipient enum('admin', 'library') 7 library

the ‘to-address’ of the problem report

created_on TIMESTAMP 19 current_timestamp()

timestamp of report submission

status VARCHAR 6 New

status of the report. New, Viewed, Closed


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc reportid
problem_reports_ibfk1 Performance Asc borrowernumber
problem_reports_ibfk2 Performance Asc branchcode