| id |
INT |
10 |
|
√ |
null |
|
|
primary key identifier |
| biblionumber |
INT |
10 |
√ |
|
null |
|
| biblio.biblionumber |
linktracker_biblio_ibfk |
N |
|
biblionumber of the record the link is from |
| itemnumber |
INT |
10 |
√ |
|
null |
|
| items.itemnumber |
linktracker_item_ibfk |
N |
|
itemnumber if applicable that the link was from |
| borrowernumber |
INT |
10 |
√ |
|
null |
|
| borrowers.borrowernumber |
linktracker_borrower_ibfk |
N |
|
borrowernumber who clicked the link |
| url |
MEDIUMTEXT |
16777215 |
√ |
|
null |
|
|
the link itself |
| timeclicked |
DATETIME |
19 |
√ |
|
null |
|
|
the date and time the link was clicked |
