Page History
...
Need to amend statistics table
The Statistics table now lacks data that is required to determine the nature of actions from th statistical point of view, e.g. at the end of the year. Checking the data from elsewhere will produce skewed results, if, for example, a patron's status changes during the year. A few additions could make data significantly more reliable.
...
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| datetime | DATETIME | 19 | √ | null | date and time of the transaction | |||
| branch | VARCHAR | 10 | √ | null | foreign key, branch where the transaction occurred | |||
| value | DOUBLE | 16,4 | √ | null | monetary value associated with the transaction | |||
| type | VARCHAR | 16 | √ | null | transaction type (localuse, issue, return, renew, writeoff, payment) | |||
| other | LONGTEXT | 2147483647 | √ | null | used by SIP | |||
| itemnumber | INT | 10 | √ | null | foreign key from the items table, links transaction to a specific item | |||
| itemtype | VARCHAR | 10 | √ | null | foreign key from the itemtypes table, links transaction to a specific item type | |||
| location | VARCHAR | 80 | √ | null | authorized value for the shelving location for this item (MARC21 952$c) | |||
| borrowernumber | INT | 10 | √ | null | kirjasto | |||
| ccode | VARCHAR | 80 | √ | null |
Suggestions for added
...
data
- Patron data
- categorycode, patron group
- borrower_attributes: STAT_CAT, statistics group
branchcode, home library. Not used or maintained by all libraries.
- Item data
- homebrach,
- itemcallnumber,
- Method of issuing
- More exactly, data on the API used. Staff member, SIP, other API...