| 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_ibfk1 C
|
|
the user who created the problem report |
| branchcode |
VARCHAR |
10 |
|
|
|
|
|
branches.branchcode
|
problem_reports_ibfk2 C
|
|
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 |
