illcomments


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
borrowernumber INT 10 null
borrowers.borrowernumber illcomments_bnfk C
comment TEXT 65535 null
timestamp TIMESTAMP 19 current_timestamp()

Date and time when the comment was made

Table contained 0 rows

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