illcomments

0 rows


Columns

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

Unique ID of the comment

illrequest_id BIGINT UNSIGNED 20 null
illrequests.illrequest_id illcomments_ifk C

ILL request number

borrowernumber INT 10 null
borrowers.borrowernumber illcomments_bnfk C

Link to the user who made the comment (could be librarian, patron or ILL partner library)

comment TEXT 65535 null

The text of the comment

timestamp TIMESTAMP 19 current_timestamp()

Date and time when the comment was made

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc illcomment_id
illcomments_bnfk Performance Asc borrowernumber
illcomments_ifk Performance Asc illrequest_id

Relationships