Columns
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 |
|
|
creator of message |
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | message_id |
messages_borrowernumber | Performance | Asc | borrowernumber |
messages_ibfk_1 | Performance | Asc | manager_id |