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

unique identifier assigned by Koha

borrowernumber INT 10 null

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
borrowers.borrowernumber messages_ibfk_1 N

creator of message

Table contained 0 rows


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc message_id
messages_ibfk_1 Performance Asc manager_id