Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | INT | 10 | √ | null |
|
|
primary key |
||||
| source | enum('catalog') | 7 | 'catalog' |
|
|
source of ticket |
|||||
| 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 |
|||||
| status | VARCHAR | 80 | √ | NULL |
|
|
current status of the ticket |
||||
| assignee_id | INT | 10 | √ | NULL |
|
|
id of the user this ticket is assigned to |
||||
| 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 |
|
|
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 |
| tickets_ibfk_4 | Performance | Asc | assignee_id |
Relationships
Close relationships within degrees of separation
