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