subscriptionhistory

Columns

Related columns Constraint Comments

Search:

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

Showing 1 to 8 of 8 entries

Table contained 0 rows

Indexes

Search:

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

Showing 1 to 2 of 2 entries