erm_eholdings_resources

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
resource_id INT 10 √ null

primary key
title_id INT 10 null
erm_eholdings_titles.title_id erm_eholdings_resources_ibfk_1 C
package_id INT 10 null
erm_eholdings_packages.package_id erm_eholdings_resources_ibfk_2 C
vendor_id INT 10 √ null
aqbooksellers.id erm_eholdings_resources_ibfk_3 N
started_on DATE 10 √ null
ended_on DATE 10 √ null
proxy VARCHAR 80 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc resource_id
erm_eholdings_resources_ibfk_2 Performance Asc package_id
erm_eholdings_resources_ibfk_3 Performance Asc vendor_id
erm_eholdings_resources_uniq Must be unique Asc/Asc title_id + package_id

Relationships

Close relationships within degrees of separation