subscriptionhistory


Columns

Column Type Size Nulls Auto Default Children Parents Comments
biblionumber INT 10 0
subscriptionid INT 10 0
histstartdate DATE 10 null
histenddate DATE 10 null
missinglist LONGTEXT 2147483647 null
recievedlist LONGTEXT 2147483647 null
opacnote VARCHAR 150
librariannote VARCHAR 150

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc subscriptionid
biblionumber Performance Asc biblionumber