| id |
INT |
10 |
|
√ |
null |
|
|
primary key |
| reporter_id |
INT |
10 |
|
|
0 |
|
|
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 |
|
|
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 |
