erm_eholdings_packages

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

package_id

INT

10

√

null

erm_eholdings_packages_agreements.package_id	erm_eholdings_packages_agreements_ibfk_1	C
erm_eholdings_resources.package_id	erm_eholdings_resources_ibfk_2	C

primary key

vendor_id

INT

10

√

null

aqbooksellers.id

erm_eholdings_packages_ibfk_1

N

foreign key to aqbooksellers

name

VARCHAR

255

null

items_search_fields.name

Implied Constraint

R

name of the package

external_id

VARCHAR

255

√

null

External key

provider

enum('ebsco')

6

√

null

External provider

package_type

VARCHAR

80

√

null

type of the package

content_type

VARCHAR

80

√

null

type of the package

notes

MEDIUMTEXT

16777215

√

null

notes about this package

created_on

TIMESTAMP

19

current_timestamp()

date of creation of the package

Showing 1 to 9 of 9 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	package_id
erm_eholdings_packages_ibfk_1	Performance	Asc	vendor_id

Showing 1 to 2 of 2 entries

Columns

Indexes

Relationships

Close relationships within degrees of separation