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 |
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 |