tickets

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
ticket_updates.ticket_id ticket_updates_ibfk_1C

primary key
reporter_id INT 10 0
borrowers.borrowernumber tickets_ibfk_1C

id of the patron who reported the ticket
reported_date TIMESTAMP 19 current_timestamp()

date and time this ticket was reported
title TEXT 65535 null

ticket title
body TEXT 65535 null

ticket details
resolver_id INT 10 √ null
borrowers.borrowernumber tickets_ibfk_2C

id of the user who resolved the ticket
resolved_date DATETIME 19 √ null

date and time this ticket was resolved
biblio_id INT 10 √ null
biblio.biblionumber tickets_ibfk_3C

id of biblio linked

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
tickets_ibfk_1 Performance Asc reporter_id
tickets_ibfk_2 Performance Asc resolver_id
tickets_ibfk_3 Performance Asc biblio_id

Relationships

Close relationships within degrees of separation