linktracker

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null

primary key identifier

biblionumber INT 10 null
biblio.biblionumber linktracker_biblio_ibfkN

biblionumber of the record the link is from

itemnumber INT 10 null
items.itemnumber linktracker_item_ibfkN

itemnumber if applicable that the link was from

borrowernumber INT 10 null
borrowers.borrowernumber linktracker_borrower_ibfkN

borrowernumber who clicked the link

url MEDIUMTEXT 16777215 null

the link itself

timeclicked DATETIME 19 null

the date and time the link was clicked

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
bibidx Performance Asc biblionumber
borridx Performance Asc borrowernumber
dateidx Performance Asc timeclicked
itemidx Performance Asc itemnumber

Relationships