subscriptionhistory


Columns

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

Table contained 0 rows

Indexes

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

Relationships