| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| illrequest_id | BIGINT UNSIGNED | 20 | √ | null |
|
|
||||||
| borrowernumber | INT | 10 | √ | null |
|
|
||||||
| biblio_id | INT | 10 | √ | null |
|
|
||||||
| branchcode | VARCHAR | 50 | null |
|
|
|||||||
| status | VARCHAR | 50 | √ | null |
|
|
||||||
| status_alias | VARCHAR | 80 | √ | null |
|
|
||||||
| placed | DATE | 10 | √ | null |
|
|
||||||
| replied | DATE | 10 | √ | null |
|
|
||||||
| updated | TIMESTAMP | 19 | current_timestamp() |
|
|
|||||||
| completed | DATE | 10 | √ | null |
|
|
