subscriptionhistory

Columns

Related columns Constraint Comments

Search:

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

Showing 1 to 8 of 8 entries

Indexes

Search:

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

Showing 1 to 2 of 2 entries

Columns

Indexes

Relationships

Close relationships within degrees of separation