linktracker


Columns

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

primary key identifier

biblionumber INT 10 null

biblionumber of the record the link is from

itemnumber INT 10 null

itemnumber if applicable that the link was from

borrowernumber INT 10 null

borrowernumber who clicked the link

url MEDIUMTEXT 16777215 null

the link itself

timeclicked DATETIME 19 null

the date and time the link was clicked

Table contained 0 rows

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