erm_eholdings_packages

0 rows


Columns

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') 5 √ 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

Indexes

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

Relationships

Close relationships within degrees of separation