| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| suggestionid | INT | 10 | √ | null |
|
|
unique identifier assigned automatically by Koha |
|||
| suggestedby | INT | 10 | √ | null |
|
|
borrowernumber for the person making the suggestion, foreign key linking to the borrowers table |
|||
| suggesteddate | DATE | 10 | null |
|
|
date the suggestion was submitted |
||||
| managedby | INT | 10 | √ | null |
|
|
borrowernumber for the librarian managing the suggestion, foreign key linking to the borrowers table |
|||
| manageddate | DATE | 10 | √ | null |
|
|
date the suggestion was updated |
|||
| acceptedby | INT | 10 | √ | null |
|
|
borrowernumber for the librarian who accepted the suggestion, foreign key linking to the borrowers table |
|||
| accepteddate | DATE | 10 | √ | null |
|
|
date the suggestion was marked as accepted |
|||
| rejectedby | INT | 10 | √ | null |
|
|
borrowernumber for the librarian who rejected the suggestion, foreign key linking to the borrowers table |
|||
| rejecteddate | DATE | 10 | √ | null |
|
|
date the suggestion was marked as rejected |
|||
| lastmodificationby | INT | 10 | √ | null |
|
|
borrowernumber for the librarian who edit the suggestion for the last time |
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | suggestionid |
| acceptedby | Performance | Asc | acceptedby |
| biblionumber | Performance | Asc | biblionumber |
| branchcode | Performance | Asc | branchcode |
| budgetid | Performance | Asc | budgetid |
| managedby | Performance | Asc | managedby |
| rejectedby | Performance | Asc | rejectedby |
| status | Performance | Asc | STATUS |
| suggestedby | Performance | Asc | suggestedby |
| suggestions_ibfk_lastmodificationby | Performance | Asc | lastmodificationby |
