subscriptionhistory

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
biblionumber INT 10 null
biblio.biblionumber subscription_history_ibfk_1C
subscriptionid INT 10 null
subscription.subscriptionid subscription_history_ibfk_2C
histstartdate DATE 10 null
histenddate DATE 10 null
missinglist LONGTEXT 2147483647 null
recievedlist LONGTEXT 2147483647 null
opacnote LONGTEXT 2147483647 null
librariannote LONGTEXT 2147483647 null

Indexes

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

Relationships