| message_id |
INT |
10 |
|
√ |
null |
|
|
unique identifier assigned by Koha |
| borrowernumber |
INT |
10 |
|
|
null |
|
|
borrowers.borrowernumber
|
messages_borrowernumber C
|
|
foreign key linking this message to the borrowers table |
| branchcode |
VARCHAR |
10 |
√ |
|
null |
|
|
foreign key linking the message to the branches table |
| message_type |
VARCHAR |
1 |
|
|
null |
|
|
whether the message is for the librarians (L) or the patron (B) |
| message |
MEDIUMTEXT |
16777215 |
|
|
null |
|
|
the text of the message |
| message_date |
TIMESTAMP |
19 |
|
|
current_timestamp() |
|
|
the date and time the message was written |
| manager_id |
INT |
10 |
√ |
|
null |
|
|
creator of message |
