alert


Columns

Column Type Size Nulls Auto Default Children Parents Comments
alertid INT 10 null
borrowernumber INT 10 0
type VARCHAR 10
externalid VARCHAR 20

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc alertid
borrowernumber Performance Asc borrowernumber
type Performance Asc/Asc type + externalid